Data Prep remove a specific string

Question

​What is the best approach to solve the removal of "No Data Available" string in a column?  For instance the column could be listing name, but instead of a blank or null there is a string "No Data Available"

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
(540) 349-0215
------------------------------

Steve_Caiels · Answer

Hi Janet,

In Data Prep Studio, you can right click on the column and use the 'Replace->Using Find and Replace' option. This will act on the original column or you can select the 'create new column' option, if you prefer.

Regards,
Steve.

------------------------------
Steve Caiels
Professional Services
Altair
------------------------------
-------------------------------------------
Original Message:
Sent: 04-13-2020 05:17 PM
From: Janet Grimsley
Subject: Data Prep remove a specific string

What is the best approach to solve the removal of "No Data Available" string in a column?  For instance the column could be listing name, but instead of a blank or null there is a string "No Data Available"

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
(540) 349-0215
------------------------------
"

Mo Abdolrahim · Answer

Hi Janet,
you can create formula field and use the IF function.  Assume the column name is Name you can use the following formula:
 IF(Name="No Data Available","",Name)
The above will create a new field.
Regards
Mo

------------------------------
Mahmoud Abdolrahim
Senior Implementation & Integration Engineer
Datawatch Corporation
MA
(978) 935-3840
------------------------------
-------------------------------------------
Original Message:
Sent: 04-13-2020 05:17 PM
From: Janet Grimsley
Subject: Data Prep remove a specific string

What is the best approach to solve the removal of "No Data Available" string in a column?  For instance the column could be listing name, but instead of a blank or null there is a string "No Data Available"

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
(540) 349-0215
------------------------------
"