TRANSFORMER STAGE USING STRIPWHITESPACES FUNCTION

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.