Posted by Grant Foraker on April 28, 2011 at 12:40:28:
In Reply to: Re: Old Reporter questions posted by Barbara Brazil on April 28, 2011 at 12:10:19:
bb:
LAUNCH EXCEL.EXE $(CATEMP)\JAHR0088.CSV" doesn't work for TXT or CSV.
LAUNCH $(CATEMP)\JAHR0088.CSV works for CSV files.
BUT, the customer has ID numbers with leading zeros. The only way to get around Excel's STUPID stripping of leading zeroes is to send a CSV file disguised as a TXT and have the user run the "Text to Columns" wizard where the user can designate the ID colums as "Text" instead of the default "General"
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.