topic Re: How to split an address block into two fields in QlikView

How to split an address block into two fields

Anonymous — Sun, 02 Dec 2018 23:47:11 GMT

I am importing data from a software that stores Address Lines as a "block" separated by a new line, rather than as separate fields. How can I separate the address lines into separate fields when I don't have a comma as a delimiter?

Currently, when I import the "AddressBlock" field into QV, I only see the top line of the address line displayed, but if I export it into excel, I can see both lines displayed in a single cell, but on two separate lines just as they appear in the original software.

Re: How to split an address block into two fields

PradeepReddy — Mon, 03 Dec 2018 01:58:55 GMT

try something like this...

Load *,
subfield(AddressBlock,chr(10),1) as Adr_Block,
subfield(AddressBlock,chr(10),2) as Adr_Line1
From Table1;

Change the subfield positions (1,2) according to your data format.

Re: How to split an address block into two fields

MarcoWedel — Mon, 03 Dec 2018 22:43:16 GMT

please post some sample data and your expected result

thanks

Marco