topic Re: Could not able to split the string at #! in Application Development and Automation Discussions

Could not able to split the string at #!

Former Member — Tue, 16 Feb 2010 13:44:44 GMT

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

Re: Could not able to split the string at #!

Former Member — Tue, 16 Feb 2010 13:53:42 GMT

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.

Re: Could not able to split the string at #!

Former Member — Tue, 16 Feb 2010 14:01:14 GMT

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

Re: Could not able to split the string at #!

Former Member — Tue, 16 Feb 2010 14:05:49 GMT

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.

Re: Could not able to split the string at #!

Former Member — Tue, 16 Feb 2010 14:08:35 GMT

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

Re: Could not able to split the string at #!

Former Member — Tue, 16 Feb 2010 14:56:37 GMT

Dear Samuel,

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

Please check..

Regards,

Srinivas

Re: Could not able to split the string at #!

vinod_vemuru2 — Tue, 16 Feb 2010 15:06:46 GMT

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.

Re: Could not able to split the string at #!

Former Member — Tue, 16 Feb 2010 15:13:47 GMT

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

Regards,

Srinivas

Re: Could not able to split the string at #!

vinod_vemuru2 — Tue, 16 Feb 2010 16:22:40 GMT

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.

Re: Could not able to split the string at #!

jrg_wulf — Tue, 16 Feb 2010 17:06:07 GMT

Hi Srinivas,

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

regards

Jörg

Re: Could not able to split the string at #!

former_member1257807 — Fri, 06 May 2022 06:56:21 GMT

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