topic Re: Adding a character inside field value in load script in QlikView

Adding a character inside field value in load script

mattphillip — Wed, 25 Nov 2020 16:16:04 GMT

Hoping someone can help. I've got a session field with values formatted as yyyy/y (e.g. 2016/7, 2017/8). However, I'm trying to find a way to amend the field values by adding a 1 at character position 6 to present the values as 2016/17, 2017/18 etc. Does anyone have any idea whether this is possible? I've seen examples where a character has been added to the beginning or the end but never inside the string itself.

Any help would be most appreciated.

Yours,

Matt

Re: Adding a character inside field value in load script

jmvilaplanap — Fri, 18 Aug 2017 10:45:38 GMT

Hi Matt

try with yyyy/1y

Regards

Re: Adding a character inside field value in load script

mattphillip — Fri, 18 Aug 2017 10:47:42 GMT

Hi Jose,

Thank you. Could you illustrate how to do this within the load script?

Many thanks.

Matt

Re: Adding a character inside field value in load script

tresB — Fri, 18 Aug 2017 10:52:04 GMT

One way could be like:

Load

Replace(YourField, '/','/1') as NewField

Re: Adding a character inside field value in load script

jmvilaplanap — Fri, 18 Aug 2017 10:52:06 GMT

Is the same, if the value is a date, then

date(DateField, 'yyyy/1y') As newField

But sincerly I don't understand why you need this format, you are writing the year '/' the number one and the last digit of the year. Are you sure do you want this?

Regards

Re: Adding a character inside field value in load script

Anil_Babu_Samineni — Fri, 18 Aug 2017 11:02:23 GMT

Or this?

SubField(YourField, '/',1) & '/1' &SubField(YourField, '/', -1)

Re: Adding a character inside field value in load script

mattphillip — Fri, 18 Aug 2017 11:06:46 GMT

Yes I have to so it matches legacy data.

Re: Adding a character inside field value in load script

mattphillip — Fri, 18 Aug 2017 11:10:04 GMT

Brilliant thanks Anil!

Re: Adding a character inside field value in load script

Anil_Babu_Samineni — Fri, 18 Aug 2017 11:15:41 GMT

Even, I don't prefer this? Because, What if you have data 2016/11, 2017/12 ???