String Manipulation PDF Automation Regex

[manikandan.murugan]

Hi Team,

Manikandan,Murugan M
Mani kandan, Murugan
Manikandan, Murugan
Maikandan M. Murugan
Manikandan Murugan

consider the above as a name patterns from this I need to split like first name last name and Middle Name. Kindly help me out.

First Name	Last Name	Middle Initial
Manikandan	Murugan	M

Thanks in Advance

[Steven_McKeering]

Hi @manikandan.murugan

Names and addresses are difficult to cater for all scenarios.

I have made a workflow which will serve the needs for the above names but will likely fail if a different name format is introduced.

Murugan.zip (19.8 KB)

INPUT

OUTPUT (csv format)

Hopefully this helps

Cheers

Steve

[Parvathy (PS Parvathy)]

Hi @manikandan.murugan

Please check the below workflow. Hope the output meets your requirement.

Sequence14.xaml (20.4 KB)

Output:

Hope it helps!!
Regards

[pravallikapaluri]

Hi @manikandan.murugan

FirstName=System.Text.RegularExpressions.Regex.Match(currentItem.ToString,"((?<=^)|(?<=\n\s*))([A-Z]+[a-z]+\s[a-z]+|[A-Z]+[a-z]+)").Value
MiddleName=System.Text.RegularExpressions.Regex.Match(currentItem.ToString,"[A-Z]{1}\.|(?<=\,[A-Za-z]+\s)[A-Z]{1}").Value
LastName=System.Text.RegularExpressions.Regex.Match(currentItem.ToString,"((?<=\,\s*)|(?<=\.\s*)|(?<=[A-Z]+[a-z]+\s))[A-Z]{1}[a-z]+").Value

Forum.zip (207.5 KB)

Hope it helps!!

[tazunnisa.badavide (Taj)]

new!.xaml (15.1 KB)
@manikandan.murugan ,Hi I have attached the workflow that replicate your requirement,hope u find it useful!

Regards,