Could not able to split the string at #!

[Former Member]

Hi,

Hi Below is the value coming in a field character string 130 and I have used SPLIT at '#' and also Split at tab which has a value horzontal tab.

Below is the string Value..

'Feedback on Mr Richard Harris#360 category Partner#Department Human Resources#Office London#Review period 01.01.2010 to 31.12.2010'.

Please let me know how to resolve this?

Regards,

Srinivas

[Former Member]

Hi,

Try this

data: lv_var type CHAR1 value CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.
split lv_string at lv_var into wa-field1 wa-field2.

[Former Member]

Thanks for the quick reply.

I tried this already and is not working.

Also I tried to split the contents into Internal table as below which is also not working.

data: lv_var type CHAR1 value CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

split lv_string at lv_var into table <STRING_TABLE>

Regards,

Srinivas

[Former Member]

Hi Srinivas,

'#' means any unwritable character so it could have a lot of values!

If possible, could you have a look to the corresponding value of this symbol represented by '#' in hexadecimal value (you can get hexadecimal value in debugger) : this represent the ASCII value...

Best regards,

Samuel

[Former Member]

Dear Samuel,

The hexa decimal value for '#' is coming as '0A00'.

Please check..

Regards,

Srinivas

[vinod_vemuru2]

Hi,

It would be better if you can let us know how you are getting the data into string. Is it uploaded from some file? Here Hash(#) means any unprintable character. So hexadecimal value of hash may not help. You need to see how the data is populated to string field.

Based on that use the SPLIT statement. Hope this helps...

Thanks,

Vinod.

[Former Member]

The value is coming from Portal application and it will be used in Interactive form of adobe.

Regards,

Srinivas

[vinod_vemuru2]

Hi,

Then check with portal team to see what value they are passing to you at the place of hash(#). Seems like some code page conversion is failing.

Thanks,

Vinod.

[former_member1257807]

Very Nice. This is really appreciable as working absolutely fine without changing much in the program

[Former Member]

This works as it should:

DATA:
lv_field(130) TYPE c VALUE
'Feedback on Mr Richard Harris#360 category Partner#Department Human
resources#office london#review period 01.01.2010 to 31.12.2010',

lv_01(50) type c,
lv_02(50) type c,
lv_03(50) type c,
lv_04(50) type c,
lv_string TYPE string.

lv_string = lv_field.
split lv_string at '#' into
lv_01 lv_02 lv_03 lv_04.

write: / lv_01 ,
       / lv_02 ,
       / lv_03 ,
       / lv_04.

[jrg_wulf]

Hi Srinivas,

0A00 is the Value for LineFeed so retry split with CL_ABAP_CHAR_UTILITIES=>NEWLINE instead of tab.

regards

Jörg