Extract and split values from a long string variable

Help Studio
,
#1

Hello,

I have below string and i need to extract only the accounts’ details at the end of it.
My aim is to collect all users’ details and add them to a data table to be reused later on.

Additional actions logged:
Email sent to: ABC.Net@XXX.com

Please create new accounts on “XXX.com” domain and send credentials directly to the contact provided below.

Submitted form data

Contact: jozef.Name@XXX.com
OU: guide
Mandatory details: First_name,Last_name,External_e-mail,Suggested_UID,Company
External users’ details:

Name1,Surname1,Name1.Surname1@YYY.com,ext_dkra,Guidev
Name2,Surname2,Name2.Surname2@KKK.com,ext_chank,Guidev

#2

You can use regex to extract these items and group them.

#3

Can you help on how exactly do that?

#4

Try this. I’m using a text file to read the data, but you can replace this with whatever you’re using to get your raw data.

Processusvierge.zip (15,0 Ko)

#5

Thanks for your assistance with this.
It works most of the times, however, sometime the input may be slightly different ( without newlines, spaces, etc.) so i’m trying to tune it so that it will be working all the times.

I’ll let you know if I’ll need more help :slight_smile:

#6

I’ve some issues as input from users does not always follow the same format.
it could also look as below:

External users’ details: Name1,Surname1,Name1.Surname1@YYY.co
Name2,Surname2,Name2.Surname2@KKK.com

Once extract all the lines, I should also place them in an excel file.

Can you assist me further?