escape a pipeline delimiter

evergreen

• December 16, 2009 00:00

• Answered

Follow

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.

• 

  avackova

  • December 17, 2009 08:25

  0

  Comment actions Permalink

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

  evergreen

  • December 18, 2009 04:46

  0

  Comment actions Permalink

  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
• 

  avackova

  • December 18, 2009 08:41

  0

  Comment actions Permalink

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

  avackova

  • December 18, 2009 08:53

  0

  Comment actions Permalink

  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).
• 

  evergreen

  • December 18, 2009 09:57

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.