Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

xml.document

Hello,  One of the column I have is an xml type.   It contains information as follow:   <?xml version="1.0" encoding="utf-16"?> <string><DLTKVisionMessage><ReturnCode>ErrDataVal</ReturnCode><Ret...
  • ElenaN's avatar
    ElenaN
    7 years ago

    Hello,

     

    In Power Query you can add a new column for each case using the following formula:

     

    = Text.BeforeDelimiter(Text.AfterDelimiter([Column1], "<MsgCode>"), "</MsgCode>")

    For each column you have to modify the search text accordingly.

     

    Regards,

    ElenaN

ElenaN's avatar
ElenaN
Icon for Resolver V rankResolver V
7 years ago

Hello,

 

In Power Query you can add a new column for each case using the following formula:

 

= Text.BeforeDelimiter(Text.AfterDelimiter([Column1], "<MsgCode>"), "</MsgCode>")

For each column you have to modify the search text accordingly.

 

Regards,

ElenaN

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello,

 

Thanks for the solution.  It seems to work well.  Do you have the equivalent function in DAX?