Exact value of file separator

[Former Member]

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

[Florian]

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

[former_member207574]

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