HP3000-L Archives

August 2006, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: QUIZ - REPLACE?
From:
Roger Marcinik <[log in to unmask]>
Reply To:
Roger Marcinik <[log in to unmask]>
Date:
Wed, 23 Aug 2006 15:44:05 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (31 lines) 
Here are a couple of suggestions from the PowerHouse list for the similar 
need to replace semicolons:

1)

Date: Wed, 5 Jan 2005 13:46:03 -0500
Subject: Character replace in Quiz

 
Use MPE system functions to do it for you...
 
In your quiz...
 
define D-REPLACE char*50 = '![repl("' + NAME + '",";"," ")]'
define D-NAME char*30 = getsystemval("D_REPL") if
setsystemval("D_REPL",D-REPLACE)

Where NAME is your source field and D-NAME is the result.

2)
There's also the simple approach of index and substrings, which 
is pretty tedious, but possible if you think you can get away with 
assuming less than 5 or 6 semicolons or so.

I myself used the index feature to find commas and replace them.
First, you have to know max number of commas in the field to know how many 
DEFINE statements to use.  Else you make as many runs as needed.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2