This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
Is the list of values that you want to replace static or could it possibly grow? Also, what kind of values are you trying to keep?
If you might get more of these kinds of "results" and if you only want to keep actual numbers, what about using REGEX_CountMatches to identify values that contain non-numeric, non-decimal point characters? The use an If function in a Formula tool -- If the count is non-zero, set the value to null, otherwise use ToNumber to convert to a numeric data type.