Forum Discussion
Split *multiple* columns by non-digit to digit
sei sicuro che sia il codice che ti ho dato io?
a me non sembra.
Like I said, the code you posted did not work with my data - it split the columns but null in the second column. Then I tried a different split method described above, but since I don't know M, probably I made some mistake that does not display the rows
as you can see this code produce the result you where looking for, seems to me.
Here colstosplit = {"Colonna1","Colonna2"} change this according to your needs
#Modificato Tipo# is the result of the previuos step: for me is the source table on which to apply a succession of column splits
PS
If you show us the error you get or the situation you are just before start splitting, may be someone can find the rigth soltuion
I think I understand that, but your #"Modificato tipo" just changes the type of the selected columns to text, right? Isn't it the next step colstosplit={"Colonna1","Colonna2"}, that defines the columns to apply the split to?
Also, what do the "s" and "c" refer to? and the " (s,c)=>"I'm trying to use your aprpoach but now with the Splitter.SplitTextByPositions (because I realised some records in the fields don't have a last character that is a digit).
I can't find anything like that s & c in the function references for splitter functions (https://docs.microsoft.com/en-us/powerquery-m/splitter-functions)