Regex until first occurrence of characters

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>);ST(HKG);ST(HKG);PU(HKG);SI(HKG);;WO(KUL<28.300kg><3.0x8.0x9.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.
Basically from the ;WO until first occurrence of ;

Sometimes there will be 2 WO in one string and this should output 2 pattern

Expected result:

  1. WO(KUL<13.400kg><26.0x36.5x28.0cm>) — 1st
  2. WO(KUL<28.300kg><3.0x8.0x9.0cm>) ---- 2nd

Really would appreciate your guidance on this.

2 posts were merged into an existing topic: Regex until first occurrence of a characters