Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Removing trailing text and formatting the column

romachainani
6 - Meteoroid

I have these values in a column:

1233456 ABC-DEF

12349845863446 JKL-MNO

1234667 UVWWW-XYZ

3445767545

 

What I want the column to look like:

ABC123456

JKL12349845863446

UVWWW1234667

3445767545

 

Any help will be appreciated, thank  you!

 

 

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @romachainani 

 

Try this formula

REGEX_Replace(Input, '(\d+)\s?(\w+)?(\-\w+)?', '$2$1')

 

formula.png

KamenRider
11 - Bolide

Please see my solution using the text to column tool.

 

Trailing01.PNG

Trailing02.PNG

Trailing03.PNG

Trailing04.PNG

Trailing05.PNG

 

Trailing06.PNG

 

Trailing07.PNG

 

regards,

Kamen

Labels
Top Solution Authors