Hi, I am reading an Excel file and writing the contents to another excel file using tFileOutputExcel (using TOS 2.3 with a PERL project). I have rows that are formatted as text in the source as below: Col1 Col2 Col3 etc. 121 001 0535 When I write the file, I am losing the leading zeros. At this time of testing, I am just reading and directly writing (no components in the middle). The schema defines these columns as STRING on both ends. I tried various format options in the advance section of tFileOutputExcel but could not figure out the magic combination. Can someone please direct me to a solution? I am a newbie to TOS (having used mainly Informatica over several years). Thanks in advance. Sean.
I tried the "@" with the excel spreadsheet and as you point out, it does not work at this moment. Right now my workaround will be to create csv files with TXT extension. This way when user imports it, they can mark the columns as to what they want. I'll start a bug tracker (my first, wow)! I may have questions about this. Thanks.