Quote char handling

mrvsr · Post by **mrvsr** » Fri Apr 11, 2008 1:00 pm

Hi,

How can assign 'rama's' to a variable in transformation derivation. I tried 'rams\'s' etc.,

Thanks

kumar_s · Post by **kumar_s** » Fri Apr 11, 2008 1:04 pm

Try giving "rama's"

mrvsr · Post by **mrvsr** » Fri Apr 11, 2008 1:58 pm

I have both quotes ' " in the value sting. ex: ' "&fieldname#1"="rama's" ' Please let me know how to handle these quotes and special characters.

sud · Post by **sud** » Fri Apr 11, 2008 2:03 pm

Simple assignment should not be a problem. You can create stage variables as sQuote = "'" and dQuote = '"' and use them to concatenate wherever necessary.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 11, 2008 4:47 pm

Backslash may also work as a quote character. It does in server jobs. Try it and let us know.

Code: Select all

\"&fieldname#1"="rama's"\

DSXchange

Quote char handling

Quote char handling

Handling quotes and special characters

Re: Handling quotes and special characters