| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
covert data from text file into columns
The data is in a text file (amounting to 1.5 M rows) - Sample attached here
Location = "San Bernandino CA" Store ID = 1 Stock ID = 1 Address = 1001 Parkway Ave Xroad ID = 1001 ID = 1001 Location = "San Francisco CA" Store ID = 2 Stock ID = 2 Address = 2001 Morrison Ave Xroad ID = 2001 ID = 2001 Output should look like: Location Store ID Stock ID Address Xroad ID ID San Bernandino San Francisco If there is NO Location = " " it is end of row data in the file since the raw text file is large 1.3M data is running bat file to create csv an option Thank you J C |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Covert Text String Data | Excel Worksheet Functions | |||
| batch process to covert file to excel file | Excel Programming | |||
| Covert Columns to rows Macro | Excel Programming | |||
| How do i covert a number to its text value i.e 1 to one | Excel Programming | |||
| covert columns into rows | Excel Discussion (Misc queries) | |||
Threaded Mode
