Purge Spaces & Capitalize the Values in the Load Script

[kp2]

Hello everyone, 

I'm trying to load some data and would like to have all String values capitalized and have all spaces removed so it follows the below style 

'BT123AB' 

I'm currently able to remove the spaces using the following 

purgechar(answer,chr(32)) as [sp.answer]

How would I then capitalise the values 

Any help would be much appreciated 

[justISO · Accepted solution]

Hi, upper() function make all letters CAP. Also yu can replace 'space' with nothing too:

upper(replace(answer, ' ', '')) as [sp.answer]

[kp2]

That's perfect, thanks very much!