Hi @DavieJoe. Here’s another DAX solution using a repositioned IFERROR functions.
ExtractErrorCode2 =
VAR _ErrorCodeTextPosition = IFERROR( FIND( "errorcode:", ErrorTable[ErrorCodes] ), -1 )
VAR _ErrorCodeValuePosition = IF( _ErrorCodeTextPosition = -1, -1, _ErrorCodeTextPosition + 10 )
VAR _ErrorMessageTextPosition = IFERROR( FIND( ",errormessage", ErrorTable[ErrorCodes] ), -1 )
VAR _Result = IF(
_ErrorCodeTextPosition = -1, BLANK(),
MID(
ErrorTable[ErrorCodes],
_ErrorCodeValuePosition,
_ErrorMessageTextPosition - _ErrorCodeValuePosition
)
)
RETURN
_Result
Hope this helps.
Greg
eDNA Forum - Extract ErrorCode.pbix (29.5 KB)