Forum Discussion

reno1's avatar
reno1
Frequent Visitor
9 years ago
Solved

Parse Existing Column in DirectQuery mode

Hi, I'm working with a table that, in one column, contains different strings of text that I need to extract data from. Some of these strings include: "Matched with confidence: 100%" "Connection E...
Need Help
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi reno1

     

    Are you able to add calcualted columns to your tables?  If so this might be close

     

    Parsed Column = 
var myStart = FIND("onfidence:",'Table3'[Text],,0)
var myLength= FIND("%",Table3[Text],myStart + 11,0) - (myStart + 11)
var myResult = IF(myStart>0,MID('Table3'[Text],myStart + 11,myLength),Blank())
RETURN int(myResult)
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi reno1

 

Are you able to add calcualted columns to your tables?  If so this might be close

 

Parsed Column = 
var myStart = FIND("onfidence:",'Table3'[Text],,0)
var myLength= FIND("%",Table3[Text],myStart + 11,0) - (myStart + 11)
var myResult = IF(myStart>0,MID('Table3'[Text],myStart + 11,myLength),Blank())
RETURN int(myResult)
reno1's avatar
reno1
Frequent Visitor
9 years ago

Phil_Seamark, this works perfectly! Thank you