I haven't found an answer in the forum for my specific problem, and my regex knowledge is to bad to adapt other examples to my need.
My Problem is a field with a list of words for example:US,New York,New York,Met
I would like to reverse the order of the list with a format action into:Met, New York, New York, US
to paste the result into another field.
with two more difficulties:
First there might be up to 5 comma separated values in the List, but sometimes only 1, 2 or 3.
Second the List might be separated by"," or ", " so if the regex could cater for those possibilities it would perfect. Allthouht the second i could standardize myself to ", " before.
and another problem I have, how to reverse a date from YYYY-MM-DD into DD-MM-YYYY.
I would be great if someone had a solution. just reading the regex help doesn't give me the right clues.
Or to be more correct my brain has difficulties understanding the concept.