How to remove a certain string form string text data?
Tetsuro_W
Partner, Registered Posts: 4 Partner
Hello experts, Please help me following question.
I have a string column like:
ABCDC01
ABCD02
ABCD03
AAAA
ABCD04
BBB
Now, I would like prepare to create a column copying above string, but I want to remove specific string "ABCD" thus expected data should be:
01
02
03
AAAA
04
BBB
How can I do this?
Thanks in advance.
Best Answer
-
Sorry, I found the answer; it was replace (column1, "ABCD", "") .