How to split column values

[#1]

Hi,

Could anyone help me how to change the script to get correct values in fields. I have one column HomeAddress in straight table and I need to split like below

HomeAddress,

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

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

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

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

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

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

After writing the above script I am getting values incorrect. please have a look on attched and help me please.

Thanks.

[tresesco]

It is more about the data format in the HomeAddress_20026 field. Please check that or load that field directly into qv and show as screen shot so that we can have a look and understand.

[#3]

Thanks and please find attached and please could you help me in modifying the script as the straight/pivot tables are showing blank values eventhough there is data in SQL table.

[Anonymous]

Amelia please show us the values in the field Home_address_20026 so we can help you