Forum Discussion

LearningBI1986's avatar
LearningBI1986
Frequent Visitor
3 years ago
Solved

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 🙂

1 Reply

  • Nevermind! I have it! Just simply split the column by number of characters!