Help with regex pattern

[Zlotzky (Goran)]

Hi. I have a txt file and want to save the different contact-data into variables. But cant get the pattern right to extract lets say “John Bill” as Firstname

(I´m a total beginner, I´m only getting “<![CDATA[John Bill]]”)

12173

I guess there´s a better way (some sort of array?) then doing it field for field but I´m trying to learn.

[Srini84 (Srinivas Kadamati)]

@Zlotzky

To learn Regex, I suggest to visit below post

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

Hope this helps you

Thanks

[NIVED_NAMBIAR (NIVED N)]

Hi @Zlotzky

Can u share the text which nees to be extracted so.that we can help with regex pattern

Regards

Nived N

Happy Automation

[Zlotzky (Goran)]

Kontaktuppgifter.txt (583 Bytes)
Attached the txt file. I want to extract and store firstname = John Bill and lastname = Doe Hillside and so on.

[NIVED_NAMBIAR (NIVED N)]

U can try the regex pattern to get first name

(?<=<![CDATA[)[A-Z a-z \s]+

To get the last name u can use

(?<=<![CDATA[)[A-Z a-z \s]+

Hope it helps you

Regards

Nived N

Happy Automation

[Manish540 (Manish Shettigar)]

Check this below workflow, @Zlotzky
Uipath_ExtractionUsingRegex.xaml (4.5 KB)
Hope this may help you

[Zlotzky (Goran)]

Thanks a lot!