concatenation

new_ds_man · Post by **new_ds_man** » Wed Dec 02, 2009 9:07 am

Hi All,

I have a requirement to insert a special character (ex: +) into a description column.

Example:

Source value : "klhsdpjgljhsljkdgljh"

I need to insert a '+' after every 5 characters

the O/P should be "klhsd + pjglj + hsljk + dgljh"

chulett · Post by **chulett** » Wed Dec 02, 2009 9:15 am

What have you tried? Substringing every five characters and concatenating your 'special character' between the pieces?

new_ds_man · Post by **new_ds_man** » Wed Dec 02, 2009 12:23 pm

We went with a different alternative, fixed the data before we receive in ETL.