Forum Discussion

Samilibbab's avatar
Samilibbab
Frequent Visitor
3 years ago
Solved

Extract custom text from the column

Hello everyone!   I have tried using delimiters, match, search and find but could not figure out how to extract the information from column A.    Please review the below table.   The final resu...
  • mussaenda's avatar
    3 years ago

    Hi Samilibbab,

     

    Please see attached pbix for your reference.

     

    Here is the snippet of the result  made.

    Just for the last row description, area m2, why the land size is not included on your extraction?

    In case you don't need the land size infor, 

    just adjust the condition on extracting the text.

     

    Hope this  helps