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
How to print a single quote(') in a transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
sun