Convert String in parenthesis to Negative Number

KNIME Analytics Platform
1

Hello! Knime newbie. How can I convert a string in this format (1,000.00) to a negative number?

Thanks in advance!

2

Hi @arodil Welcome to the forum

Use a String Manipulation node with:
removeChars( (replace($column1$,"(" ,"-" ) ) ,")" )
and after that a String to Number node

gr. Hans

2 Likes
3

You can use String Manipulation node with this expression:

regexReplace("$column1$","\\(([^\\(\\)]*)\\)" ,"-$1" )

2 Likes
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.