Stuck exporting data with specific requirements

Hi

I'm looking to choose an xls, have that exported to a csv file of the same filename prefix, using a pipe | as the delimiter, and make sure that all numeric fields are exported with two decimal places, even if those decimal places are 00.

Any help would be cool.



Preston

Of course doing that means that it is NOT a CSV file. It would be best to make it into a pipe delimited TXT file. For the number part, that would not be a number then. One has to force the number into the formatted string as a value, not just a number format.

I only responded so that I can look at this later and help when I get time should you get no solution.