Forum Discussion
Split *multiple* columns by non-digit to digit
Thanks for your reply Rocco,
When I applied the technqiue to my data it was adding another column and renaming both .1 and 2. but the data wasn't splitting between them. The 2nd of each column was simply null.
It tried to modify using the split by position (last character from teh right), which works manually, but when I tried this:
ColAreSplit= List.Accumulate(#"colstosplit", #"Capitalized Each Word", (s,c)=>Table.SplitColumn(s, c, Splitter.SplitTextByPositions({0, 1}, true),
{c&".1", c&".2"}))The columns split but I only see the headers
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