Support with split String

I want to split this string

“Actions Chan*Tax Number Category Description Tax Number Edit Detail BE0 Belgium: VAT Registration Number BE0872570824 Edit Detail BE2 Belgium: VAT Reg. No. w/o country code 872570824 Edit Detail DE0 Germany: VAT Registration Number DE124548745”

to just have
1- VAT Registration Number BE0872570824
2- VAT Registration Number DE124548745
Thanks a lot

1 Like

Welcome to the community!
Use Matches with this expression:
VAT Registration Number [A-Z]{2}\d+

2 Likes

Hi Again [bcorrea].

i hope you can support in this Task i want to use REgex to extract just one string from standard text
example form below i want to find just the First digital numbers after BE2 in this case will be (402934832)

Thanks a lot

Description Tax Number Establishment Status Establishment Status Text Edit Detail BE0 Belgium: VAT Registration Number BE0402934832 Edit Detail BE2 Belgium: VAT Reg. No. w/o country code 402934832 Edit Detail IN2 India: Permanent Account Number (PAN)12454 Industries Business Partner Block & Deletion",
“level”: “Information”,

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.