Forum Discussion

Helper I

7 months ago

Solved

Regular expression

Hi, I want to search the chain "Name" in a columns which contains among others "ApplicationName" ? example: Countries=xx; ApplicationId=nbk;Name=yvalxx; ApplicationName=sauve/netbackup; Envir...

FBergamaschi
7 months ago
Hi FP68

ApplicationName2 =

VAR TagText = Disques_Global[TAGS]

VAR _Key = "Name="

VAR _Key2 = "ApplicationName="

VAR KeyPos = SEARCH ( _Key, TagText, 1, 0 )

VAR Key2Pos = SEARCH ( _Key2, TagText, 1, 0 )

VAR ValueStart = KeyPos + LEN ( _Key )

VAR SemiPos = SEARCH ( ";", TagText, ValueStart, 0 )

RETURN

IF (

KeyPos = 0,

BLANK(),

IF (

KeyPos <> Key2Pos + 11,

IF (

SemiPos = 0,

MID ( TagText, ValueStart, LEN ( TagText ) - ValueStart + 1 ),

MID ( TagText, ValueStart, SemiPos - ValueStart )

)

)

)

If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI