Hi @Jesper_Holmstrom

Im actually using your formula and im not getting #Error where there is no “Message”

Not sure what type of field is {Telefon 1} though.

I would however try to do this:

IF(AND({Telefon 1},FIND("Message", {Telefon 1})>0),(LEFT({Telefon 1}, FIND("Message", {Telefon 1}) -1)),BLANK())

Hi Mohamed


I can’t get this to work, I have the same problem with this formula that extracts text, but get the error message when the word Interest doesn’t exist:


IF({Meddelande 1},REGEX_EXTRACT({Meddelande 1},"(?:interest:)(ta-zA-Z\\a-zA-Z\\a-zA-Z]*)"),BLANK())

The “telefon 1” field is an formula field and “meddelande 1” is just long text field.

Hi @Jesper_Holmstrom

So did the first formula work?

For the second formula, I dont experience with REGEX sorry

Hi @Mohamed_Swellam


No sorry but it didn’t work…cant understand why,

@Mohamed_Swellam I now got your formula to work but It seems that the problem is further down with this formula:


IF({Meddelande 1},REGEX_EXTRACT({Meddelande 1},"(?:interest:)([a-zA-Z\\a-zA-Z\\a-zA-Z]*)"),BLANK())


If there is no “interest:” in the field I want the formula field to be blank. Anyone got an idea?


Thanks


Jesper

Wrap your formula in…

IF(FIND('interest:', {Meddelande 1}), *<insert your formula here>* )

IF(FIND('interest:', {Meddelande 1}), *<insert your formula here>* )

Yup that did the trick!


Thanks @augmented

As a side note, you can omit the BLANK() function at the end. By default if there’s no third argument in an IF() function, it returns nothing, which will automatically leave the field empty.

OK, thanks @Justin_Barrett, I didn’t know that!