Split text to column by text without delimiter

[Anonymous]

hi,

I have the text string as below from html table.

It has no delimiter, please help me to extrac them into columns as below:

Problem:

Contract: ABCLocation: USADate Start: 2020Date End: 2021Requester: Mr SmithCode: 01

Contract: XYZLocation: AmerciaSDate Start: 01/07/2019Date End: 01/01/2022Requester: Jim BoCode: 0100

Required solution:

Contract Requester Location
ABC        Mr Smith  USA
XYZ        Jim Bo       Amercia

I have tried this solution but my dax knowledge is limited and cant make it works.

https://community.powerbi.com/t5/Desktop/Split-column-in-multiple-columns-based-on-text/m-p/2034418#...

thanks in advance.

[Greg_Deckler · Accepted solution]

@Anonymous Try these DAX columns:

Contract = 
    VAR __Start = SEARCH(" ",[Column]) + 1
    VAR __End = SEARCH("Location:",[Column])
RETURN
    MID([Column],__Start,__End - __Start)


Requestor = 
    VAR __Start = SEARCH("Requester: ",[Column]) + LEN("Requester: ")
    VAR __End = SEARCH("Code:",[Column])
RETURN
    MID([Column],__Start,__End - __Start)


Location = 
    VAR __Start = SEARCH("Location: ",[Column]) + LEN("Location: ")
    VAR __End = SEARCH("Date Start:",[Column])
RETURN
    MID([Column],__Start,__End - __Start)