Skip to Content
avatar image
Former Member

Exact value of file separator

Hi expert

I am new in interface . I have uploaded an excel file using cg3z using ascii mode . I have read this file .

Each row is comming as continious string with coloumn separator showing as  '#' in debugger .

But when i am trying to split this string using '#' . Sample code bellow


split wa_tab-text at '#' into str1 str2 str3 str4.


But it does not split ,whole string goes to str1.

So anyone can you confirm me it is exactly '#' or it's value is different but showing in debugger as '#'....


It's urgent ..


Thanks & Regards

Rajesh


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 04, 2014 at 06:47 PM

    Hi,

    The # represents a non printable character. Maybe its an cr or cr-lf ? How are you reading the file? with open dataset?

    Regard

    Miguel

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04, 2014 at 08:52 PM

    Hi Rajesh,

    just get to the first of your # and set the offset to it.

    Now you have to go to the details (located next to it or double click the variable to get into the detail-view) and you can see the binary-value. This value gives you the correct seperator in combination with your encoding (normal should be ASCII).

    Here is an example, but searching the web brings a lot of this hex-tables as result.

    If it doesn't work, it would be helpful sharing an example of your excel, so we can have a look at it.

    ~Florian

    Add comment
    10|10000 characters needed characters exceeded