topic Re: Sperate an single field in QlikView

Sperate an single field

mario-sarkis — Wed, 02 Sep 2015 09:03:54 GMT

Hello

if have a field look like this

1|caca|as

123|asd|r

1234|ssdsd|2

i need to separeta this example

first field secondField third Field

1 caca as

123 asd| r

1234 ssdsd 2

Hope you can help thanks

Re: Sperate an single field

mario-sarkis — Wed, 02 Sep 2015 09:05:13 GMT

or it is enough to extract the first field and rest still concatenate

Thanks

Re: Sperate an single field

arulsettu — Wed, 02 Sep 2015 09:09:04 GMT

try this

SubField('1|caca|as','|',1) as field1,

SubField('1|caca|as','|',2) as field2

SubField('1|caca|as','|',3) as field3

Re: Sperate an single field

sasiparupudi1 — Wed, 02 Sep 2015 09:09:34 GMT

SubField('1|caca|as','|',1) as Firstfield

SubField('1|caca|as','|',2) as Secondfield

SubField('1|caca|as','|',3) as Thirdfield

Re: Sperate an single field

Kushal_Chawda — Wed, 02 Sep 2015 09:13:13 GMT

SubField(YourField,'|'1) as field1,

SubField(YourField,'|',2) as field2

SubField(YourField,'|',3) as field3

Re: Sperate an single field

mario-sarkis — Wed, 02 Sep 2015 09:42:12 GMT

hi KUSH

if my fied looks exactly like this :

42216|Services|Dial Up Internet

42216|Services|Domiciliations

42216|Services|Pin Pay

42216|Services|Safe Box

42216|Services|Sweep

42248|Accounts|403

42248|Accounts|421

42248|Accounts|427

42248|Accounts|461

42248|Accounts|462

I don't want to seperate but only want to replace '42248' by '42247'

Hope you can help

Re: Sperate an single field

sasiparupudi1 — Wed, 02 Sep 2015 09:52:20 GMT

something like this?

if( substringCount(YourField,'|')>1 and SubField(YourField,'|',1)=42248,replace(YourField,4248,4247),YourField))

Re: Sperate an single field

Kushal_Chawda — Wed, 02 Sep 2015 10:15:53 GMT

You can do something like this

if(SubField(Field,'|' ,1)='42248', Replace(Field,SubField(Field,'|' ,1),'42247'),Field) as Field1

But where you want to show this value ? In Field 1 or Filed 2 or field3?

Re: Sperate an single field

qlikmsg4u — Wed, 02 Sep 2015 10:18:41 GMT

Load *,Replace(Test,42248|,42247|) as Test1;

Load * Inline [

Test

42216|Services|Dial Up Internet

42216|Services|Domiciliations

42216|Services|Pin Pay

42216|Services|Safe Box

42216|Services|Sweep

42248|Accounts|403

42248|Accounts|421

42248|Accounts|427

42248|Accounts|461

42248|Accounts|462

];