March 2024 – crm270s.

2024-03-29

https://www.focuscolorado.net/

덴버 지역 한인 업소록 발급 한단다, according to DenverLotteTour.com (3/29/2024).

2024-03-29

중앙일보 Yellowpage after combined_output_02

delete from combined_output_02 where field1 like 'field%'

MAKE field9

MAKE URL field

MAKE AreaCode field

MAKE TEL field

ALTER TABLE combined_output_02
ADD COLUMN field9 TEXT;

ALTER TABLE combined_output_02
ADD COLUMN URL TEXT;

ALTER TABLE combined_output_02
ADD COLUMN AreaCode TEXT;

ALTER TABLE combined_output_02
ADD COLUMN TEL TEXT;

ID auto number primary key add

MAKE ID field, Primary Key

한글 상호, update field7 to field8

UPDATE combined_output_02
SET field8 = field7
WHERE field8 IS NULL;

URL move, field3, field4, field5, field6

UPDATE combined_output_02
SET URL = 
    CASE 
        WHEN field7 LIKE 'URL%' THEN field7
        WHEN field6 LIKE 'URL%' THEN field6
        WHEN field5 LIKE 'URL%' THEN field5
        WHEN field4 LIKE 'URL%' THEN field4
        ELSE URL -- Keep the existing URL value if none of the conditions are met
    END;

do above for field4, field5, field6, etc.

update combined_output_02 set URL = substr(URL, -length(URL) + 5)

add field9, and copy field4, field5, field6 TEL

copy phone TEL: xxx-xxx-xxx:

UPDATE combined_output_02
SET field9 = 
    CASE 
        WHEN field5 LIKE 'TEL:%' AND LENGTH(field5) = 17 THEN field5
        WHEN field4 LIKE 'TEL:%' AND LENGTH(field4) = 17 THEN field4
        WHEN field6 LIKE 'TEL:%' AND LENGTH(field6) = 17 THEN field6
        ELSE field9 -- Keep the existing value of field9 if none of the conditions are met
    END;

reformat phone TEL: (xxx) xxx-xxxx:

UPDATE combined_output_02
SET field9 = 
    CASE 
        WHEN field5 LIKE 'TEL%(%)%' AND LENGTH(field5) = 19 THEN
            SUBSTR(field5, 1, 5) || SUBSTR(field5, 7, 3) || '-' || SUBSTR(field5, 12, 3) || '-' || SUBSTR(field5, -4)
        WHEN field4 LIKE 'TEL%(%)%' AND LENGTH(field4) = 19 THEN
            SUBSTR(field4, 1, 5) || SUBSTR(field4, 7, 3) || '-' || SUBSTR(field4, 12, 3) || '-' || SUBSTR(field4, -4)
        WHEN field6 LIKE 'TEL%(%)%' AND LENGTH(field6) = 19 THEN
            SUBSTR(field6, 1, 5) || SUBSTR(field6, 7, 3) || '-' || SUBSTR(field6, 12, 3) || '-' || SUBSTR(field6, -4)
        ELSE
            field9 -- Keep the existing value of field9 if none of the conditions are met
    END;

reformat phone TEL: (xxx)xxx-xxxx:

UPDATE combined_output_02
SET field9 = 
    CASE 
        WHEN field5 LIKE 'TEL%(%)%' AND LENGTH(field5) = 18 THEN
            SUBSTR(field5, 1, 5) || SUBSTR(field5, 7, 3) || '-' || SUBSTR(field5, 11, 3) || '-' || SUBSTR(field5, -4)
        WHEN field4 LIKE 'TEL%(%)%' AND LENGTH(field4) = 18 THEN
            SUBSTR(field4, 1, 5) || SUBSTR(field4, 7, 3) || '-' || SUBSTR(field4, 11, 3) || '-' || SUBSTR(field4, -4)
        WHEN field6 LIKE 'TEL%(%)%' AND LENGTH(field6) = 18 THEN
            SUBSTR(field6, 1, 5) || SUBSTR(field6, 7, 3) || '-' || SUBSTR(field6, 11, 3) || '-' || SUBSTR(field6, -4)
        ELSE
            field9 -- Keep the existing value of field9 if none of the conditions are met
    END;

repeat above for TEL: in field4 and field6

area_code field add

UPDATE combined_output_02
SET AreaCode = substr(field9, 6, 3)

UPDATE field9 into TEL

update combined_output_02 set TEL = substr(field9, -12) where field9 is not null

AreaCode_TimeZone import

StandardTimeZone add

select combined_output_02.* , AreaCode_TimeZone.StandardTimeZone from combined_output_02 LEFT join AreaCode_TimeZone on combined_output_02.AreaCode = AreaCode_TimeZone.AreaCode

unique_phone sort out

SELECT MIN(ID) AS min_ID, TEL
FROM combined_output_02_timezone
GROUP BY TEL

select * from combined_output_02_timezone where ID in (select min_ID from unique_phone)

2024-03-28

KoreaDaily AreaCode

update combined_output_02_unique_phone 
set AreaCode = substr(field9, 6, 3)

2024-03-28

KoreaDaily URL update

