lastname,firstname

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

lastname,firstname

Post by arnie_nits »

Hi ,

How would I change lastname,firstname to firstname.lastname
Please suggest.

regards,
Arnie.
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Code: Select all

Field(yourFieldName,',', 2) : '.' : Field(yourFieldName,',', 1)
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Assuming lastname,firstname comes as a single field in your source. If not then let us know

Code: Select all

Field(name,",",2) : '.' : Field(name,",",1)
You are the creator of your destiny - Swami Vivekananda
arnie_nits
Participant
Posts: 101
Joined: Mon Aug 13, 2007 2:32 am

Post by arnie_nits »

Thanks..it works
arvind_ds
Participant
Posts: 428
Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali

Post by arvind_ds »

Please mark the topic as closed.
Arvind
Post Reply