DSXchange

we are recieving sequnetial files from source system which are delimited by pipe.
for one of the column called NAME is having characters with single quotes.
like
O'Brien.

When inserting into oracle table through OCI stage load is aborted sue to single quotes in the name.

Can you please help handling this problem

thanks,

Hi
try doubling up on the ' character.
you can use any convert function in transformer stage.

Eg: Say you want to insert this : Oh 'joy'
you need to insert the value as 'Oh ''joy'''

You can test this with a sample Insert statement.

what is the datatype for column NAME?
when you do a view data on the input file... does it display the ' correctly?

what is the exact error message that you get?