Accessing a DataStage file with Excel

StefL · Post by **StefL** » Thu Jun 16, 2005 8:09 am

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

gpbarsky · Post by **gpbarsky** » Thu Jun 16, 2005 8:19 am

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.

StefL · Post by **StefL** » Thu Jun 16, 2005 8:24 am

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!

PhilHibbs · Post by **PhilHibbs** » Thu Jun 16, 2005 8:26 am

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"...

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jun 16, 2005 8:39 am

Include a apostrophe comma just before the field value.

PhilHibbs · Post by **PhilHibbs** » Thu Jun 16, 2005 9:22 am

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.