Alteryx Designer Discussions

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

How to remove unwanted digits in a column

vnn2492
6 - Meteoroid

Hi There, I have a requirement where I need to remove 2020/2021 in a entire column. any leads would help will be more helpful. for reference I have attached screenshot where from the column name client ID conc I need to remove 2020/2021.

vnn2492_0-1641394008275.png

 

3 REPLIES 3
Luke_C
15 - Aurora

Hi @vnn2492 

 

Use a formula tool with a replace function:

 

replace([Client ID Conc],'2020/2021','')

 

Luke_C_0-1641394256118.png

 

Sebastiaandb
11 - Bolide

Hi @vnn2492 ,

 

Here you go:

REGEX_Replace([Field1], "\d{4}/\d{4}", "")

 

it will work with all year combinations

 

Sebastiaandb_0-1641394439908.png

 

AZuc
Alteryx
Alteryx

substring([client ID conc],9)

 

*perhaps is 10 instead of 9. I haven't tested

André Zuccatti

Sales Engineer - LATAM -
Alteryx, Inc.


Labels