It's beginning to look a lot like...Advent of Code! Get in the holiday spirit by learning how you can participate in this friendly competition and earn a seasonal badge.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Reformatting data

7 - Meteor

Hi All,


In my data I have a field that contains values such as:


31/12/2023 0.55|30/06/2024 0.45

25/07/2040 0.2345|18/04/2045 0.456|01/01/2047 0.3095


I need to change these into:

55 31/12/2023|45 30/06/2024

23.45 25/07/2040|45.6 18/04/2045|30.95 01/01/2047


Thus the number after the needs to be multiplied by 100 and put in from of the date.


Above is just an example. In the actual data, there could be for example 20 or 100 date/value pairs that are separated by a pipelline.


I assume regex can do this easily? What regex expression to use?




12 - Quasar
12 - Quasar

Hi @RVDL, for a problem like this, I prefer to clean it up over multiple steps. I have attached a workflow that splits all the unique strings, cleans them up using some regex and formulas, and then puts everything back together in the format you are looking for. Let me know what you think.

11 - Bolide

@RVDL here is one solution for you. Used a combination of Regex and Formula to solve it. I am sure there is a more elegant solution with Regex Replace, but this should help you out in the interim.


Copy of Solution

3 - Solution.png


Regex Structure

1 -Regex.png

Formula Restructure to Create Solution

2 - Formula Restructure.png



7 - Meteor

@phottovy thank you. This worked fine.

7 - Meteor

@rzdodson Thanks for your suggestion.