Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Removing Unwanted Data from a Field

Andy_Katona
8 - Asteroid

Team,

 

I have a long list of Lab Result values that need to be set to blank or Null(). What is the best method?  I thought of the RegEx, Formula, & Filter. Yet, there are so many I am not sure what is the best method. 

 

I have to remove the following:

 

Unremarkable
Stable
see provider notes
see provider note
see docs
see attached report
Normal, Alb 10, Cre 300,
Normal Alb 30mg/L, Cre 30
Normal A:C <30mg/g, Alb 3
normal
nl
High
Duplicate
Abnormal
Abn 30-300 150 cre 200,
30-300mg/g
30-300mg
30-300mg
30-300 Abnormal
30-300
30-300
30 mg
150mg/L
150 mg
>300mg
>300 mg/g
>300 mg
>300
>291.00
<5.0
<4
<30mg/g
<30mg normal
<30mg
<300
<30 normal
<30 mg/g
<30 mg normal
<30 mg
<30
<20
<0.7
<0.500
<0.5
< 5.0
,30
16-Sep
4/26/2016
Mar-16
2/18/2016
1/20/2016

11 REPLIES 11
Andy_Katona
8 - Asteroid

Great minds think alike. Thank you

shailendra88
6 - Meteoroid
Hi, If I am getting field like "wissall" then please help me how to remove. I tried find and replace tool:- find:-  replacement :- # Note :- when I see the alteryx result window "" shown as res note mark , something like comment/note in excel field. but no luck. Apology cannot attach anything from client network.
Labels