Text Importer - handling embedded single quotes?

[Stew Stryker]

Slap me if I missed this feature, but I'm trying to import from a text file that includes apostrophe's in people's name (e.g. O'Mallory). The text importer seems to handle those okay, unless I also want to put the name in a SQL function.

In my case, the names sometimes come in all lowercase and I want to use: initcap('#').

Did I miss something or do I need to do an UPDATE after importing via Text Importer to achive this?

Thanks,

 

[DLGL]

I have exactly the same problem in a address field where I have to do a call to Oracle upper function. It would be very nice if you could change the way of calling functions to handle quotes "'". For now I will create a before insert trigger on the target table.

By the way, text importer saves me a lot of time.

Regards.

 

[kamrath]

Has this issue ever been resolved? I'm using 7.1.5... and I'm experiencing what Stew describes above.

 

[rbrooker]

if your database is 10g or up, why not use the new quoting system?

initcap(q'{#}')

select q'{O'Mallory}' from dual

 

[rbrooker]

just so you know, the syntax highlighter, ( colours for strings, numbers etc ), does not handle this at all...

 

[kamrath]

Thanks very much for that, rbrooker. The db on which I'm doing this import is 9.2... however, I do have an Ora 10 db available, and will try it on that one.

BTW... Marco, are you listening?... along with code "beautification", I agree that syntax highlighting needs to be brought up-to-date. Could you PLEASE, PLEASE work on this for ver 8??