I am working on a project where I have to capture residential address of multiple customers by opening different application forms in PDF format and enter or select that residential address on the property valuation website.
I am facing following challenges:
- Format and length of residential address differ from customer to customer on respective application form. How to select/ capture every parameter (Zone, District, Estate/ Building name, Block Name, Floor, Flat).
I have to capture these details for every customer on each PDF and select the right parameter onHSBC, Hang Seng Bank and Bank of China property valuation websites by using the drop down list.
- Every bank has defined the details in its drop down menu differently. In layman terms for example:
if the zone in the residential address (in PDF) is “HK” -
then on the bank’s website when you try to select the zone -
HSBC shows - “Hong Kong”
Hang Seng Bank shows - “Hong Kong Island”
BOC shows - “Hong Kong”
in their drop down menus.
How should I match the zone name (and this also applies to other parameters in the address - District, Building Name, Block, Floor & Flat) to the one in the drop down menu of respective bank accurately?
Please refer to the following websites and the addresses in the pdf samples here.