Example Address :
17,5-14-17 Jalan Batu 3, Kampung Batu, Timur Laut, 11700, Pulau Pinang
i need saparate to :
Address : 17, 5-14-17 Jalan Batu 3, Kampung Batu
Postcode : 11700
City : Timur Laut
State : Pulau Pinang
how?
Hi @tuanpakya
Does this format consistently follow the structure of first three elements being the address, followed by the city, and then the postcode? If so, please consider utilizing the split function to process it.
Address : {{join(slice(split(“17,5-14-17 Jalan Batu 3, Kampung Batu, Timur Laut, 11700, Pulau Pinang”); 0; 3); “,”)}}
Postcode : {{get(split(“17,5-14-17 Jalan Batu 3, Kampung Batu, Timur Laut, 11700, Pulau Pinang”); 5)}}
City : {{get(split(“17,5-14-17 Jalan Batu 3, Kampung Batu, Timur Laut, 11700, Pulau Pinang”); 4)}}
State : {{get(split(“17,5-14-17 Jalan Batu 3, Kampung Batu, Timur Laut, 11700, Pulau Pinang”); 6)}}
Input:
Output:
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel
4 Likes