PDA

View Full Version : export txt file data into excel and filter out req'd data



tinkerbell
10-21-2008, 09:36 PM
need help in exporting data in .txt format into Excel worksheet1 with data separated nicely into respective columns. the data size/no of pages varies daily

-> filter out "Counterpart" ending with /HKG /TPE /HSI /TTL /PE
-> filter out "XPOPTDELIV" with "0" and "2"
-> lookup filtered result's "Linktrade ID" in worksheet2 and return "FEDS" in worksheet1 coloumn beside "Linktrade ID" coloumn, else "Check"

Endorphin
10-21-2008, 10:55 PM
I take it you mean import?
Or am I not awake yet.

tinkerbell
10-21-2008, 11:45 PM
import i mean.

Endorphin
10-22-2008, 12:04 AM
Would you be able to post exactly what you expect to see when finished and is the text file exactly the same setup each time?

tinkerbell
10-22-2008, 06:08 AM
here's the layout sample in excel. thanks.

Tirukami
11-21-2008, 06:38 PM
Hi ,

I am new for this forum. I also having same kind of requirement. Can you pls help me?