DSXchange

Aha, well I see. I don't have any such problems since I'm handling financial figures and there are no leading zeros in them...
So the files I'm generating can be opened directly with Excel yes

Stef:

You are right: DS is not a reporting tool. Although, I'm generating html reports from within DS. I can have bold letters, change from Arial to Courier New, or whatever html code changes I want to do. The reports look good.

When I say "Que tengas buen dia", I wanted to say "Have a nice day". "Tengas" is the same as "to have". Now you know one spanish word more.

Bye.

Indeed so, a lot of formatting CAN be applied, but I try to avoid it as far as possible since it's pretty messy.

Ah, I did understand 'buen dia' but wasn't sure about the first half. I do know the meaning of 'Que' - mostly however due to the British comedy Fawlty Towers...
Muchas Gracias for the Spanish lesson!

Sainath.Srinivasan wrote:You can import by selecting all to be char field.

Yes, I know that, but when I email a csv to someone and they say "But you've stripped the zeros off the 'phone numbers"...

Include a apostrophe comma just before the field value.

Sainath.Srinivasan wrote:Include a apostrophe comma just before the field value.

I hadn't thought of that, but it would be inconvenient to change all our DS jobs that read CSV files to trim the leading apostrophe. The main reason I open CSV files in Excel is to test our jobs that use them as intermediate data files.