Removing SpecialCharacters

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vzmz
Participant
Posts: 36
Joined: Sun Nov 23, 2003 12:10 pm
Location: Dallas

Removing SpecialCharacters

Post by vzmz »

Hi folks,
I have a file which has specail characters. I have to remove all the specail characters and move in the info into another file.
So anyone have a clue how can i achieve this.
Thanks
VZMZ
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Typical helpful functions would be ones like EREPLACE, CHANGE and CONVERT. You can search the forums to find usage examples or go right to this one which may help you out. It seemed like a good starting point, anyways.

Just noticed you marked this as a Parallel job... this is actually a Server job answer but still should help, I hope. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You can use the functions Craig mentioned in a BASIC Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bigpoppa
Participant
Posts: 190
Joined: Fri Feb 28, 2003 11:39 am

Removing SpecialCharacters

Post by bigpoppa »

Or you can use the UNIX utility called sed. It is well documented on the web.

-BP
Post Reply