pull required data from report

**prabhuduraraj09** · 07-11-2012, 03:45 PM

Hi friends,
I have a report , in which it is irregular to see. But i need to format that report..or to pul only few datas that i reqd.

i have attached sample file. with two sheets,
one sheet has Report other sheet has expected output.

output wud be reqd in next sheet of the report.
possible help is much appreciatable.....thanks

**fredlo2010** · 07-11-2012, 03:49 PM

Where are you getting the report data from? It looks like some kind of text file?

**prabhuduraraj09** · 07-11-2012, 03:55 PM

yes you are right. im geting through txt file.

**fredlo2010** · 07-11-2012, 04:14 PM

can you post the txt file without any modification?

**prabhuduraraj09** · 07-12-2012, 12:32 AM

Originally Posted by fredlo2010

can you post the txt file without any modification?

Hi, i have attached the report in Txt file format.

**fredlo2010** · 07-12-2012, 07:23 AM

This looks extremely complicated. Is it a text file what you get always? Sometimes programs give us options to expert as a .csv .txt and things like that. This files will give us exra information that will help us untangle this.

Thanks

**prabhuduraraj09** · 07-12-2012, 11:49 PM

Originally Posted by fredlo2010

This looks extremely complicated. Is it a text file what you get always? Sometimes programs give us options to expert as a .csv .txt and things like that. This files will give us exra information that will help us untangle this.

Thanks

Guys, anyone could help me?.
i cud copy paste from txt file. not a problem. After pasting it... some code or any vb code... shud help me to do text to column.

pls help me...