Replace function
Answers
-
Can you elaborate more ?
0 -
I wanted to know, as we have 'Replace' in excel.
Do we have the similar in Anaplan?
0 -
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
0 -
Whenever trying to convert from excel to Anaplan this is a helpful link:
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
1
