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
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
Please check the below workflow. Hope the output meets your requirement.
Sequence14.xaml (20.4 KB)
Output:
Hope it helps!!
Regards
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!!
new!.xaml (15.1 KB)
@manikandan.murugan ,Hi I have attached the workflow that replicate your requirement,hope u find it useful!
Regards,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
