topic Re: gui_upload CSV problem in Application Development and Automation Discussions

gui_upload CSV problem

Former Member — Sun, 28 Jun 2009 12:17:59 GMT

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.

Re: gui_upload CSV problem

Former Member — Sun, 28 Jun 2009 13:05:25 GMT

take another field

when you are getting from internal table concatenate them

Re: gui_upload CSV problem

Former Member — Sun, 28 Jun 2009 14:50:50 GMT

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

Re: gui_upload CSV problem

former_member723628 — Sun, 28 Jun 2009 15:31:35 GMT

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

Re: gui_upload CSV problem

Former Member — Sun, 28 Jun 2009 19:43:25 GMT

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.

Re: gui_upload CSV problem

Former Member — Sat, 15 Aug 2009 14:47:07 GMT