Marc,
You could, in earlier code, set defaults for the variables like himher, in
case they happen to be null.
IF himher IS NULL THEN
SET VAR himher = ('him or her')
ENDIF
Or you could put a similar default into your expression:
SET VAR vtext3 = (SRPL(.vtext2,'[himher]', (ifnull(.himher,'him or
her',.himher)),1)
Or you could modify the value of vtext3, depending on what your final
paragraph should be like
IF himher IS NULL THEN
SET VAR vtext3 = .vtext2
ENDIF
I'm surprised you are using "1" as the final parameter for SRPL. Are you
confident that you'll never have more than one occurrence of either personal
pronoun placeholder? Zero would get all occurrences.
Bill
On Mon, Jan 12, 2009 at 12:48 PM, MDRD <[email protected]> wrote:
> Thanks All
>
> Good advice, but I hit a snag.
>
> I had to change the code to this and it seems if .himher is Null then
> vtext3 is null too.
>
> SET VAR vtext = (SRPL(.vxtext,'[fname]',.vfname,1)
> SET VAR vtext2 = (SRPL(.vtext,'[heshe]',.heshe,1)
> SET VAR vtext3 = (SRPL(.vtext2,'[himher]',.himher,1)
> SET VAR vtext4 = (SRPL(.vtext3,'[xx1]',.vxxmpt1,1)
> SET VAR vtext5 = (SRPL(.vtext4,'[xx2]',.vxxmpt2,1)
>
> Marc
>
>
> ----- Original Message ----- From: "Dennis McGrath" <[email protected]>
> To: "RBASE-L Mailing List" <[email protected]>
> Sent: Monday, January 12, 2009 10:05 AM
>
> Subject: [RBASE-L] - RE: SRPL limit?
>
>
> That is the way I would do it.
> It is far easier to read and debug.
>
> Dennis McGrath
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Stephen
> Markson
> Sent: Monday, January 12, 2009 9:54 AM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - RE: SRPL limit?
>
> Like Karen, I think you don't need to string them together. Won't the
> following work?:
>
> SET VAR vtext = (SRPL(.vxtext,'[fname]',.vfname,1)
> SET VAR vtext = (SRPL(.vxtext,'[heshe]',.heshe,1)
> SET VAR vtext = (SRPL(.vxtext,'[himher]',.himher,1)
> SET VAR vtext = (SRPL(.vxtext,'[xx1]',.vxxmpt1,1)
> SET VAR vtext = (SRPL(.vxtext,'[xx2]',.vxxmpt2,1)
>
> Regards,
>
> Stephen Markson
> ForenSys The Forensic Systems Group
> www.ForenSys.ca
> 416 512 6950
>
> ________________________________________
> From: [email protected] [mailto:[email protected]] On Behalf Of MDRD
> Sent: January 12, 2009 10:22 AM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - SRPL limit?
>
> Hi
>
> I am building form letters and need to do about 20 SRPL's. Is there
> a better way or do I string 20 SRPL's together?
> The example only has 5 SRPL's
>
> SET VAR vtext = (SRPL((SRPL((SRPL((SRPL((SRPL (.vxtext,
> '[fname]',.vfname,1)), '[heshe]', .heshe,1)),'[himher]', .himher, 1)), +
> '[xx1]', .vxxmpt1,1)), '[xx2]', .vxxmpt2,1))
>
> Thanks
> Marc
>
>
>
>
> --- RBASE-L
> =======================3D=======================
> D=
> TO POST A MESSAGE TO ALL MEMBERS:
> Send a plain text email to [email protected]
>
> (Don't use any of these words as your Subject:
> INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
> REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
> =======================3D=======================
> D=
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [email protected]
> In the message SUBJECT, put just one word: INTRO
> =======================3D=======================
> D=
> TO UNSUBSCRIBE:
> Send a plain text email to [email protected]
> In the message SUBJECT, put just one word: UNSUBSCRIBE
> =======================3D=======================
> D=
> TO SEARCH ARCHIVES:
> Send a plain text email to [email protected]
> In the message SUBJECT, put just one word: SEARCH-n
> (where n is the number of days). In the message body,
> place any
> text to search for.
> =======================3D=======================
> D=
>
>
>
