Remove Middle Name

[Jagadeesh02]

Hello,

Can you help me how can I remove middle name in a collection?

EX: John Doe Peter
Amelia Mia Ann
Calvin Kyle Smith

 

[sunortap]

Hello,

you can use object: Utility - Strings
action: Extract Regex Values
Regex Pattern: "(?<firstname>\w+)\s?\w*\s?(?<lastname>\w+)"
Target String: [your data]
Named Values: as in atachment

then you can concatenate first name and last name.

Please let me know if you are able to handle with this.