Extract Text from String

Greg · August 13, 2021, 1:30pm

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)