topic Re: Processing character string in Application Development and Automation Discussions

Processing character string

Former Member — Wed, 07 Feb 2007 14:38:54 GMT

Hi All,

I uploaded a CSV file into an itab via GUI_UPLOAD.

Example:

CSV file filled in cell A1 (as viewed in Excel)
--------------------------------------------------------
|     |       A      |        B         |        C     |
--------------------------------------------------------
| 1   | AAA          |                  |              |
|     | BBB          |                  |              |
|     | CCC          |                  |              |
--------------------------------------------------------
| 2   |              |                  |              |
--------------------------------------------------------

Uploaded itab with one line (after GUI_UPLOAD):

AAA#BBB#CCC

I tried SPLITting the above AT '#' but it is not successful, since '#' in itab is a hexadecimal character. Below are the codes:

LOOP AT itab.
  SPLIT itab-text AT '#'
  INTO i_rec-f1 i_rec-f2 i_rec-f3.
ENDLOOP.

PS: Other than SPLIT, i used SEARCH, FIND, TRANSLATE but to no avail. Can someone help? I need the output in another itab with the result similarly to cell A1.

Thanks

Re: Processing character string

Former Member — Wed, 07 Feb 2007 14:59:36 GMT

Hello

I had a same problem too..............i came over it but declaring a char field c1(say)of length 1 and moving # to c1 and then used the following code

data : c1.

move '#' to c1.

LOOP AT itab.

SPLIT itab-text AT c1

INTO i_rec-f1 i_rec-f2 i_rec-f3.

ENDLOOP.

let me know if it works.

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:03:16 GMT

do this way...use GUI_UPLOAD....this has a field in import parameter....

HAS_FIELD_SEPARATOR...u can mentioned the field sepaartor in this and when upload it will autmatically spli at the field separator into fields...

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:04:28 GMT

Hi FSCHU,

When you upload, using the function module, there is a parameter for HAS_FIELD_SEPARATOR .

Pass 'X' to that parameter.

Also, you should define the internal table as the same structure as is displayed in the excel.

OR.

The # you see is nothing but a horozontal tab.

YOu have to split the string using the attribute

CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

loop at itab.

split itab-data at CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

into itab_new-field1 itab_new-field2...

append itab_new.

clear itab_new.

endloop.

Regards,

ravi

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:05:54 GMT

Thanks Vj,

I tested your case but it doesnt work. The itab-text still does not split itself.

Please help

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:07:11 GMT

try this...


data : v_char type X value '0A'.

LOOP AT itab.
  SPLIT itab-text AT v_char  INTO i_rec-f1 i_rec-f2 i_rec-f3.
ENDLOOP.

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:07:45 GMT

Hi,

LOOP AT itab.

REPLACE '#' with SPACE into itab-text.

ENDLOOP.

data: var(1) type c.

var = '#'.

LOOP AT itab.

SPLIT itab-text AT var

INTO i_rec-f1 i_rec-f2 i_rec-f3.

ENDLOOP.

Regards

Sudheer

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:12:18 GMT

HI FSCHU,

look via the debugger (set a break-point before split) at

find out the HEX of #.

than declare a variable

and a slip with this variable.

Regards, Dieter

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:21:52 GMT

Hi Dieter,

I tried but still not successful. Do I need to SPLIT ... IN BYTE MODE?

Thanks

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:24:23 GMT

Hi Ravi,

I tried also to split at CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

No success. Here are my codes:

*&---------------------------------------------------------------------*
*& Report  ZTEST_SME928                                                *
*&                                                                     *
*&---------------------------------------------------------------------*
*&                                                                     *
*&                                                                     *
*&---------------------------------------------------------------------*

REPORT  ZTEST_SME928.
PARAMETER: P_FILE LIKE RLGRAP-FILENAME DEFAULT 'C:Documents and Settingsetong.AXONDesktopdamn.csv'.
DATA: V_FILENAME TYPE STRING.
DATA: BEGIN OF I_INPUT1 OCCURS 0,
        TEXT(1000),
      END OF I_INPUT1.


