topic Re: Replace substring within Brackets with regex in Application Development and Automation Discussions

Replace substring within Brackets with regex

casualCoder — Tue, 31 Jan 2023 14:45:46 GMT

Hi,

the following String is given: '{12ZT-}716Ghdnsba'.

I want to cut the text within the Brackets, so the result would be '716Ghdnsba'.

Can anybody show me the approach with Regular Expressions? (regex?)

RaymondGiuseppi — Tue, 31 Jan 2023 15:16:07 GMT

REPLACE PCRE <regex pattern> IN <string> WITH ``.

For example try with a pattern such as \{.*\} (try demo report DEMO_REGEX)

Sandra_Rossi — Tue, 31 Jan 2023 15:40:14 GMT

PCRE or POSIX?

or just use substring_after( ... sub = '}' ), no?

thkolz — Tue, 31 Jan 2023 15:47:27 GMT

DATA: v_string TYPE string VALUE '{12ZT-}716Ghdnsba'.

REPLACE PCRE '\{.*\}' IN v_string WITH ''.

touzik_itc — Tue, 31 Jan 2023 21:13:17 GMT

Or something like this

match( val = '{12ZT-}716Ghdnsba' regex = '[^}]*$' )