CSV email file needs user setting notation

[rangerlet_mesee]

Hi

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

[Nikhil_Rao_ABAP]

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