Transformer Stage using Stripwhitespaces Function

Stripwhitespaces is the function used for the remove before,after and middle of the characters. 

Some times we get the data as below 

e_id,e_name 
10,em y 
20, j ul y 
30,re v o l 
40,w a go n 


Take Job Design as 

Se.File ------ Tx------D.s 


Read and load the data in Sequential file stage 

Go to Transformer stage 

Here, we use stripwhitespaces function in the required column derivation. 

You can write expression as below 

Stripwhitespaces(e_name) for e_name 


Click ok 

Compile and Run the data 


You will get the data after removal of all the spaces between the characters, 

before and after spaces also.