Is there a function to replace part of string?

Question

Line_Num

06-ZB-A23-475004-SHT1

10-ZB-A23-4750041-SHT2

2.5-ZB-A23-4750-SHT3

06-ZB-A23-475004-5H6-SHT13

Line_Num

06-ZB-A23-475004

10-ZB-A23-4750041

2.5-ZB-A23-4750

06-ZB-A23-475004-5H6

I have used the below Code

UPDATE Filename SET line_num = REPLACE(line_num, '-SHT*', '') WHERE line_num like '%-SHT%';

But it does not work. can anyone help me with this.

UPDATE Filename SET line_num = REPLACE(line_num, '-SHT*', '') WHERE line_num like '%-SHT%';

* in replace just says replace * and not all characters after T. You should use a regular expression. Maybe this post can help you : https://stackoverflow.com/questions/38877856/replace-a-part-of-a-string-with-regexp-in-sqlite3 . It seems there is actually no other way. — Shim-Sao, Dec 24 '18 at 13:00

score 0 · Answer 1 · answered Dec 24 '18 at 13:05

0

Try below query

UPDATE Filename SET line_num = substr(line_num, 1, instr(line_num, '-SHT')-1) WHERE line_num like '%-SHT%';

answered Dec 24 '18 at 13:05

1 Answers1