Replace function

Sravan_Kumar

Do we have a replace function?

I want to change a value.

Kanishq17

@Sravan_Kumar 

Can you elaborate more ?

Sravan_Kumar

I wanted to know, as we have 'Replace' in excel.

Do we have the similar in Anaplan? 

Kanishq17

@Sravan_Kumar 

For text , SUBSTITUTE function is there which enables to replaces a portion in a text line item with a new string,

to replace numbers, you can convert into text using TEXT(), then substitute , then convert substitiuted text into number using value()

 

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUBSTITUTE.htm

 

jasonblinn

Whenever trying to convert from excel to Anaplan this is a helpful link:

https://help.anaplan.com/anapedia/Content/Calculation_Functions/Function%20Usage/Excel%20Comparison.htm

 

Depending on your exact case, you could use a combo of FIND(), LEN(), LEFT(), RIGHT(), etc. Alternatively if you are finding a specific text and want change it for something else then you could use SUBSTITUTE() like @Kanishq17 mentioned above.

 

Jason