problem in GUI_UPLOAD function module

[Former Member]

Hi Folks,

I am in the BI system where I have limited scope of upload function module, So I used GUI_UPLOAD as a upload function module.

I am uploading CSV file and which have amount field (with comma ',' ) as one of the column , So it is truncating the other columns while retrieving data into internal table and giving wrong data in columns.

Any other Function module, or tricks to upload file which have ',' in one of the column.

Thanks

PP

[Former Member]

Hi,

Well in this case you will have to change the file format i.e. Instead of CSV make it tab delimited etc.

Else change the amount value by replacing comma(which woud be a tedious task).

There is no other alternative.

Best regards,

Prashant

[Former Member]

Hi,

Before converting the file into CSV format, in excel chnage the cell format ( right click on the column & select Format Cell ) from Currency to Numbers then save the file as CSV format for uploading. This will remove the "," from the amount fields.

Hope this solves ur problem.

[awin_prabhu]

Hi,

After getting data into internal table validate it and remove ','.

Using data type as string.

Use TRANSLATE for removing ','.

Ex:

TRANSLATE g_r_wa2-matnr USING '; ' .

[Former Member]

Hi,

Declare two structures one structure field take char and upload data. Once uplaoded data you use Write .....Curency statemtnet and change char amount field into correct format and append to the sencond structure.

Regards

Md.MahaboobKhan

[Former Member]

Hi,

I used Text(tab delimited) file as a input and this problem is resolved.

Thanks a lot for your inputs.

PP