Forum Discussion
Removing like strings in one column
Hey guys,
I have a column of "Charge Description," and would like to shorten the text in the column.
It looks something like this:
Shop(1) - 1st Checked Bag
Shop(2) - 1st Checked Bag
Shop(5) - 1st Checked Bag
Shop(3) - 1st Checked Bag
Shop(10) - 2nd Checked Bag
Shop(9) - 2nd Checked Bag
and so on.
It there a way to remove all of the Shop() values, and hyphens (leaving only 1st Checked Bag, 2nd Checked Bag, etc.), in one step?
Have been googling for a while now and can't seem to find an answer.
Tried something similar to this but no success yet, because it's not entirely correct, I'm sure -
List.Transform([GL Charge Description], each Text.Contains((FindStrings[GL Charge Description]),-))
Any help is appreciated. Thanks 🙂
Nevermind! I have it! Just simply split the column by number of characters!
1 Reply
- LearningBI1986Frequent Visitor
Nevermind! I have it! Just simply split the column by number of characters!