TEXTAFTER function of excel

gauravgarg
Level 2
TEXTAFTER function of excel

Is there any similar formula/ recipe to this function of excel?

I'm trying to extract data after a certain type of character from a particular cell. I don't want to use Split as the characters are repetitive in nature.

Plus the position will not work as it is changing.

 

However, what's certain is the place of the character i.e after this character appears for the first time in cell then I want all the data after that character from the cell.

 

For e.g

Total Assets → Non-Current Assets → Gross Non-

I want Non-Current Assets → Gross Non-

 

0 Kudos
1 Reply
Turribeach

You can use indexOf to find out the first position of your character. If there is only two of the characters you can use lastIndexOf to find out the second position of your character. If there are many then you can find out the first one, then substring from the first one till the end and do another search for the first one using indexOf again. Then add indexOf from the first search and indexOf from the second and you have the second position of your character in the full string. Finally use get (substring) to chop from the first character to the second character position.

https://doc.dataiku.com/dss/latest/formula/index.html#string-functions

 

0 Kudos