|
Text Importer - handling embedded single quotes?
|
Joined: Sep 2004
Posts: 495 Dartmouth College, Hanover, NH...
Member
|
OP
Member
Joined: Sep 2004
Posts: 495 Dartmouth College, Hanover, NH... |
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,
Stew
"That's not a bug, it's a feature?"
|
|
|
Re: Text Importer - handling embedded single quotes?
|
Joined: Oct 2002
Posts: 59 Quebec,Canada
Member
|
Member
Joined: Oct 2002
Posts: 59 Quebec,Canada |
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.
|
|
|
Re: Text Importer - handling embedded single quotes?
|
Joined: Nov 2001
Posts: 29 Columbia Univ in New York, NY ...
Member
|
Member
Joined: Nov 2001
Posts: 29 Columbia Univ in New York, NY ... |
Has this issue ever been resolved? I'm using 7.1.5... and I'm experiencing what Stew describes above.
|
|
|
Re: Text Importer - handling embedded single quotes?
|
Joined: Dec 2002
Posts: 491 Wellington, NZ
Member
|
Member
Joined: Dec 2002
Posts: 491 Wellington, NZ |
if your database is 10g or up, why not use the new quoting system?
initcap(q'{#}')
select q'{O'Mallory}' from dual
... suck in your lips and frown like a werewolf ...
|
|
|
Re: Text Importer - handling embedded single quotes?
|
Joined: Dec 2002
Posts: 491 Wellington, NZ
Member
|
Member
Joined: Dec 2002
Posts: 491 Wellington, NZ |
just so you know, the syntax highlighter, ( colours for strings, numbers etc ), does not handle this at all...
... suck in your lips and frown like a werewolf ...
|
|
|
Re: Text Importer - handling embedded single quotes?
|
Joined: Nov 2001
Posts: 29 Columbia Univ in New York, NY ...
Member
|
Member
Joined: Nov 2001
Posts: 29 Columbia Univ in New York, NY ... |
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??
|
|
|
|
|
|