Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mario-sarkis
Contributor II

Script

hi

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 anyone can help

2 Replies
qlikmsg4u
Valued Contributor

Re: Script

Try this

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

];

Re: Script

Or this to give extra safety:

Table:

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

];