Parsing Help

Marp

Hi All

Hope you are all doing fine!

Tried to parse below data before posting question here

I need to parse PLR data from below string - each PLR is separated by coma (;)

Data:

122132;PLR-111-2323-91;323233;UKCRN-18799;PLR-454-2656-1;34-159980;NCI-2015-00115;ad773432;rere20130320

Result :

PLR-111-2323-91 ; PLR-454-2656-1

PLR values could be one or More

Thanks Again for your help

Datasets

Parse

Accepted answers

vizAlter

Hi @Marp — Try this solution if you want to use a RegEx tool:

(PLR[-0-9]+)

or

(PLR-[0-9]+-[0-9]+-[0-9]+)

or use below if a ";" sign always comes in the end:

(PLR-[0-9]+-[0-9]+-[0-9]+\;)

And, you may use a Summarize tool if you want to put the results like below:

Please mark this post solved if it helps.

Parsing Help__vA.yxmd

KarolinaRoza

Hi,

in your formula you are missing '+' at the end.

It should be:

PLR-[0-9]+-[0-9]+-[0-9]+

If you have only [0-9] it returns you just one number, instead of several numbers, you can apply either '+' or '*' instead.

Karolina

All comments

Marp

Hi All

I could able to parse with the code below

.*?PLR(.*?)\;

not working with the string more than one occurrence

Please Advise

KarolinaRoza

Hi @Marp

You can try different way then regex.

Text to rows -> Filter contains "PLR" -> Summarize with concatenate

For me it is easier way to do it 🙂

Regards,

Karolina

Parsing Help.yxmd

vizAlter

Hi @Marp — Try this solution if you want to use a RegEx tool:

(PLR[-0-9]+)

or

(PLR-[0-9]+-[0-9]+-[0-9]+)

or use below if a ";" sign always comes in the end:

(PLR-[0-9]+-[0-9]+-[0-9]+\;)

And, you may use a Summarize tool if you want to put the results like below:

Please mark this post solved if it helps.

Parsing Help__vA.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703