Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
kp2
Contributor II
Contributor II

Purge Spaces & Capitalize the Values in the Load Script

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 

1 Solution

Accepted Solutions
justISO
Specialist
Specialist

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

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

View solution in original post

2 Replies
justISO
Specialist
Specialist

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

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

kp2
Contributor II
Contributor II
Author

That's perfect, thanks very much!