Does anyone know how to trunicate in Alteryx

[dgcolby]

I want to take a column of Data (example 145J) and use a RIGHT cmd to create a new column output that only keeps the last digit, in this example J.

I was thinking of using an IF/THEN statement for the same thing above. The column data I am analyzing has 3 digits followed by a letter (another example 145H), I thought by trunicating the data to just the letter, I could then write an expression that only keeps the J/H's all else would be NULL.

Any help would be great!

Regards!

Darin

[fmvizcaino]

Hi @dgcolby ,

You can use data cleansing tool to remove any digit from your cells. 

See if that works for you.

Best,

Fernando Vizcaino

[luizcarlosj · Accepted solution]

Hello!

You can use the Formula tool by creating a new column with the following expression: Right ([Data], 1)

Following are some images as an example.

I am also sending the workflow.

Regards,
Luiz Amorim

[CailinS]

You could also use the Regex Tool which has a bit more nuance and allows for a more...stringent rule than 'right()'. For instance, keep only the 4th character if it is a *letter* (something like "...(\u)" which would return null for anything that didnt have a patter of . (single character) . (single character) . (single character) \u (uppercase letter).

[JuanPortugal]

Hello!

If the data size is standard, you can use the tool "Formula" and use the "Substring" command, as in the images sent.

I am also sending the workflow.

Regards,

Juan Portugal