topic Re: problem in converting flat file in Application Development and Automation Discussions

problem in converting flat file

Former Member — Tue, 17 Apr 2007 05:00:54 GMT

Hi Experts,

sample flat file

"3508" "60003806" "100406425" "USD" "03/01/2007"

"3509" "60003807" "100406425" "USD" "03/01/2007"

the above flat file has double quote and tabdelimiter.

i use the FM gui_upload to upload this file to a string and remove ' " ' using FM 'WRB_UTIL_STRING_REPLACE'. But the file now contains '#' for tab delimiter.

example:

string = 3508#60003806#100406425#USD#03/01/2007.

without download it again is there any possible way to transfer these values to the corresponding fields of the i_tab (contains 5 fields).

Please reply as soon as possible

Thanks,

Ashok

Re: problem in converting flat file

Former Member — Tue, 17 Apr 2007 05:02:11 GMT

Hi..,

The character '#' can be a Horizontal tab or a new line or a Vertical tab...

Those '#' are special characters to indicates new line or tab. You need to use the abap objects CL_ABAP_CHAR_UTILITIES to fix this issue.

constants :

C_HTAB value CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

replace all occurrences of C_HTAB in w_string with space.

OR TO GET THE FIELDS INTO INTERNAL TABLE..

define a constant..

constants :

C_HTAB value CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB. **<--Horizontal tab

loop at i_input.

split i_input at C_HTAB into i_finaltab-field1 i_input.

split i_input at C_HTAB into i_finaltab-field2 i_input.

split i_input at C_HTAB into i_finaltab-field3 i_input.

split i_input at C_HTAB into i_finaltab-field4 i_input.

append i_tab.

endloop.

regards,

sai ramesh

Re: problem in converting flat file

Former Member — Tue, 17 Apr 2007 05:04:40 GMT

hi Ashok,

Refer

Regards,

Santosh

Re: problem in converting flat file

Former Member — Tue, 17 Apr 2007 05:04:46 GMT

try this

split STRING at '#' into table itab-field1 itab-field2 itab-field3 itab-field4 itab-field5.
append itab.

Re: problem in converting flat file

Former Member — Tue, 17 Apr 2007 05:07:22 GMT

give File Type = DAT.

Regards

Prabhu