Extract specific data from txt file to dt

Help Studio
, ,
3

Hello

You can use Regex to solve this.
You can use the Matches Activity with the Regex Pattern:
(\d{3})\s(.*)
Regex101.com - Preview the solution here…
image
image

However, if you tell us more about the XXXX then I can improve the Regex Pattern to be more robust.

Is the XXXX always a certain length?
Is it just numbers? - Try this pattern if so “(\d{3})\s(\d+)”
Is it just letters?

If you want to learn Regex check out my Regex New User MEGAPOST. There is even a Regex Demo you can download and try for yourself.

Hopefully this can help

Cheers

Steve

2 Likes