How to print a single quote(') in a transformer

suneyes · Post by **suneyes** » Tue Sep 16, 2008 12:24 am

Hi,
I have a requirement to append a single quote(') to a column in datastage.
As quotes are used to enclose string values it is not letting me to print this charecter.
can any one help me with this?

example:
if the input is 123456
I want the output as '123456

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2008 12:56 am

Assuming that the data type of the outbound column is string, and that you're doing this in a Transformer stage, then a suitable expression is

Code: Select all

"'" : InLink.TheColumn

suneyes · Post by **suneyes** » Tue Sep 16, 2008 2:29 am

ray.wurlod wrote:Assuming that the data type of the outbound column is string, and that you're doing this in a Transformer stage, then a suitable expression is
Code: Select all
"'" : InLink.TheColumn
...

Thanks ray.That helped me in solving my problem.