The address_1, address_2 and address_3 are the raw data collected in hand and they summed up together to be the complete whole address. And now I have to like sort the whole address into the corresponding data columns like flat, floor, building, street and district. I have tried to use the if then statement but it was too troublesome to do so and took me long time to execute like the whole data set contains like thousands of items. Can array and do loop help to do the task? Input: ADDRESS_1 ADDRESS_2 ADDRESS_3 ROOM 11 23/F 61-63 YYY RD District A ROOM 10 1/F ABC BLDG 33-37 ZZZ STREET District B UNIT A1 G/F QWE SQUARE 29 XYZ RD District A ROOM 16 3/F WATER HOUSE 46 XXX ROAD District C Output: floor flat building street district 23 11 61-63 YYY RD A 1 10 ABC BLDG 33-37 ZZZ STREET B G A1 QWE SQUARE 29 XYZ RD A 3 16 WATER HOUSE 46 XXX ROAD C Thanks!
... View more