Zeros truncated in CSV output

Dasgupta

Member
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

Member
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
smile.gif


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

Legendary Poster
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?
 
Top