lost with column searching

[ngkf7]

Hi,

I am trying to search a column for a row with specific values. Unfortunately, the data, when taken from the report, is poorly formatted and all in one row. Is there a way to search for a specific substring of the entire row? I have 3 different strings I need to search for in a single row, and this would be much easier than reformatting the report download every day. Case sensitivity is not an issue, since they are mostly strings of numbers.

Thanks

 

[dglnz]

Is the report fixed length?

Do you get a wizard appear when you open the file that lets you choose between a fixed length or variable length?

If so choose variable _or_ space seperated/comma file this then puts data into columns, after a couple of screens you have a listbox with what looks like arrows appear (you can move these to define the columns - you can also move 1 on top of the other to remove the line - merge two columns into 1)

Once finish is clicked you get a spreadsheet that has data split into columns.

Now you can Vlookup the data you want on the columns you want.

HTH.

dave

ps will try and do some screen shots for you tomorrow at work tho i'm a bit snowed under at present so it might be somedays before i do this.

to get an idea of what i'm talking about try doing this

this is 1 line of a small report!

column one,column two,column three
data 1,data 2,data3
Row 5, of this,report

***** End of REPORT! *****