topic Re: Replace spaces in a string with Tab character in Application Development and Automation Discussions

Replace spaces in a string with Tab character

Flavio — Mon, 08 Mar 2021 07:53:33 GMT

Dear all,

I'm looking for a way to replace all the spaces in a string, when they consequently occur more than one time, with a single 'Tab' character;

here a sample of the string

RAW MATERIAL TOOLS               82,000         59.083,200         52.062,420        148.121,834              0,000              0,000

and the desired result:

RAW MATERIAL TOOLS'Tab'82,000'Tab'59.083,200'Tab'52.062,420'Tab'148.121,834'Tab'0,000'Tab'0,000

is it possible to get the desired result with Regex?

any help is highly appreciated

thank you and best regards,

Flavio

Re: Replace spaces in a string with Tab character

Former Member — Mon, 08 Mar 2021 08:04:57 GMT

Hi, try this:

lv_string = replace( val = lv_string regex = '\s{2,}' with = cl_abap_char_utilities=>horizontal_tab occ = 0 ).

Re: Replace spaces in a string with Tab character

MateuszAdamus — Mon, 08 Mar 2021 08:06:47 GMT

Hello flavio.ciotola4

REPLACE ALL OCCURRENCES OF REGEX '[ ]{2,}' IN lv_string WITH cl_abap_char_utilities=>horizontal_tab.

Kind regards,
Mateusz

Re: Replace spaces in a string with Tab character

Flavio — Mon, 08 Mar 2021 08:47:33 GMT

Thank you mateuszadamus, it works!

Re: Replace spaces in a string with Tab character

Sandra_Rossi — Mon, 08 Mar 2021 09:41:21 GMT

OCCURANCES -> OCCURRENCES 😉

Auto-test code:

data(lv_string) = |RAW MATERIAL TOOLS               82,000         59.083,200         52.062,420        148.121,834              0,000              0,000  |.
REPLACE ALL OCCURRENCES OF REGEX '[ ]{2,}' IN lv_string WITH cl_abap_char_utilities=>horizontal_tab.
assert lv_string = |RAW MATERIAL TOOLS\t82,000\t59.083,200\t52.062,420\t148.121,834\t0,000\t0,000\t|.

Re: Replace spaces in a string with Tab character

MateuszAdamus — Mon, 08 Mar 2021 10:00:57 GMT

Fixed the typo.

Kind regards,
Mateusz