include double quote in transformer stage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
agathaeleanor
Participant
Posts: 76
Joined: Mon Mar 05, 2007 9:26 pm
Location: Malaysia

include double quote in transformer stage

Post by agathaeleanor »

Hi there,

Understand that double quote is a special character.
May i know how to embed a double quote to a column?

eg. transformer read in columns from sequential file.
In one of the column i would like to concatenate double quote as "column1"

Thanks for the help
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No problem. Just encase the double-quote constant in single quotes (you'll have to type this in manually) and concatenate.

Code: Select all

'"' : InLink.TheString : '"'
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
agathaeleanor
Participant
Posts: 76
Joined: Mon Mar 05, 2007 9:26 pm
Location: Malaysia

Post by agathaeleanor »

Thank you very much :)
Post Reply