Remove "X" number of Characters from End of String.

[Fescobar]

Hello,

I am in need of a little help.  

I have been using the good old =Left,<>,LEN(<>)-#) formula in Excel way too much because of the way our product numbers are entered.  Some have as much as 13 characters in length and as few as 0.  My issue is that need to be able to create sets of Product numbers in lengths of 10, 11, 12, and 13.  So I have been doing all of the work in Excel creating multiple columns for each of the Product Number lengths.  So my workbooks end up looking like the image below(attached).

I am trying to recreate this in Alteryx, but I am stuck at calling out the length of characters in each field.  Any assistance with this will be greatly appreciated. 

[apathetichell · Accepted solution]

This is how I would do it - assuming I understood your request correctly.

[AngelosPachis]

Hi @Fescobar 

Do you mind taking a look at the attached workflow? I have annotated each step to explain what goes on

Hope that helps,

Angelos

[Fescobar]

Thank you Both!

[Fescobar]

.@apathetichell

This worked like I charm.  My dataset includes some additional columns of data I could not share, but it was easy enough to make the changes.  

Thank you!

[apathetichell]

glad to hear! I also padded zeros left in the Formula tool but obviously some systems use padded zeros right - that's easy enough to change if you need it.