One could also replace the Char(13) with (CVAL('LINEND')) and the data would
retain its line-by-line appearance.
Maybe...
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Tuesday, June 26, 2012 11:51 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Paste as Plain Text?
Jason: I never considered using SRPL to replace these extended characters!
I'm going to investigate this.
Karen
In a message dated 6/26/2012 11:48:19 AM Central Daylight Time,
[email protected]<mailto:[email protected]> writes:
Karen,
You can use SKEEPI, or SRPL to clean out the unwanted characters.
SET VAR vmyvar TEXT = NULL
SET VAR vmyvar = 'Eat' + (CHAR(10)) + (CHAR(13)) + 'Donuts'
PAUSE 2 USING .vmyvar CAPTION 'BEFORE' ICON INFO
--SET VAR vmyvar = (SRPL(.vmyvar,(CHAR(10)),NULL,0))
--SET VAR vmyvar = (SRPL(.vmyvar,(CHAR(13)),NULL,0))
--SET VAR vmyvar = (SRPL(.vmyvar,((CHAR(10)) + (CHAR(13))),' ',0))
--SET VAR vmyvar = (skeepi(.vmyvar,'abcdefghijklmnopqrstuvwxyz'))
PAUSE 2 USING .vmyvar CAPTION 'AFTER' ICON INFO
CLEAR VAR vmyvar
RETURN
If you uncomment the first two SRPL lines, or just the SKEEPI line, you
will see that Eat<CR><LF>Donuts becomes EatDonuts. If you uncomment the third
SRPL line you will get Eat Donuts. You get the idea. You could use some
variation of this (adjusting the for desirable vs. undesirable characters) in
an On Exit EEP (or some other appropriate event) to clean your input.
Thanks,
Jason
