Forum Discussion

Linnil's avatar
Linnil
Helper III
3 years ago
Solved

Separate Integer or Decimal from Text

Hi   I have values like this:   BL, JZ5, CC6.3 So Text combined with an integer or Text combined with a decimal value.   I would like the data to split into Col A and Col B   Data Col A ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    3 years ago

    Following will be a simple solution based on test cases presented by you.

    For selecting Text
= Text.Select([Data], {"A".."Z","a".."z"})

For selecting Number
= Text.Select([Data], {"0".."9","."})

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
3 years ago

Following will be a simple solution based on test cases presented by you.

For selecting Text
= Text.Select([Data], {"A".."Z","a".."z"})

For selecting Number
= Text.Select([Data], {"0".."9","."})