
Hi,
I would like to extract the red 4 digits of a string that can be variable. The result will always be a string of 4 characters, starting with an "N".
The number of characters before and after the red characters is variable.
2011101110C16000,00N654NONREF
2011101110C1604500,00N247NONREF
2011101110C1600,00N123EREF
2011091109D32,67N2470000193ID0081ING
I find however no function that looks for a specific character in the string.
docs.microsoft.com/.../er-formula-language
Any help?