Sublime Forum

Wrong repalce function

#1

Hi, now i encounter a very weird issue:
This is original text which need replace:
select *
from dispatch_user.dcs_t_task_def
where task_id like ‘iw%’
and pro_name like ‘%CHG%’;
CHG_INFO_MM
CHG_INFO_PRPC_J_L
CHG_INFO_CARD

then i search “CHG”, replace with “BAK” ,but the result is not what i want:
select *
from dispatch_user.dcs_t_task_def
where task_id like ‘iw%’
and pro_name like ‘%BAK
VARCHAR%’;
BAK
VARCHAR_INFO_MM
BAK
VARCHAR_INFO_PRPC_J_L
BAK
VARCHAR_INFO_CARD

in the beginning ,it works well .but one day ,it wroks wrong! i have removed the software and reinstall , but i has no effect!

How can i resove the problem ? Thanks!

0 Likes

#2

Looks like you have two lines in the replace field. Try expanding the replace panel by dragging on the top of it.

0 Likes