Concatenate issue

[Anee]

Hi

Cud anyone tell me wats wrong with the below stmt... I've used this stmt to concatenate a " to the rec if it contains QuoteChar. but the output returned is that every stmt is appended with a 1 at the end.....

if(DSLink12.F1[1,9]= "QUOTECHAR") THEN DSLink12.F1 :'"' else DSLink12.F2..

thanx
Anee

[kcbland]

I can't tell but a I am assuming you are using a single quote, a double quote, and then a single quote in the statement. What your statement is doing is if the first nine characters of link column DSLink12.F1 is the text "QUOTECHAR" then append your quote to that entire link column value, otherwise return link column DSLink12.F2. So, my guess is that either your text never starts with QUOTECHAR and F2 must contain the value 1.

[kumar_s]

Hope you are not getting confused with the new line character seen through a special text editior.

[ray.wurlod]

Does the upper case string "QUOTECHAR" ever appear in the first nine positions of F1? And what's the value of F2?

[Anee]

Hi

QUOTECHAR does appear in the firstnine postions of F1. and F2 value of this rec is null
Inspite of this, 1 is appended at the end to all the values

Thanx

[changming]

what is stmt anyway?
try to cat in this way
link.field :''':'''

[Anee]

Hi changming

It still doesnt work. Infact i doubt the stmt u wanted me to add in the transformer stage is correct.. is it possible to concatenate the way u told???

[changming]

Hi changming

It still doesnt work. Infact i doubt the stmt u wanted me to add in the transformer stage is correct.. is it possible to concatenate the way u told???

sorry, I tried, that is wrong. sorry for misleading you. Check your file whether it is writen by other link.

[kumar_s]

Hi Anee, Where do you see the '1'. Is it in view data or in output flat file?
What if you concatinate with other character?
Are you trying with any stage variable?

[ray.wurlod]

Hi

Cud anyone tell me wats wrong with the below stmt... I've used this stmt to concatenate a " to the rec if it contains QuoteChar. but the output returned is that every stmt is appended with a 1 at the end.....

if(DSLink12.F1[1,9]= "QUOTECHAR") THEN DSLink12.F1 :'"' else DSLink12.F2..

thanx
Anee

Is that the entire expression? (What does the ".." at the end signify?)

If it is the entire expression, try

Code: Select all

If (DSLink12.F1[1,9] = "QUOTECHAR") THEN DSLink12.F1 : Char(34) else  DSLink12.F2

Here I've replaced the quoted quote character with Char(34) - it would be more efficient to initialize a stage variable with Char(34) and to use the stage variable (perhaps named svDoubleQuoteChar), but it gets the idea across.

I remain curious to learn where the 1 actually occurs.