DSXchange

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"

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

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