[RBASE-L] - Re: Paste as Plain Text?

[Jason Kramer]

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 Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) On 6/26/2012 12:31 PM, karentel...@cs.com wrote: Oh yeah, Dennis, we know that.  There's definitely embedded carriage returns in there.    So do you know a "paste as text" option we could use? Karen In a message dated 6/26/2012 10:31:01 AM Central Daylight Time, dmcgr...@qmiusa.com writes: Karen, What is probably happening is the pasted data contains linefeeds or carriage returns.