How to remove a certain string form string text data?

Solved!
Tetsuro_W
Level 2
How to remove a certain string form string text data?

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.

0 Kudos
1 Solution
Tetsuro_W
Level 2
Author

Sorry, I found the answer; it was replace (column1, "ABCD", "") . 

View solution in original post

0 Kudos
1 Reply
Tetsuro_W
Level 2
Author

Sorry, I found the answer; it was replace (column1, "ABCD", "") . 

0 Kudos