topic Re: Replace field value? in QlikView

Replace field value?

Akina0929 — Tue, 23 May 2017 10:10:12 GMT

HI,

I have a field it,s like as shown in image, I want to Replace marked values into ABC .please help me how can i achieve.

Re: Replace field value?

qlikview979 — Tue, 23 May 2017 10:15:53 GMT

Use this

Replace(Value,'555','ABC') as check

Re: Replace field value?

qlikview979 — Tue, 23 May 2017 10:19:12 GMT

Hi,

T1:

LOAD * Inline [

Value

001-0525-04-555-121

001-0525-02-555-121

001-0525-01-555-121

001-0525-04-555-121

001-0525-02-555-121

001-0525-01-555-121

];

NoConcatenate

T2:

LOAD

RecNo() as Rec,

Replace(Value,'555','ABC') as check

Resident T1;

DROP Table T1;

Result:

Re: Replace field value?

Akina0929 — Tue, 23 May 2017 10:26:46 GMT

HI Mahesh,

if i want replace 3rd position what can i do

Re: Replace field value?

qlikview979 — Tue, 23 May 2017 10:31:45 GMT

Use this

Replace(Value,(SubField(Value,'-',3)),'XYZ') as check1

it will give 3rd position

XYZ

Re: Replace field value?

Akina0929 — Tue, 23 May 2017 10:37:59 GMT

Thank you very much Mahesh,

Re: Replace field value?

Frank_Hartmann — Tue, 23 May 2017 10:38:56 GMT

what happens if your value field looks like:

555-0555-04-555-121 ???

you should try like this:

LOAD * Inline [

Value

001-0525-04-555-121

001-0525-02-555-121

001-0525-01-555-121

001-0555-04-555-121

555-0555-04-555-121

];

NoConcatenate

LOAD

subfield(Value,'-',1)&'-'&subfield(Value,'-',2)&'-'&subfield(Value,'-',3)&'-'&Replace(subfield(Value,'-',4),'555','ABC')&'-'&subfield(Value,'-',5) as newValue

Resident 1; DROP Table 1;