Removing symbols "$", "%" and ", " from the data

[radhikasood1112]

Hi,

I am working on removing $, % and , from the values like Net Revenue, Net Profit Margin, In such fields we see values in the form $22,333,344 or 78.98% (with comms and %age symbols, we dont need it)

Net Revenue and Net Profit Margin are the integer values.

When I use the Replace function, I get the error message cannot apply the String function to the integer value.

So, I thought of making them (Net Revenue, Net Profit Margin) String using the Select tool and then applying the Replace function, so that I can do the Data Cleaning process. After data cleaning (removing $, % and ,), I thought of converting them back to integer, but this brought me back to where it started. The values again have comma in it.

Can someone please guide?

Thanks,
Radhika

[MarqueeCrew]

Please use replacechar()

 if used in a multi field formula you can replace the current field ",$%" with ""

 cheers,

 mark

[radhikasood1112]

I used the below formula-

Replacechar([_CurrentField_], "$","")

Here, _CurrentField_ is a integer value.

Replacechar is for Strings only

I need to apply the function for the replacing the value in the integer field.

[MarqueeCrew]

Alyeryx sees your number as a string. In the multi-field formula you can change the type to double. 

Replacechar([_CurrentField_], "$,", '')

 cheers,

 mark