Get text value after particular word in dax

[jeongkim]

Hi,

I wanna get FHDB only which after 'unitName='.

Please help 

1400 unitName=FHDB path=/SMOD_R-1/rf_ext1/RMOD_R-1/opt_if2/RMOD_R-2/

[HarishKM]

@jeongkim Hey,
Try below dax as my understanding

UnitName =
VAR StartPos = SEARCH("unitName=", [YourColumnName]) + 9
VAR EndPos = SEARCH(" ", [YourColumnName] & " ", StartPos) - 1
RETURN
MID([YourColumnName], StartPos, EndPos - StartPos + 1)

Thanks

Harish KM

Please accept this as a solution if this solves your problem and give kudos as well.

[v-achippa]

Hi @jeongkim,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Ahmedx and @MasonMA for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @jeongkim,

We wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @jeongkim,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[Ahmedx · Accepted solution]

pls try