Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paradox for dos (removing unwanted characters) 1

Status
Not open for further replies.

paw

Technical User
Apr 7, 2000
40
0
0
US
I know where I work is part of a dying breed.&nbsp;&nbsp;People who still use Paradox 4.5.&nbsp;&nbsp;But we do and I've had to dump some data from a Microsoft Access table into a Paradox table.&nbsp;&nbsp;The problem is the Social Security Number in the Paradox table has no dashes.&nbsp;&nbsp;The Social Security Number in Access table I exported into Paradox has dashes.&nbsp;&nbsp;Is there a simple way to get rid of the dashes.<br><br>I would be most appreciative of any suggestions.<br><br>Thanks <br><br>paw
 
i'm sure you've already gotten past this problem as the question was posed a few months ago but try this in a miniscript:

scan []=xtrim([],&quot;-&quot;) endscan

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top