Regex patern for long sting

Hi All, Could you guys please guide me on using Regex pattern for below type of string.

ST(JKT);ST(HKG);PU(HKG);SI(HKG);RW(HKG);WO(KUL<13.400kg><26.0x36.5x28.0cm>);ST(HKG);PU(HKG);RW(KUL<4.200kg><3.0x3.0x3.0cm>)

I just wants to strip one those dimension (as bold above) right after the word “;WO” (always) followed by 3 code (which is KUL in this case) and those dimensions followed.

Expected result:

  1. KUL
  2. 13.400kg
  3. 26.0x36.5x28.0cm

Hi @Serran_Neru
Try to use This (?<=;)WO.+(?=;ST) Regex pattern.

2 Likes

Hi Jitendra,

It doesn’t work. Any other idea?


@Serran_Neru It’s working for me. RegexTest.xaml (5.1 KB)

1 Like

Ohh wow, thanks alot @jitendra_123. Appreciate it :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.