Trim space in between to words in transformer

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
arnie_nits
Participant
Posts: 101
Joined: Mon Aug 13, 2007 2:32 am

Trim space in between to words in transformer

Post by arnie_nits »

Hi,

I have a name like 'John Watson'. Now I want it like 'JohnWatson'.
Please tell me how to do this in transformer.

Regards,
Arnie
Top
meet_deb85
Premium Member
Premium Member
Posts: 132
Joined: Tue Sep 04, 2007 11:38 am
Location: NOIDA

Post by meet_deb85 »

use this trim("string"," ","A")
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Code: Select all

Convert(" ", "", InLink.TheName)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”