V_FILENAME = P_FILE.
CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
    FILENAME                = V_FILENAME
    FILETYPE                = 'ASC'
  TABLES
    DATA_TAB                = I_INPUT1
  EXCEPTIONS
    FILE_OPEN_ERROR         = 1
    FILE_READ_ERROR         = 2
    NO_BATCH                = 3
    GUI_REFUSE_FILETRANSFER = 4
    INVALID_TYPE            = 5
    NO_AUTHORITY            = 6
    UNKNOWN_ERROR           = 7
    BAD_DATA_FORMAT         = 8
    HEADER_NOT_ALLOWED      = 9
    SEPARATOR_NOT_ALLOWED   = 10
    HEADER_TOO_LONG         = 11
    UNKNOWN_DP_ERROR        = 12
    ACCESS_DENIED           = 13
    DP_OUT_OF_MEMORY        = 14
    DISK_FULL               = 15
    DP_TIMEOUT              = 16
    OTHERS                  = 17.

DATA: BEGIN OF I_REC OCCURS 0,
         F1(40),
         F2(40),
         F3(40),
      END OF I_REC.

LOOP AT I_INPUT1.
  SPLIT I_INPUT1-TEXT AT '0A' 
  INTO I_REC-F1
       I_REC-F2
       I_REC-F3.
  BREAK FFXC096.
ENDLOOP.

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:25:33 GMT

use HAS_FIELD_SEPARATOR in export parameter .

in that specify ' , ' (comma) as field seperator.

Message was edited by:

Kalpanashri Rajendran

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:28:31 GMT

Hi Kalpa,

My problem now is splitting a column with multiple lines, in which the lines are all in different lines.

Please refer to my initial post for more info.

Thanks lots

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:33:06 GMT

Hi Chandra,

not working either. Thanks

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:38:08 GMT

hey

Did u try slitting in CHAR MODE?

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:43:11 GMT

Hi Vj,

Thanks, but isn't it by default IN CHARACTER MODE?

Anyway, I tried but not successful either.

Pls give me more inputs

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:44:49 GMT

hello

Yeah you are right...................checking in case.

Let me see into it and will get back into it.

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:48:31 GMT

hey , you had tried in wrong way , if u use direclt SPLIT at '0A' , it will search for 0A and then split

declare one varible of type X and try

data : v_char type X value '0A'.

LOOP AT I_INPUT1.
  SPLIT I_INPUT1-TEXT AT v_char  INTO I_REC-F1
       I_REC-F2
       I_REC-F3.
  BREAK FFXC096.
ENDLOOP.

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:48:55 GMT

No worries Vj.

Thanks...

Anyone else with more info? Pls share

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:51:21 GMT

Hi Chandra,

i tried but it gives me a syntax error. It says 'v_char must be a character-type data object (data type C, N, D, T or STRING)

thanks...

Re: Processing character string

Former Member — Wed, 07 Feb 2007 15:54:24 GMT

IF U CAN mark the end of the string with a #

like 'AAA#BBB#CCC#'.

then a logic is there to work out .

Execute the code and see .

data :VAL(15) TYPE C VALUE 'AAA#BBB#CCC#'.
DATA :CNT TYPE I.
DATA:  v type c,
       n type i.
DATA : FINAL(15) TYPE C.
DATA : BEGIN OF ITAB OCCURS 0,
       F1(10) TYPE C,
       END OF ITAB.

    CNT = STRLEN( VAL ).

    DO CNT TIMES .
     move val+n(1) to v.
    if v ca '#'.
    CONDENSE FINAL NO-GAPS.
    ITAB-F1 = FINAL.
    APPEND ITAB.
    CLEAR ITAB.
    CLEAR FINAL.
    ELSE.
    move v to final+n(1).
    endif.
    n = n + 1.
    ENDDO.

    LOOP AT ITAB.
    WRITE:/ ITAB-F1.
    ENDLOOP.

hope if this can make some help .

still this needs little adjustments .:)

regards,

vijay.