Forum Discussion
k1s1
Helper I
Helper IMore efficient way to keep only numbers in multiple columns
Hello I'm using this to strip out everything except numerals from ~150 columns: #"Convert response to numbers"=Table.TransformColumns( #"Removed Columns1" , {{"Column1 Name", each Text.Sele...
the first thing that comes to mind is to merge all the columns through a character not present in the texts (#, for example) apply your rules to the union columns and then redo the division of the colonan through the added separator (# , in the example)
- If you don't post a meaningful example of your data, I can't give you a specific / complete answer.
- On the other hand, being, as you say yourself, you are inexperienced, you are unable to adapt my suggestion to your specific case.
- do you have any idea how to overcome the impasse?
k1s1Helper I
Helper IHello Rocco,
re 1 - I don't know what's not meanignfgul about the way I described the data
re 2 - I don't understand it
re 3 - No I don't, but thanks anyway for your efforts on this