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? 

question.docx

markcurry

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.

Remove parenthesis.yxmd