Addition of two values within the same field

[LovelyPints]

Hey,

I have a field that contains an integer value for the majority of the column. However some of the values have a space in the middle, so two values and only ever two values at most. Instead of removing the space I would like to add the two numbers separated by a space within the same field together.

I know it would look something like..

If(Row contains ' '), Take left value, take right value, add together, else no space, carry over whole number to new column

Is this even possible in Qlik ?

Thanks!

[stevejoyce · Accepted solution]

i'm thinking replace spaces with '+' and use evaluate:

in load script:

evaluate(replace([your field], ' ', '+')) as [your New field]