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

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.

Read more about Transformer Stage with example