CSV output not showing .00 BUT PDF ok

[johndanter]

Hello there,

I am writing an output report in XE.
The output file is a CSV.

When the value is 123.12 it comes out ok
When the value is 123.00 it comes out as 123
also 0.00 shows as 0

The aliases I am using are AA but these are set to edit code J (commas zero balance)

the 0 shows just not the 0.00 even though my RVs are set to display decimals = 2

Any suggestions please?

thanks

John

 

[Zoltan_Gyimesi]

Hi John,

Do you see this in the CSV, which was opened with a text editor or do you see this in Excel?

As far as I know, this is an Excel issue - you should format the cells in Ecxel - I know, this is not a good news.

Regards,

Zoltán

 

[eydeak]

If the number is correct in the CSV, what is the issue that it is
causing by not having a fixed number of digits after the decimal point?
I ask, because it is often the case that when you load these CSVs into
something it only matters whether or not it's a number because the
program you are loading it into turns it into is own numeric type with
its own display formatting.



I believe the automatic CSV option for UBE's is primarily geared toward
loading the data into Excel, which will go ahead and apply its own
default numeric display settings. If I need a lot of control over the
formatting of a CSV file (or other types of flat files) I generally use
a table conversion or the flat file functions.



Ellen Deak

Senior Systems Developer

Cooper Standard Automotive

JDE EnterpriseOne (OneWorld XE Update 7 SP23_M1), AS400 DB2 V5R3M0,
Citrix Clients

 

[johndanter]

Thanks guys.

Yeah in notepad the values are there as 123.80 and 0.00 etc.

So it's excel issue. However my client wont like that as an answer

Should I move these values into text fields maybe?

 

[JDE User11]

You can get Excel to display the zeros if you force it to interpret the field as a text field. This will work if the field is just to read. If you need the field to remain a number then this technique won't help.

Basically you add some ER to your report so that field comes out it the CSV as ="<value>". Create some append functions that add =" to the front and " to the back of the variable. When appending " to the variable use ' to enclose the string value so that the tool does not get confused.

Steven

 

[Zoltan_Gyimesi]

Hi John,

[ QUOTE ]
Should I move these values into text fields maybe?

[/ QUOTE ]

I am afraid, you should.

Before you start to convert all of your numeric values, make a try, how does excel display the following string contants - simply place them somewhere on a section:

0.00 - 1.00 - 1.10 - "0.00" - "1.00" - "1.10"

If the first 3 sample or the other 3 sample will be displayed well AND the right adjustment in the cells is also right, then bingo. If something is not right, then you can not solve all of the case this way.

Please, let us know your results on it. Thanks.

Regards,

Zoltán

 

[LHoffman]

[ QUOTE ]
Thanks guys.

Yeah in notepad the values are there as 123.80 and 0.00 etc.

So it's excel issue. However my client wont like that as an answer

Should I move these values into text fields maybe?

[/ QUOTE ]

After import the CSV to Excel, format de cells to Numeric with 2 decimals. Or make you a own "mask" using the cell format menu.

 

[johndanter]

I'll try a few things later again today but for niow I've been told they'll live with it. lol

Thanks for your help guys