Transformer Stage using CompactWhiteSpaces

Compact white spaces is the function used in the Transformer Stage function. It will reduce the spaces to the single spaces. 

If we have a data as below 

e_id,e_name 
11,ja mes 
22,lea na 
33,lacky 
44,to m 
55,ve nu 
66,emy 
77,t iny 

Take Job design as 

Seq.File——Tx—-d.S 

Read and load the data in Sequential file 

In Transformer Stage — Drag and Drop the records to the output file and create 

one column as new_names. In derivation,write expression as below 

compactwhitespaces(e_name) and click ok 

Give file name to the target file and 

compile and run the job to get the required output. 

Leave a Reply

Your email address will not be published. Required fields are marked *