Forum Discussion
Combine multiple Address field columns from the same table
Hello,
I have 4 address columns in the same table namely Address1, Address2, City, and zipcode. I need to merge it into 1 column, so far I have tried
Formula 1:
Address = [Address1] & "," & IF(ISBLANK([Address2]),[city]) & "," & [zipcode]
Formula 2:
Address = [Address1] & "," & IF(ISBLANK([Address2]),[city]),IF(ISBLANK([city]),[zipcode]))
Format required
Address = Address1,Address2,city,zipcode
If any these columns are (null) then it would should output something like this
Address = Address1,city,zipcode
Any help would be appreciated.
reportuser , Sorry my mistake not is missing
Address = [Address1] & IF(not(ISBLANK([Address2])), "," & [Address2] ) & IF(not(ISBLANK([city])), "," & [city] ) & IF(not(ISBLANK([zipcode])), "," & [zipcode] )
3 Replies
reportuser , try like
Address = [Address1] & IF(ISBLANK([Address2]), "," & [Address2] ) & IF(ISBLANK([city]), "," & [city] ) & IF(ISBLANK([zipcode]), "," & [zipcode] )
amitchandak- I'm sorry that did not work and you can find the output below
Address = [Address1] & "," & [Address2] & "," & [city] & "," & [zip] Output = Address1,Address2,city,zip Address = [Address1] & IF(ISBLANK([Address2]), "," & [Address2] ) & IF(ISBLANK([city]), "," & [city] ) & IF(ISBLANK([zipcode]), "," & [zipcode] ) Output = Address1reportuser , Sorry my mistake not is missing
Address = [Address1] & IF(not(ISBLANK([Address2])), "," & [Address2] ) & IF(not(ISBLANK([city])), "," & [city] ) & IF(not(ISBLANK([zipcode])), "," & [zipcode] )
