topic Replace in load script in QlikView

Replace in load script

ecabanas — Mon, 17 Oct 2016 09:53:48 GMT

Hi I have an excel table like this:

External ID

FV00306466

FV00306300

FV100306418

FV20306474

FV30306432

FV30306316

I would like to import to QV and replace:

1º When it's FV0 replace to PV0

2º If is FV1 till FV9 replace to PR1....PR9

Is it possible?

Many thank's

Eduard

sunny_talwar — Mon, 17 Oct 2016 09:56:30 GMT

So, are you trying to change the first two letter from FV to PR? May be this:

LOAD Replace([External ID], 'FV', 'PR') as [External ID],

ecabanas — Mon, 17 Oct 2016 10:02:58 GMT

Hi Sunny again!!

it's correct but not exactly, if begins FV0 has to be PV0 but if it begins with FV1 till FV9 has to be PR1 till PR9

rubenmarin — Mon, 17 Oct 2016 10:03:54 GMT

Hi, there is a character difference, maybe with:

If(Left([External ID], 3)='FV0',

Replace([External ID], 'FV', 'PV'),

Replace([External ID], 'FV', 'PR') as [External ID]

sunny_talwar — Mon, 17 Oct 2016 10:06:19 GMT

Hahahaha okay, may be this

Replace(Replace([External ID], 'FV0', 'PV0'), 'FV', 'PR') as [External ID],