Forum Discussion
Find alphabetical letters from a string
Hi, I need to be able to extract MT940 (type :61:) sums from the string. Basically the issue is that i have the following: 1911011101C5555,55NTRF201911015U//SOM 19111503828 What i need to...
This expression will break up a string into a list based on alpha characters.
Text.SplitAny([nameofstringhere],Text.Combine({"a".."z","A".."Z"}))
Now just reference the second value with the index of {1}
Text.SplitAny([nameofstringhere],Text.Combine({"a".."z","A".."Z"})){1}
This expression will break up a string into a list based on alpha characters.
Text.SplitAny([nameofstringhere],Text.Combine({"a".."z","A".."Z"}))
Now just reference the second value with the index of {1}
Text.SplitAny([nameofstringhere],Text.Combine({"a".."z","A".."Z"})){1}