Start Free Trial

Alteryx Designer Desktop Discussions

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

Adding dashes within a specific field

mcoile
5 - Atom

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!

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@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.

0104-mcoile.PNG

mcoile
5 - Atom

@Qiu, this worked, thank you!

Labels
Top Solution Authors