What command should I use to remove the numbers in this cell here?
“Deposit - Telecom 300.00”
Thank you for any help in advance.
What command should I use to remove the numbers in this cell here?
“Deposit - Telecom 300.00”
Thank you for any help in advance.
Hello @lywei and welcome to the KNIME forum.
The most straight forward way could be a ‘Rule Engine’ node with the following coding and replacing the $value$ column (if the value is a text as you quoted it):
$value$ LIKE "Deposit - Telecom 300.00” => ""
TRUE => $value$
If it’s a numeric value in $Deposit - Telecom$ column:
$Deposit - Telecom$ = 300 => 0
TRUE => $Deposit - Telecom$
BR
In case you have multiple values that are similar in nature, the hardcoded route from @gonhaddock won’t work and you are better of with something like replacing \b[ 0-9.]+\b
with null. Can be done through String Replacer, Column Expression, etc.
In:
Out:
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.