It's always best to not touch a data file when trying to import it. Create has many feature to help with that and most situations should be covered by these parameters.
Here's a tar file with several examples and data.
ignoreExtraCols=on/off - Always run without this first and check out any errors or warnings about your input data however if you determine there are just extra empty columns
ignoreMissingCols=on/off - or missing columns that you don't mind padding with 0's then turn on this parameter.
delimiter - works for both coordinate and odometer format now
searchElemName1 and replaceElemName1 - use this to search and replace pair to match up with the changes to element names you may have made when extracting the informant for this data. Must be used together
replaceWhiteSpaceInElemName - replace any tab, space or other “white space” in the element names and should also be used to match up with the element name changes you may have made when extracting the informant set
firstLine - this is the line the data starts on and is counted from the top of the file even if there are lines commented out with '!'
firstCol - this is the first column to consider and is a 1 based value so the first column is 1
When you have a non-numeric column and have an informant for these values you can take in the data as the indexed numeric value. Then later when writing it out you can index it back to this informant and write out the text.