PDA

View Full Version : Extract Data from .txt file



pmari
11-09-2011, 09:09 AM
Hi Friends,

I need to extract specific numbers from a large text file and copy in excel sheet.
Total rows will come around 6K.

I Need to copy the Number after Text String "Item:" in col A & Number after Text String "Nettable Inventory:" in col B.

Result xl sheet will be like below,

Item Nettable Inventory
C110160003 1200
C117CBB203 0
C117CBS675 0


searched in this Forum for code from previous queries and find some but can't make out for my requirement. Your help will be highly appreciated.

sample .txt file attached.

With Best Regards

mancubus
11-09-2011, 10:39 AM
fyi, file not attached!

mancubus
11-09-2011, 10:42 AM
never mind.
you opened another thread...