Re: Removing Characters from a Field

[Pete Hall <peteh@xxxxxxxxxx>]

At 10:58 AM 3/27/98 -0600, Scott Swaim wrote: 
>
>     I need to write a program that will remove certain punctuation from a
> field.
>  
>  
> eg.   GFN 3 IC-656              This info is in a field that is 30 char long.
>  
>          GFN3IC656                 I want to extract only this information to
> another field.
>  
> What boudl be the best solution?  The characters that I want to remove are
> mainly these.    /?-.,and the space


Scott,

You could use the xlate operation to convert the target characters to a single
value that will never appear in the field, like maybe x'01'. After that though,
your going to need to write a loop that parses the segments between the
separator characters and concatenates them in the result field.

hth
Pete

Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---