LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (December 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 13 Dec 2002 17:15:31 -0500
Reply-To:   Nathaniel_Wooding@DOM.COM
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Nathaniel Wooding <Nathaniel_Wooding@DOM.COM>
Subject:   Re: Translate question
Comments:   To: Crystal Vierhout <vierhout@UNITY.NCSU.EDU>
Content-type:   text/plain; charset=us-ascii

Crystal

Assuming that you do want to keep all of the hyphens in the name , try the following which uses the scan function.

Nat Wooding

data crystal; name='DHI-523-Somatic-Cell-Graphs.pdf'; shortname=scan(name,1,'.'); put name=/shortname=; run;

Crystal Vierhout To: SAS-L@LISTSERV.UGA.EDU <vierhout@UNITY cc: .NCSU.EDU> Subject: Translate question Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV .UGA.EDU>

12/13/02 05:06 PM Please respond to Crystal Vierhout

Hello,

I have a relatively simple questions this time.

I have around a thousand of these some If-then doesn't seem very practical.

I have: DHI-523-Somatic-Cell-Graphs.pdf

I need: DHI-523 Somatic Cell Graphs

Does anyone have an idea?

When I use translate to take off the ".pdf" it will talk all the p's, d's. and f's out of the string.

Crystal


Back to: Top of message | Previous page | Main SAS-L page