Problem with # symbol in transformer stage

datastage_slk · Post by **datastage_slk** » Thu Feb 05, 2009 1:34 pm

When I concatenate all the fields in a transformer to send it to funnel. I am using one of the field from job parameters. That field has # symbol in it.

It throws an error if that field has # symbol.

any solution for this is really appreciated.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 05, 2009 4:29 pm

Can you be more specific about where this "#" character appears? If it's in the data it should not be causing a problem. But if it's in a property field in the Transformer stage then it's understood to be part of a job parameter reference.

datastage_slk · Post by **datastage_slk** » Thu Feb 05, 2009 6:03 pm

[quote="datastage_slk"]When I concatenate all the fields in a transformer to send it to funnel. I am using one of the field from job parameters. That field has # symbol in it.

It throws an error if that field has # symbol.

any solution for this is really appreciated.

I have to concatenate different fields in transformer. While doing so, one of the fields has # in its value. example is "group #122"

If I remove # symbol, it works fine. but how do I show this in report.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 05, 2009 7:34 pm

If that's really in the value, and the data type is Char or VarChar, then you have uncovered a bug and must report it to your support provider.

In the meantime, and as a workaround, convert the "#" to some other character that does not occur in your data (maybe Char(1)), perform the concatenation then convert back.

richdhan · Post by **richdhan** » Thu Feb 12, 2009 5:01 am

Hi,

Did you use the GUI to insert the job parameter.

The job parameters are not marked with # in transformer.

Dont use the hand coding. Rather use the GUI.

HTH
--Rich

DSXchange

Problem with # symbol in transformer stage

Problem with # symbol in transformer stage

Re: Problem with # sybmol in transformer stage