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,
Inserting Special Characters
Moderators: chulett, rschirm, roy
Re: Inserting Special Characters
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.
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.