1. In an Excel file, the data in "Website" column is followed by ":80" on each new line (there are approx 7,000 rows).
(eg [url removed, login to view])
Please make a code that will delete ":80" from all the web addresses.
2. Add 2 new columns of data into attached file searchresultshtm2_cvs.asp.
Name the columns "BANK ID" & "BANK EMAIL FORMAT".
BANK ID: should take data from banks table: field "bank_id"
BANK EMAIL FORMAT: should take data from banks table: field "bank_email_format"
3. When data is downloaded via attached file [url removed, login to view], there is column "Website".
Please insert "http://" before each website address in Website column downloaded.