IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Regex replace command syntax Options · View
rihardsg
Posted: Monday, April 5, 2021 10:41:27 PM
Rank: Newbie

Joined: 4/5/2021
Posts: 2
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?
K101
Posted: Tuesday, April 6, 2021 9:49:35 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 434
Any particular reason you want to do everything in regex? How about this example?

File Attachment(s):
example.mfd (5kb) downloaded 12 time(s).

K101 attached the following image(s):
example.png

rihardsg
Posted: Tuesday, April 6, 2021 8:34:51 PM
Rank: Newbie

Joined: 4/5/2021
Posts: 2
Thank you! Solved
Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.