Rank: Newbie
Joined: 4/5/2021
Posts: 4
|
I need to sanitize xml data by replacing comma and space with only comma.
Data are in format "Name Surname, Name Surname, Name Surname" and I need to separate by each person and for each person separate firstname and surname in different fields.
I tried to use tokenize-regexp with pattern of [,]+, but only forst person is correct, second got space before name, which should be removed.
Tried to add translate function but regex s not working there.
Any suggestions?
|
Rank: Advanced Member
Joined: 2/27/2009
Posts: 565
|
Any particular reason you want to do everything in regex? How about this example? File Attachment(s):
 example.mfd (5kb) downloaded 114 time(s).
K101 attached the following image(s):
|
Rank: Newbie
Joined: 4/5/2021
Posts: 4
|
Thank you! Solved
|
