Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

uploading csv file

Former Member

‎2006 Jul 27 2:53 PM

0 Likes
370

Hi

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?

2 REPLIES 2
Read only

Former Member

‎2006 Jul 27 2:58 PM

0 Likes
330

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

then u can concatenate the three columns

Read only

RichHeilman
Developer Advocate
Developer Advocate

‎2006 Jul 27 2:59 PM

0 Likes
330

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