How to get correct values

[#1]

Hi,

I have a straight table with fields as below

Address1= =SUBFIELD(Home_Address_20026,',',1)

Address2=  =If(Address2<>Postcode,SUBFIELD(Home_Address_20026,',',2))

Address3=  =If(Address3<>Postcode,SUBFIELD(Home_Address_20026,',',3))

Town=  =If(Town<>Postcode,SUBFIELD(Home_Address_20026,',',4))

County= =If(County<>Postcode,SUBFIELD(Home_Address_20026,',',5))

PostCode=  =Subfield(Home_Address_20026,',',-1)

Here Home_Address_20026 is the column from sql table.

When I am using above in expressions it is showing values incorrect order. I,e under address3 it is showing Town values and under County it is showing Adrress2 values and so on.

Please could anyone help me how to set this to get correct order values.

Thanks.

[nilesh_gangurde]

Hi,

Please attach the sample qvw file.

-Nilesh

[preminqlik]

provide sample data fields

[Anonymous]

This could be as you are using ',' as your delimiter,

so There might be a ',' in address3 field also, due to which wrong values are reflected.

Please post some sample data , which would help me to check the issue.

Regard

Nitin

[#5]

Please find attached.

[#6]

Please find attached.

[#7]

You have inconsistancy in the number of delimiters ',' in your address field B. they have to be correct, before you can use this method.

[#8]

Thanks and there is no possibility for me to change the onconsistancy as it is the field values in SQL table which I don't have write access.

[nilesh_gangurde]

Hope this will help you

-Nilesh

[#10]

Hi,

When I am try to opening the document it is showing "Failed to Load"

I am not able to open the document please help