Replace function

Highlighted
Super Contributor

Replace function

Do we have a replace function?

I want to change a value.

4 REPLIES 4
Highlighted
Super Contributor

Re: Replace function

@Sravan_Kumar 

Can you elaborate more ?

Highlighted
Super Contributor

Re: Replace function

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

Do we have the similar in Anaplan? 

Highlighted
Super Contributor

Re: Replace function

@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

 

Highlighted
Certified Master Anaplanner

Re: Replace function

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....

 

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