How to get values correct in field

[#1]

Hi,

I Have address field and if there is no value in county means I have to show blank value but instead my straight table is showing postcode instead of county can anyone help me how to do this.

Address,

      subfield(Address, ',' , 1) as Address1,

      subfield(Address, ',' , 2) as Address2,

         subfield(Address, ',' , 3) as Address3,

         subfield(Address, ',' , 4) as Town,

         subfield(Address, ',' , 5) as County,

         subfield(Address, ',' , 6) as Postcode

[#2]

Any help please

[rustyfishbones]

Hi,

If PostCode is the last part of the Address you could try

SUBFIELD(Address,',', -1) AS PostCode

[#4]

Thanks and if I want to get the same for other fields also i,e if the data presents in the field then it shouid take value, otherwise it should show blank is it possible?

[rustyfishbones]

It depends on how the Address is set up at source

if each part of the Address is seperated by a comma you should get a blank value when it's blank

[#6]

Yes  the Adress is separated by comma like for eg:

3 Nora Street , , UK, NE34 0RA

is it possible to get correct please help as I am not getting idea.

[jagannalla]

Hi,

Try this,

LOAD *,

If(Country='',Null(),subfield(Address, ',' , 1)) as Address1,

If(Country='',Null(),subfield(Address, ',' , 2)) as Address2,

If(Country='',Null(),subfield(Address, ',' , 3)) as Address3;

LOAD * INLINE [

    Country, Address

    India, "SD,47,MNCL"

    ,"SD1,471,MNCL1"

];

Hope it helps you....

Cheers!!

Jagan

[rustyfishbones · Accepted solution]

Here is a file showing that it works when I add some text objects

HTH

[jagannalla]

Sorry for the misunderstanding...

[#10]

Thanks and it's working.