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


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

Original text of this message