Adding dots to a column with initials

dataservices job design
1

I have column with initials in it, for example TS, and Iā€™d like to have dots added to the initials (the previous example would turn out T.S.). Does anyone have any thoughts on how best/easiest to achieve this? Thanks in advance.

wahey :netherlands: (BOB member since 2007-05-31)

2

This will work as long as there are only 2 initials in the incoming data.

substr( Query.INITIALS,1,1) || ā€˜.ā€™ || substr( Query.INITIALS,2,1) || ā€˜.ā€™

djordan :ireland: (BOB member since 2006-03-01)

3

Combined it with a decode() to allow for up to five initials and it worked like a charm. Thanks.

wahey :netherlands: (BOB member since 2007-05-31)

4

Throw it into a loop, driven by length of the string and using an int variable that you raise each loop to substring through the text and you ready to handle anything that comes through. :slight_smile:

ErikR :new_zealand: (BOB member since 2007-01-10)