Removing parenthesis

[davidkelly6024]

In my data there are parenthesis around negative numbers see attached snip. I would like to remove the parenthesis to change the data type to double. How would I be able to parse out the parenthesis? 

[MilindG]

@davidkelly6024 

[markcurry · Accepted solution]

Hi @davidkelly6024 ,

As the values contain the ()'s they'll in string format.   Use this formula, then change the data type afterwards to a Float or Double...

IF Contains([F4],"(") THEN
"-" + ReplaceChar([F4], "(),", "")
ELSE
ReplaceChar([F4], ",", "")
ENDIF

See the attached workflow.