Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
95
Views
Topic starter
I have a column in my raw data that has multiple types of text which mean the same thing to my customers.
Ex: Failure Mode B, Category B, B
I want all of these to just read B. I looked at Text.TrimStart, but was unable to make that work for me. Is there a way to have the Editor transform the data so that all of these texts read B only?
Thank you in advance.
Posted : 06/01/2018 2:11 pm
Hi Crystal,
If you only want to keep the last character then you can use Text.End e.g.:
=Text.End( [your text column], 1)
Mynda
Posted : 06/01/2018 7:35 pm
