How to recreate Find formula and IF error formula in alteryx

[HafeezA]

=IF(IFERROR(FIND("_P",C5086),FALSE),MID(C5086,17,3),MID(C5086,17,4))

[john_watkins]

Hit Control+F to open the Find window.    Paste a portion of your string there and it should find the formula or highlight which tool it is coming from.

[Luke_C · Accepted solution]

Hi @HafeezA 

Try something like this (swap your field name in bold)

IF Contains([Field],'_P')

Then Substring([Field],17,3)

Else Substring([Field],17,4)

Endif

[john_watkins]

Field names do need to be in [  ] brackets as well if it is just a syntax thing.