gui_upload CSV problem

[Former Member]

Hi Guys,

I am facing problem in gui_download FM,kindly help ASAP pls.

itab which I am passing in FM is comma seperated and fields are thousand seperated so they contain comma as well

.As the FM is seperating the fields at comma , so for eg if field value is 123,45.90 ..it is seperating the field at 123 and 45.90 ...please help.

[Former Member]

take another field

when you are getting from internal table concatenate them

[Former Member]

You need to change one of them to avoid the confusion for Function Module.

[former_member723628]

Naveen,

For any comma separated variable length (.CSV) file you can not have commas in a numeric field. Every occurance of comma identifies beginning of new column. For csv file if comma is part of value then that value needs to be delimited by double quotes like below. This rule applies to all types of fileds.

Mr. A,"278, Wallnut Street",London,UK,"132,323.34"
Mr. B,"123, Chestnut Street",London,UK,"2,342,091.23"

The easiest way to handle this situation is convert the comma containing fields to character type and concatenate double quote sign ( " ) at the beginning and end of the value.

Hope this helps.

Gajendra

[Former Member]

Hi Naveen,

Its the excel settings when installed.

I faced similar issue but realised the below things:

1. CSV is charactr separated file and not just comma.

1. Indian or Asian or USInstallation of excel gives a CSV file as comma separated and the currencies are with decimals.

like : abc,122.55,555.00

2. European countries ue the comma as a decimal separator.

Here the CSV is semicolon seprated.

like : abc;122,55;555,00

This way in our case we applied the following logic.

If string CS ';' then delimeter = semilolon and comma are in currncy.

else

delimeter = comma and decimals in currenc.

The CSV files when generated by excel gives this.

If you try to create the test data yourself in notepad, its not the correct way.

Hope this helps.

[Former Member]

a