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","."})

     

jmpmolegraaf's avatar
jmpmolegraaf
Frequent Visitor
3 years ago

if the first two characters are always letters followed by a number or not, then you can split the columns after the second character. "Add Column", "Extract", "Length" for example?

  • Linnil's avatar
    Linnil
    Helper III
    3 years ago

    Sorry - I should have mentioned that the text might be 2-3-4 characters, so none of those solutions work.