UPDATE combined_output_02_unique_phone
SET URL = field7
WHERE field7 like 'URL%'

do above for field4, field5, field6, etc.

2024-03-28

KoreaDaily UniquePhone

sorts out unique phone number from KoreaDaily comprehensive downloads:

SELECT MIN(ID) AS min_ID, field9
FROM combined_output_02
GROUP BY field9

selects Unique phone:

select * from combined_output_02 where ID in (select min_ID from unique_phone)

AreaCode addition:

select combined_output_02_unique_phone.* , AreaCode_TimeZone.StandardTimeZone from combined_output_02_unique_phone LEFT join AreaCode_TimeZone on combined_output_02_unique_phone.AreaCode = AreaCode_TimeZone.AreaCode

2024-03-27

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

2024-03-15

PrimaFinancial Loan Rates .png color change Python Code

red to blue:

from PIL import Image
import colorsys

def rgb_to_hsv(r, g, b):
    # Convert RGB values to HSV
    h, s, v = colorsys.rgb_to_hsv(r / 255.0, g / 255.0, b / 255.0)
    return h, s, v

def hsv_to_rgb(h, s, v):
    # Convert HSV values to RGB
    r, g, b = colorsys.hsv_to_rgb(h, s, v)
    return int(r * 255), int(g * 255), int(b * 255)

def change_red_to_blue(image_path, output_path):
    # Open the image
    img = Image.open(image_path)

    # Convert the image to RGB mode (if it's not already)
    img = img.convert("RGB")

    # Get the width and height of the image
    width, height = img.size

    # Iterate through each pixel in the image
    for x in range(width):
        for y in range(height):
            # Get the RGB values of the pixel
            r, g, b = img.getpixel((x, y))

            # Convert RGB to HSV
            h, s, v = rgb_to_hsv(r, g, b)

            # Check if the pixel is red (adjust the threshold as needed)
            if (h < 0.05 or h > 0.95) and s > 0.5 and v > 0.5:
                # Change the pixel color to blue
                img.putpixel((x, y), (0, 0, 255))

    # Save the modified image
    img.save(output_path)
    
    # Close the image file
    img.close()

if __name__ == "__main__":
    # Specify the input and output file paths
    input_image_path = "prima_up_blue_down_red.png"
    output_image_path = "blue_version.png"

    try:
        # Change red to blue
        change_red_to_blue(input_image_path, output_image_path)
        print("Output image saved successfully.")
    except Exception as e:
        print("An error occurred while saving the output image:", e)

green to red:

from PIL import Image
import colorsys

def rgb_to_hsv(r, g, b):
# Convert RGB values to HSV
    h, s, v = colorsys.rgb_to_hsv(r / 255.0, g / 255.0, b / 255.0)
    return h, s, v

def hsv_to_rgb(h, s, v):
# Convert HSV values to RGB
    r, g, b = colorsys.hsv_to_rgb(h, s, v)
    return int(r * 255), int(g * 255), int(b * 255)

def change_red_to_blue(image_path, output_path):
# Open the image
    img = Image.open(image_path)

# Convert the image to RGB mode (if it's not already)
    img = img.convert("RGB")

# Get the width and height of the image
    width, height = img.size

# Iterate through each pixel in the image
    for x in range(width):
        for y in range(height):
        # Get the RGB values of the pixel
            r, g, b = img.getpixel((x, y))

        # Convert RGB to HSV
            h, s, v = rgb_to_hsv(r, g, b)

        # Check if the pixel is green (adjust the threshold as needed)
            if (h > 0.2 and h < 0.4) and (s > 0.3 and s < 0.7) and (v > 0.3 and v < 0.7):
            # Change the pixel color to red
                img.putpixel((x, y), (255, 0, 0))

# Save the modified image
    img.save(output_path)

# Close the image file
    img.close()
if __name__ == "__main__":
    # Specify the input and output file paths
    input_image_path = "red_to_blue_version.png"
    output_image_path = "green_to_red_version.png"

    try:
        # Change red to blue
        change_red_to_blue(input_image_path, output_image_path)
        print("Output image saved successfully.")
    except Exception as e:
        print("An error occurred while saving the output image:", e)

2024-03-01

919-609-1289

사장인 듯한 사람이 웹 사이트 하나 더 필요하다고 전화 왔음. NCDaeHanExpress.com은 이미 사용하고 있는 고객 (3/1/2024).

Info@DaeHanExpress.net – 이멜 주소.

KoreanExpressGroup.com – 원하는 도메인 (3/4/2024).

Address: 3913 Maplefield Dr. Raleigh, NC 27613 TEL: 919-609-1289 제공 서비스는 나중에 정리해서 보내 준단다. LA 지점: 213-700-4434 회사명: Korean Express Group LLC (3/4/2024).

http://www.verygoodboston.com/ – 보스톤, “참 좋은 이사” 참고 하란다 (3/5/2024).

현재 캘리포니아에 있으며, 오늘 중으로 $41 인보이스 처리할 것이며, KoreanExpressGroup.com으로 도메인 연결, 구글에 올려 주기 바람 (3/18/2024).

랄리 한인회 있단다. 그 쪽 한인 인구가 2만5천 정도 된단다 (3/29/2024).