How to add dots between initials?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Jeroens
Participant
Posts: 9
Joined: Wed Mar 20, 2013 8:05 am

How to add dots between initials?

Post by Jeroens »

Hi,

Does anybody know how to add dots between initials?

For instance:
JFK --> J.F.K.
P --> P.
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

QualityStage might be your best choice.
Just as important as the How is the When.
crystal_pup
Participant
Posts: 62
Joined: Thu Feb 08, 2007 6:01 am
Location: Pune

Post by crystal_pup »

Tried the below solution,it works for any string (fixed or variable).

Image
jerome_rajan
Premium Member
Premium Member
Posts: 376
Joined: Sat Jan 07, 2012 12:25 pm
Location: Piscataway

Post by jerome_rajan »

How do you differentiate between what forms the initials and what forms the first name? Or are the 'Initials' stored in a separate column?
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn

Life is really simple, but we insist on making it complicated.
Post Reply