Find formula

Question

Hi Friends,

Do we have any special formulas for the below calculation.

Misbah · Accepted Answer

@Sravan_Kumar

Create additional Line item to find delimiters

Find LI = FIND(",",Old Value,1)

New Value = IF FIND LI = 0 THEN Old Value ELSE Left(Old Value,Find LI -1)

This should give you the results

prabhu · Accepted Answer

Hi @Sravan_Kumar  -

Create a new Line item(number format) and write a formula FIND(",", old)

Write the formula for new value  =   IF New Line item = 0 THEN old value ELSE LEFT(old value, New Line item - 1)

Hope it helps,

Akhtar.shahbaz · Accepted Answer

Hi @Sravan_Kumar

You can try this

Hope this helps!

Thanks

Akhtar

johndorma · Accepted Answer

SUBSTITUTE() is also an option and that will allow for replacing multiple instances of the same character without something super complex.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUBSTITUTE.htm?_ga=2.210251925.1256721239.1586888949-1317535828.1586888949