Tuesday, March 04, 2008

Can we handle a new line character in a field in the source row in Informatica?

Can we handle a new line character in a field in the source row?

A field in the source can be in two lines?

Source_field1 = 'abc'
source_field2 = 'bcd
cde'
Source_field3 = 'def'

This should be taken into the target as
target_field2 = 'bcd
cde'

Is this possible?

I cannot simply replace the chr(10). In that case, the end of line
would also not be recognized.

No comments: