can this be done in regex? Or do I have to formula it?

[Hamder83]

Hi 

I have a comment field, with a somehow similar structure. Only a few deviations.*

I wanna extract the a parcel numbers from each row. I have attached what data I have, and what I want to achieve.

Can this be done smart in maybe regex?

Thanks in advance,

[atcodedog05]

Hi @Hamder83 

You can achieve in both like below.

Hope this helps : )

[Hamder83]

I almost works? 

But it does not cover all 4-5 combinations?

[atcodedog05 · Accepted solution]

Hi @Hamder83 

Can you provide the combinations.

Here is an updated workflow that covers the majority of scenarios

Hope this helps : )

[binu_acs · Accepted solution]

@Hamder83  

[Hamder83]

Holy this is good **bleep**, you guys are geniousses :O :D 

Hope to one day reach your skill level!

[atcodedog05]

Happy to help : ) @Hamder83 

Cheers and have a nice day!