Adding a character inside field value in load script

[mattphillip]

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

[jmvilaplanap]

Hi Matt

try with yyyy/1y

Regards

[mattphillip]

Hi Jose,

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

Many thanks.

Matt

[tresesco]

One way could be like:

Load

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

[jmvilaplanap]

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

[Anil_Babu_Samineni · Accepted solution]

Or this?

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

[mattphillip]

Yes I have to so it matches legacy data.

[mattphillip]

Brilliant thanks Anil!

[Anil_Babu_Samineni]

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