Problem using Convert in Transformer

[kittu.raja]

HI,

I have a job which looks like

seqfile -----> transformer ---------> seqfile

The requirement is if the data is "]]CDATA]" then they have to change it to
"![CDATA[". when I tried to use convert I am getting "!!CDATA!". can anybody help me out.

Thanks,

**Note - Subject changed to be more descriptive - Content Editor**

[betterthanever]

convert function does not work the way you are understanding...

it does not look for a string and replace it with the string you give...

but looks for the character by character
meaning for ex:

if you say convert('ab','cd',link.col)..
it replaces 'a' with 'c' and 'b' with 'd'...

[kittu.raja]

[quote="betterthanever"]convert function does not work the way you are understanding...


Can you tell me how can I achive my target data?

[betterthanever]

search the forum...you will get lot of info on this

[kittu.raja]

search the forum...you will get lot of info on this

I searched the form by replace a string, but I did not get the right one.

[betterthanever]

[quote="kittu.raja"][quote="betterthanever"]search the forum...you will get lot of info on this[/quote]

I searched the form by replace a string, but I did not get the right one.[/quote]

check this

http://dsxchange.com/viewtopic.php?t=10 ... f69dc268a1

[ray.wurlod]

You need something more complex, though a Convert() function is certainly involved. First you need a conditional expression, because the data won't always be "]]CDATA]". Then, assuming that this is the entire contents (rather than partial), you need to replace the first character with "!" and convert the remaining "]" characters to "[".

Hence

Code: Select all

If InLink.TheField = "]]CDATA]" Then "!" : Convert("]", "[", InLink.TheField[2, Len(InLink.TheField) - 1] Else InLink.TheField

[mk_ds09]

Can you give more details about your requirements ?

Is everytime data is coming like '"]]CDATA]"' and you have to convert it to the "![CDATA[" ?

Or it is only the first occurance of the ] needs to be converted to the !.

Then you can just use convert on the rest of the string using convert and use concatanation for the first charater....

[ray.wurlod]

If you had premium membership you would be able to read the complete solution in my earlier post.

[kittu.raja]

If you had premium membership you would be able to read the complete solution in my earlier post.

K right now I am buying the premium membership

[kittu.raja]

Can you give more details about your requirements ?

Is everytime data is coming like '"]]CDATA]"' and you have to convert it to the "![CDATA[" ?

Or it is only the first occurance of the ] needs to be converted to the !.

Then you can just use convert on the rest of the string using convert and use concatanation for the first charater....

Everytime I have to convert it and convert is not working on string replace

[kittu.raja]

If you had premium membership you would be able to read the complete solution in my earlier post.

I bought the premium membership, but its still showing me premium content. Can you help me out.

[ray.wurlod]

No, only the membership director can. You are not yet showing up as a premium member.

[kittu.raja]

No, only the membership director can. You are not yet showing up as a premium member. ...

I bought the membership today and shipping is downloadable. I did not get any downloadbale file and still its showing me participant

[kittu.raja]

You need something more complex, though a Convert() function is certainly involved. First you need a conditional expression, because the data won't always be "]]CDATA]". Then, assuming that this is ...

the data is not just "] CDATA". it contains a big staement in which CDATA is part of it. So I cannot use If then Else.