Zeros truncated in CSV output

[Dasgupta]

The following worked for me:

variable equals ="string"
RV variable = concat('="',concat(ltrim(rtrim([String],' '),' '),'"'))

But I tried the following and it did not work:

variable = 'String
RV variable = concat("'",ltrim(rtrim([String],' '),' '))

Thanks for the help.

Gautam
JDE 9.2, Tools 9.2.2.2

 

[Tripathi]

Thanks Larry it opened for me today.
I was trying to open the .CSV in excel.
My problem got solved.
variable equals ="string"
RV variable = concat('="',concat(ltrim(rtrim([String],' '),' '),'"'))
Thanks a lot for all valuable suggestions.
Jiju suggested me this before but didn't exactly understand what he meant.

This is the second time i got my issue solved through JDELIST

Thanks,
Susmitha

Hi Susmitha,

In this case, csv output is showing ="000123" (for ex). I am looking for solution to print only 000123 without any extra char in csv output produced by JDE.

Please suggest!!!

Thanks.

 

[Larry_Jones]

Hi Susmitha,

In this case, csv output is showing ="000123" (for ex). I am looking for solution to print only 000123 without any extra char in csv output produced by JDE.

Please suggest!!!

Thanks.

Why don't you explain more of your Use Case. If you're not using Excel to open the CSV file why are you using a CSV file format?