If field1 contains 'highest peak' then take the words behind highest peak

[terrellchong]

This file is from challenge file. I found myself stuck at this. Please advise.

What should I type in the L part?

IF Contains('Highest peak', [Field1]) THEN L ELSE f ENDIF

[Jonathan-Sherman · Accepted solution]

Hi @terrellchong,

You could use the Replace function:

IF Contains([Field1], 'Highest peak: ')
THEN Replace([Field1], 'Highest peak: ', '')
ELSE [Field1]
ENDIF

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan