Regex patern for long sting

[Serran_Neru]

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

[jitendra_123 (Jitendra Ughade)]

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

[Serran_Neru]

@Serran_Neru

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>)

Hi Jitendra,

It doesn’t work. Any other idea?

[jitendra_123 (Jitendra Ughade)]

regex101: build, test, and debug regex

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

[Serran_Neru]

Ohh wow, thanks alot @jitendra_123. Appreciate it