been a bit busy this afternoon so haven't looked at this any more.
I'm guessing that that particular record has one of the end fields missing so the wrong part of the address is getting into your town and country fields.
perhaps you could try a condition around the expressions for town, country and postcode,
for example
If(substringcount(Address, ',')>=5, subfield(Address, ',', -3)) as town,
If(substringcount(Address, ',')>=4, subfield(Address, ',', -2)) as country,
If(substringcount(Address, ',')>=3, subfield(Address, ',', -1)) as postcode,
Hi, thanks for helping me in your busy time also. This time it is showing values blanks under Town and County where it contains data. Please find attached and help me.
I haven't had much chance to look at this over the last day or so, but did a quick load to look at your data.
Unfortunately I think you're going to have problems here. Given the format / quality of your data I'm not sure you're going to be able to find a solution that copes with all circumstances.
I've loaded your data in, and with it used substringcount(Address, ',') to drive conditional processing for each field.
Taking, for example, the records where substringcount gives us a result of 5.
You have records where county is in position 4, and also records where town is in the same position.
Looking at the records with substringcount of 4, you have records with county in position 4, and also records where district is in the same position (e.g. Clifton).
Apologies for this not being a slightly more upbeat response, but I'm really not sure there's a complete solution here.
Thanks and no problem I understood as the data is in not in correct format order in my source that's how the problem came from. But up to now what you helped me is very much appreciated
