CSV email file needs user setting notation

rangerlet_mesee — Thu, 08 Jul 2021 12:59:51 GMT

In CSV file email, for price related values like 4321.60.....it is required as 4,321.60

But system is considering comma as a field separator and splitting the value as 4 and 321.60

I want the CSV file to honor the thousand separator

XSTRING function module is used

Re: CSV email file needs user setting notation

Nikhil_Rao_ABAP — Thu, 08 Jul 2021 13:30:29 GMT

Hello,

Can you try this:

Open a blank something.txt file. Enter a line like this -

"1,2345","2,3456"

Save the file as something.csv

Now open the file in Excel. you will see that content within the cells will have the commas respected. And the values within the " but separated with commas outside the " will be placed in different cells. So, in the ABAP code that is generating the csv content, try encapsulating the values in "..."

Hope this helps!

Regards,

Nikhil Rao

topic Re: CSV email file needs user setting notation in Application Development and Automation Discussions

CSV email file needs user setting notation

Re: CSV email file needs user setting notation