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

     

slorin's avatar
slorin
Super User
3 years ago

Or split by character transition

= Table.SplitColumn(
   Source,
   "Data",
   Splitter.SplitTextByCharacterTransition((c) => not List.Contains({"0".."9"}&{"."}, c), {"0".."9"}),
   {"Col A", "Col B"})

Stéphane