Forum Discussion
Solved
Reverse Text
is thier a way to flip (reverse) the contant of a field i.e volumn x has the value 12345 i need it to be displayed 321
Are you reversing and truncating or just reversing? You can reverse text in M by saying
Text.Combine(List.Reverse(Text.ToList("12345")))
Nothing that I can find here:
https://msdn.microsoft.com/en-us/library/ee634938.aspx
You might be able to get there with some really nasty code that uses LEN and LEFT, etc.
I also looked here:
M Code has a List.Reverse, but you have to get the string into a list format and Text.Split requires a delimiter so not sure how you might accomplish that one in M Code.
Probably a way but I'd have to think on it...