KoreaDaily.db final SQL

---

below code updates 한글 상호:

UPDATE combined_output_02
SET field8 = field7
WHERE field8 IS NULL;

---

copy phone TEL: xxx-xxx-xxx:

UPDATE combined_output_02
SET field9 = field5
where field5 like 'TEL:%' and length(field5) = 17

---

reformat phone TEL: (xxx) xxx-xxxx:

UPDATE combined_output_02
SET field9 = substr(field5, 1, 5) || substr(field5, 7, 3) || '-' || substr(field5, 12, 3) || '-' || substr(field5, -4) 
WHERE field5 like 'TEL%(%)%' and length(field5) = 19

---

reformat phone TEL: (xxx)xxx-xxxx:

UPDATE combined_output_02
SET field9 = substr(field5, 1, 5) || substr(field5, 7, 3) || '-' || substr(field5, 11, 3) || '-' || substr(field5, -4)
WHERE field5 like 'TEL%(%)%' and length(field5) = 18

---

repeat above for TEL: in field4 and field6

---