Nedd your help for space seperated data with some different format

alt_tush

Hi Team,

I have a space separated data in text file.

Format of the data are below :-

ABC20180322 00000MAR 0000000000000000000000000000000000000000000000000000000000

1 ABC 10 HR

2 DEF 20 ADMIN

3 PQR 30 IT

4 XYZ 40 HELPDESK

ABC20180322 00000MAR 0000000000000000000000000000000000000000000000000000000000

I want all the 4 records in excel in between first and last row.

First and last row should be ignore. Also there would be "N" number of records in between first and last row.

Please need your assistance here.

Please help

Thank you in advance.

Preparation

Accepted answers

BenMoss

Would a simple solution not be to use the sample tool.

First of all recordID your data.

Use the sample tool to 'skip the 1st n(1)' record.

Then sort your data on the recordID descending.

Use the sample tool again to 'skip the 1st n(1) record.

Resort your data back into the original order (ascending).

Ben

alt_tush

Yes Ben. Your are right

It works now.

Thank you so much for your help

All comments

LordNeilLord

Hey @alt_tush

If you're data is always going to be in that consistent format, I'd use regex to identify a pattern...for example the first column always contains a recordid...then you can filter out the fields you don't need.