Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create delimited file
Hi Excellers
I have a text file which comes from a windows application (Not Office). The file has headings across the top and headings down the left hand side, although not exactly square - meaning some rows have 3 headings across and other rows have 5 headings across. The headings and data are separated by spaces and there is a CRLF at the end of each line to create each row. I have used FileSystemObject to read the file but I am struggling to come up with a way of inserting commas say, to delimit the file. I may need to make another post to convey the total picture, but basically I want to create a comma (or Tab) delimited file to parse the columns into Excel. Text to columns doesn't work because with fixed width, some of the row headings are longer than other headings. Delimited doesn't work because the file is delimited by spaces and the row and column headings would end up with commas between them (not wanted). Hopefully I have given a reasonable picture of this situation. Basically I would like to get some code to make a utility for the purpose of delimiting these files. I am happy to supply any additional info if needed. Much appreciated, Thanks David_G. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a ASCII semi-colon or comma delimited file | Excel Worksheet Functions | |||
Create a comma-delimited file to be opened in Excel | Excel Programming | |||
Create a form to open a comma delimited file | Excel Discussion (Misc queries) | |||
Import Pipe Delimited File, Parse out certian Fields, create new f | New Users to Excel | |||
how do I create comma and double quote delimited file | Excel Discussion (Misc queries) |