Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extract data in rows (with line breaks) to form a table
Hello there! I have a text file contains many members data with line breaks separate one from another. How can I extract the data from lines of txt file to form a data table to an excel file? I know I can use Import txt file wizard in excel. But what i faced is that, not all members details share the same width and digits as they are in free text file.
Would vba helps to extract the details and put them to a table with column heads like: Account#, Name, Contact Person, Tel#, Fax#(if any), Enrollment Date, Expiry Date, Shopping History, Product, Amount? Thank you for solving my question!!!! Example: ================================================== = Member Profile ABC Company Created Date 10-Jul-13 Account # A1234 Name Amy Inc Contact Person Amy xxxxx Tel# 12345678901 Fex# 123456987 Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18 Shopping History Product Amount AAA Company AAA product 700 BBB Company BBB product 8000 CCC Company CCC product 900 ------------------------------------------------------------------------------ Member Profile ABC Company Created Date 10-Jul-13 Account # B1234 Name Becky Inc Contact Person Becky xxxxx Tel# 12345678902 Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18 Shopping History Product Amount AAA Company AAA product 700 BBB Company BBB product 8000 ------------------------------------------------------------------------------ Member Profile ABC Company Created Date 10-Jul-13 Account # C1234 Name Charlie Inc Contact Person Charlie xxxxx Tel# 12345678903 Fax# 12358546651 Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18 Shopping History Product Amount DDD Company DDD product 700 EEE Company EEE product 8000 ------------------------------------------------------------------------------ Member Profile ABC Company Created Date 10-Jul-13 Account # D1234 Name David Inc Contact Person David xxxxx Tel# 12345678904 Enrollment Date 10-Jul-13 Expiry Date 10-Jul-18 Shopping History AAA Company AAA product 700 FFF Company FFF product 400 GGG Company GGG product 3200 ------------------------------------------------------------------------------ etc... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to split data where line breaks are the delimiter | Excel Worksheet Functions | |||
cant export to excel unless I reduce data in cells and line breaks | Excel Discussion (Misc queries) | |||
Importing Word Data from Form Field with Line Breaks | Excel Programming | |||
Extract data from form | Excel Discussion (Misc queries) | |||
Import External Data w/ CSV & Line-Breaks ... | Excel Programming |