Forum Discussion

rvnaresh's avatar
rvnaresh
Microsoft Employee
3 years ago
Solved

extract text using Multiple delimiters

Hi,   I have the data imported from a source in a table in the below format. The column "Location" contains the data and I want to extract the data into a new column (Text Retrieval) as below. Ther...
Need Help
Show and Tell
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    3 years ago

    You can use this formula in a custom column

    = if [Location]=null then "NA" else  Splitter.SplitTextByAnyDelimiter({"AZ", "F0"})([Location]){0}
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
3 years ago

You can use this formula in a custom column

= if [Location]=null then "NA" else  Splitter.SplitTextByAnyDelimiter({"AZ", "F0"})([Location]){0}