I'm new to Alteryx Designer and I have what I hope is a simple question. I have a data field that is all numbers (but formatted as a V_String) and I want to convert this to add dashes to match the FAA Airworthiness Directive numbering scheme.
Examples: I wish for the string "890503" to become "89-05-03", and "20200803" to become "2020-08-03".
Any help is appreciated, thanks!
Solved! Go to Solution.
@mcoile
I used a Reverse String Function to do it.
Dont know if you have other cases other than the two sample you have given.
@Qiu, this worked, thank you!
User | Count |
---|---|
108 | |
89 | |
78 | |
54 | |
40 |