I think I'll edit this again

I've gone ahead and used the ODBC with a comma delimited text file. The CSV was created in Excel and saved as a .CSV.

Using the database emulation removes the leading zero from the zip code though. Have we seen this and / or have a solution for it? When saving the .CSV file from Excel I specified that column to be a zip code, and determined on my desktop that it indeed stays. Only when using this database emulation does it remove the zero. Changing the emulation back to a CSV returns the zero.

That is why I always use an ASCII emulation and the CSV Indexer function as the emulation then treats the CSV file as a text file reading all lines and characters regardless.

When using the DB emulation, you can put back those zeroes with PlanetPress Talk like this:



this expression keeps the 5 rightmost characters of a string that is '00000' concatenated to the value of the zipcode db field.

hope this helps