Data Cleansing

[Tame]

Hello,

Which tool, or  how can I removes letters from values in Alteryx?

[ShankerV]

Hi @Tame 

[ShankerV]

Hi @Tame 

We can also make use of Formula tool with regex replace function.

Also use Regex tool based on the input and output.

Please find the use case for your scenario.

Input is.

Output is:

Many thanks

Shanker V

[Tame]

Thank you for sharing. is there a tool that makes you cut off after a certain amount of values. like a limit? for instance I want after the 6 values delete every thing else :) 

[ShankerV]

Hi @Tame 

Please use, Formula tool 

Function to be used is Left().

Many thanks

Shanker V

[MilindG · Accepted solution]

[Tame]

Thank you!!!!