Forum Discussion

Rochejf's avatar
Rochejf
Frequent Visitor
3 years ago
Solved

Extract round figure from Text

I try using code below to extract figure from text, it works on round figure but not on float.   Text.Select([TextColumn], {"0".."9"}) This is my output below. QUANTITY x 4 4 QUANTITY...
Need Help
Tutorial Requests
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    List.Select(
  Splitter.SplitTextByAnyDelimiter({",", ".", " "})(
    Text.Select([Column1], {"1" .. "9", ",", ".", " "})
  ), 
  each _ <> ""
){0}

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

pls try this

List.Select(
  Splitter.SplitTextByAnyDelimiter({",", ".", " "})(
    Text.Select([Column1], {"1" .. "9", ",", ".", " "})
  ), 
  each _ <> ""
){0}

Rochejf's avatar
Rochejf
Frequent Visitor
3 years ago

It works. However, there's some empty cell in that column also so it will generate error result

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    pls try this

     

    List.Select(
Splitter.SplitTextByAnyDelimiter({",", ".", " "})(
    Text.Select([Column1], {"0" .. "9", ",", ".", " "})
  ), each List.ContainsAny({_},{"0" .. "9"})){0}