In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Parsing a number

Aleksandar1
7 - Meteor

I need to separate the number 205123456789999911 into 3 parts, according to the principle of the first 3 characters, then the next 13, then the last 2, but I encounter a problem when this part of 13 characters has less than 13 because it is entered by the end user,my workflow later adds a 0 in front of the middle number to get 13 characters, any advice is welcome

I know that I extract the first 3 and the last 2 characters using the left and right formula, but I don't have a solution for this in the middle

10 REPLIES 10
Aleksandar1
7 - Meteor

That formula for middle number is everything i needed.

Thanks!

Labels
Top Solution Authors