How can I remove everything before "***"?
I have data coming in in the format:
| Product |
| - *** 1100L WHEELED BIN RECYCLING |
| - *** SIZE 4 BIN |
| 4 *** SIZE 4 BIN RECYCLING |
| = *** 1100L WHEELED BIN RECYCLING |
I want the data to be :
| Product |
| *** 1100L WHEELED BIN RECYCLING |
| *** SIZE 4 BIN |
| *** SIZE 4 BIN RECYCLING |
| *** 1100L WHEELED BIN RECYCLING |
How can I use
Regex_Replace
or
Regex Trim?
to remove everything before *?