topic Re: uploading csv file in Application Development and Automation Discussions

uploading csv file

Former Member — Thu, 27 Jul 2006 13:53:14 GMT

i have a csv file format and i want the value for a field1 is from excel sheet by concatenating the column c-d-e how to get the value?

Re: uploading csv file

Former Member — Thu, 27 Jul 2006 13:58:29 GMT

first upload the csv file into internal table by using GUI_UPLOAD,

then u can concatenate the three columns

Re: uploading csv file

RichHeilman — Thu, 27 Jul 2006 13:59:35 GMT

After you split the string, into its fields, just concatenate the fields into another field.

split iflat at ',' into itab-fld1 itab-fld2 itab-fld3.

concatanate itab-fld1 itab-fld2 itab-fld3 into itab-fld4
                separated by '-'.

append itab.

Regards,

Rich Heilman