Escape a pipeline delimiter

Hi,

I am reading from a source ldap.
The value of the attribute has a pipeline delimiter in the field.
When I am using the LDAPWriter to copy the data to a target. the attribute value is copied as multiple attribute values.

Here is an example
Source data:
cpip.sct |V2 |RC4 |3 |mwe5L8b|

Destination data copied when used LDAPWriter:
cpip.sct
V2
RC4
3
mwe5L8b

The data is split into multiple attributes rather than a single attribute value.
Can somebody suggest if I can escape the pipeline character to LDAPWriter.

What is your metadata? Doesn’t it have pipeline as field delimiter?

Yes my metadata has pipeline as delimiter.
That’s the reason I guess its considering it as multiple entries rather than a single entry.
I tried using semicolon as the delimiter.But the problem doesn’t get solved

Do attributes are spited still? Can you show your graph?

Hello, I see it now. It’s really bug :-(. I’ve reported it to our bug tracking system (http://bug.cloveretl.com/view.php?id=3436).

Hi avackova,

When I used the semicolon as the delimiter the attributes are not split.
I replaced the ‘|’ character with semicolon using a reformat component
See the example below
Source data:
cpip.sct |V2 |RC4 |3 |mwe5L8b|

Destination data copied when used LDAPWriter:
cpip.sct ;V2 ;RC4 ;3 ;mwe5L8b;

But this doesn’t solve our problem.I cannot store the target data with semicolon as separators.
I still need to store with ‘|’ character as the separator.