00a01-2019 I wanna extract the string above into 3 fields (only using RegEx): Case 1: ctC13 00a01-2019 /ctC13 OR Case 2: C13 00a01-2019 C13 Have tried several ways but it didn't work out: case 1: \ (.*?)\ case 2: \ (.*?)\ Could anyone help me? Thanks!

[Urgent help] Regex parsing

hungdm

I wanna extract the string above into 3 fields (only using RegEx):

Case 1:

ctC13

00a01-2019

/ctC13

Case 2:

C13

00a01-2019

C13

Have tried several ways but it didn't work out:

case 1:

\<(.*?)\>(.*?)\<(.*?)\>

case 2:

\<ct(.*?)\>(.*?)\<\\ct(.*?)\>

Could anyone help me? Thanks!

Preparation

Accepted answers

vmartinez

Hi,

using the information given by @DiegoParker I added the second case

I hope is helpful

Best,

Vianney

Regex parsing.yxmd

All comments

patrick_mcauliffe

@hungdm Give this workflow a try.

ParseXMLsample.yxmd

hungdm

Thanks!

I have a large number of records having the same structure. hence this one is actually not very performance-efficient to my specific case.

DiegoParker

Hi @hungdm

You have to use <(.*?)>(.*?)<\/(.*?)>

The reason is because whilst usually we would escape a character using "\" in this case \< represent beginning of word.

Hope this helps If does, can I ask you to mark it as a solution? this will help other users to find it and will allow us to close the thread. Many thanks!

EDIT: If you want to keep the "/" at the end of the third field, then just do <(.*?)>(.*?)<(.*?)>

Best,
Diego

vmartinez

Hi,

using the information given by @DiegoParker I added the second case

I hope is helpful

Best,

Vianney

Regex parsing.yxmd

hungdm

It worked! thanks a lot!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235