How to process data within SQL*Loader?
From: Teddy Winstead <winstead_at_cs.tulane.edu>
Date: 1995/06/22
Message-ID: <3sc87u$e6a_at_rs10.tcs.tulane.edu>#1/1
Date: 1995/06/22
Message-ID: <3sc87u$e6a_at_rs10.tcs.tulane.edu>#1/1
I'm trying to read in a flat file with SQL*Loader. I'd like to strip
the "-" characters out of the social security numbers in the text file.
In other words, I want to go from "111-22-3333" to "111223333".
Is there an easy way to do this?
--
Nathaniel Scott "Teddy" Winstead | http://www.cs.tulane.edu/www/Winstead
winstead_at_cs.tulane.edu (Preferred) | WARNING! -- The views expressed are
winstead%brauerei.uucp_at_cs.tulane.edu | those of a platypus and are not
Fanatical Homebrewer & CS Student | necessarily my own.
Received on Thu Jun 22 1995 - 00:00:00 CEST