Campuses
웹 (연변 – 한국) codes
business_type_update.pl #!/usr/bin/perl use strict; use warnings; # Input file my $input_file = 'business_type_original.txt'; # Output file my $output_file = 'business_type_replaced.txt'; # Open the input file for reading open my $input_fh, '<', $input_file or die...
firefox_website_02.pl extraction SQLite – http…
SELECT extracted_value, field2, CASE WHEN field2 LIKE '<%' AND field2 LIKE '%>' THEN SUBSTR(field2, INSTR(field2, '<') + 1, INSTR(field2, '>') - INSTR(field2, '<') - 1) WHEN field2 LIKE '<%' THEN 'Starts with <, but missing >' ELSE 'Does not...
firefox_website_02.pl extraction SQLite – PHONE
SELECT field2, CASE WHEN INSTR(field2, '+82') > 0 THEN SUBSTR(field2, INSTR(field2, '+82')) ELSE field2 END AS extracted_value FROM firefox_website_02;
firefox_website_02.pl
use strict; use warnings; # Initialize variables to store extracted URLs my @google_maps_urls; # Process each HTML file (1.html to 25.html) for my $file_number (1..25) { my $input_file = "${file_number}.html"; # Open the current input file for reading open my...
firefox_02.pl
use strict; use warnings; # Initialize an array to store extracted content my @extracted_content; # Process each HTML file (1.html to 25.html) for my $file_number (1..25) { my $input_file = "${file_number}.html"; # Open the current input file for reading open my...
google sheet – 15 30 45 .. 820 borderline macro
function border_151() { var spreadsheet = SpreadsheetApp.getActive(); // Define the starting and ending row numbers (15 and 820). var startRow = 15; var endRow = 820; // Loop through rows in increments of 15 and set the border. for (var row = startRow; row <=...
Seoul.html – 서울 25개 구, Firefox search tabs automation
<!DOCTYPE html> <html> <head> <title>Open Search Words in Reverse Order</title> </head> <body> <script> var searchWords = [ "한의원 중랑구 서울특별시", "한의원 중구 서울특별시", "한의원 종로구 서울특별시", "한의원 은평구 서울특별시", "한의원 용산구 서울특별시", "한의원...
Skype Call
<!DOCTYPE html> <html> <head> <title>Call Option Prompt</title> </head> <body> <h1>Welcome to Our Website</h1> <p>Choose how you want to make a call:</p> <!-- Skype Button --> <button...
Google Map Business Link from Firefox Extraction Perl
use strict; use warnings; # Initialize variables to store extracted URLs my @google_maps_urls; # Process each HTML file (1.html to 25.html) for my $file_number (1..25) { my $input_file = "${file_number}.html"; # Open the current input file for reading open my...
서울 구글 맵 Phone Extract – ORIGINAL
#!/usr/bin/perl use strict; use warnings; use HTML::TokeParser; # Input file containing a list of file names my $file_list = 'moving_seoul.txt'; # Output file for saving extracted phone numbers my $output_file = 'moving_seoul_extracted.txt'; # Open the file list for...
웹 (연변 – 한국) codes
business_type_update.pl #!/usr/bin/perl use strict; use warnings; # Input file my $input_file = 'business_type_original.txt'; # Output file my $output_file = 'business_type_replaced.txt'; # Open the input file for reading open my $input_fh, '<', $input_file or die...
firefox_website_02.pl extraction SQLite – http…
SELECT extracted_value, field2, CASE WHEN field2 LIKE '<%' AND field2 LIKE '%>' THEN SUBSTR(field2, INSTR(field2, '<') + 1, INSTR(field2, '>') - INSTR(field2, '<') - 1) WHEN field2 LIKE '<%' THEN 'Starts with <, but missing >' ELSE 'Does not...
firefox_website_02.pl extraction SQLite – PHONE
SELECT field2, CASE WHEN INSTR(field2, '+82') > 0 THEN SUBSTR(field2, INSTR(field2, '+82')) ELSE field2 END AS extracted_value FROM firefox_website_02;
firefox_website_02.pl
use strict; use warnings; # Initialize variables to store extracted URLs my @google_maps_urls; # Process each HTML file (1.html to 25.html) for my $file_number (1..25) { my $input_file = "${file_number}.html"; # Open the current input file for reading open my...
firefox_02.pl
use strict; use warnings; # Initialize an array to store extracted content my @extracted_content; # Process each HTML file (1.html to 25.html) for my $file_number (1..25) { my $input_file = "${file_number}.html"; # Open the current input file for reading open my...
google sheet – 15 30 45 .. 820 borderline macro
function border_151() { var spreadsheet = SpreadsheetApp.getActive(); // Define the starting and ending row numbers (15 and 820). var startRow = 15; var endRow = 820; // Loop through rows in increments of 15 and set the border. for (var row = startRow; row <=...
Seoul.html – 서울 25개 구, Firefox search tabs automation
<!DOCTYPE html> <html> <head> <title>Open Search Words in Reverse Order</title> </head> <body> <script> var searchWords = [ "한의원 중랑구 서울특별시", "한의원 중구 서울특별시", "한의원 종로구 서울특별시", "한의원 은평구 서울특별시", "한의원 용산구 서울특별시", "한의원...
Skype Call
<!DOCTYPE html> <html> <head> <title>Call Option Prompt</title> </head> <body> <h1>Welcome to Our Website</h1> <p>Choose how you want to make a call:</p> <!-- Skype Button --> <button...
Google Map Business Link from Firefox Extraction Perl
use strict; use warnings; # Initialize variables to store extracted URLs my @google_maps_urls; # Process each HTML file (1.html to 25.html) for my $file_number (1..25) { my $input_file = "${file_number}.html"; # Open the current input file for reading open my...
서울 구글 맵 Phone Extract – ORIGINAL
#!/usr/bin/perl use strict; use warnings; use HTML::TokeParser; # Input file containing a list of file names my $file_list = 'moving_seoul.txt'; # Output file for saving extracted phone numbers my $output_file = 'moving_seoul_extracted.txt'; # Open the file list for...
350 250 85 {8,000 .. 60万} 유지 生活 中、
"Address"
PO Box 56457
North Pole, AK 99705
750 W Dimond Blvd Ste 103 #282
Anchorage, AK 99515
Phone
(907) 744-6435
CsamiGroup@gmail.com