Don't split it, because you only need the first paragraph. I would just do an INSTR() for vbCRLF and take the LEFT() of the text up to the point where you found the vbCRLF.
Now if you want every paragraph separated, then yeah, I'd probably do a SPLIT() Chris ----- Original Message ----- From: "Pete Lundrigan" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 7:35 AM Subject: RE: ASP Access and Displaying the first Paragraph You could possibly use the Split function to split the field up by the dual vbcrlf's then display the first element of the resulting array. Pete Lundrigan Media Resources Center Academic Web Support 316.978.7759 http://www.mrc.twsu.edu/ [EMAIL PROTECTED] -----Original Message----- From: Alex Elger [mailto:alex.elger@;micronage.com] Sent: Tuesday, October 15, 2002 7:42 AM To: ActiveServerPages Subject: RE: ASP Access and Displaying the first Paragraph Currently the text is being stored in a memo field using 2 carriage returns as a paragraph separator. In the asp page that actually displays it the cr's are replaces with <Br> i.e. Synopsis = Replace(Synopsis,vbCrLf,"<br>"). If that could be used to determine the paragraph then that would be more useful than using left(). Thanks Alex Elger Micronage Ltd [EMAIL PROTECTED] -----Original Message----- From: Chris Tifer [mailto:christ@;saeweb.com] Sent: 11 October 2002 4:44 PM To: ActiveServerPages Subject: Re: ASP Access and Displaying the first Paragraph How do you define a paragraph in the DB? Do you put linebreaks or is there HTML stored with this text? Chris Tifer ----- Original Message ----- From: "Alex Elger" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, October 11, 2002 2:55 AM Subject: ASP Access and Displaying the first Paragraph > I have an access DB which i have written an ASP front end for. > On my list page i would like to include a "Teaser" being the first paragraph > of what i have in the Synopsis column. > Is this possible and if so how would this goal be accomplished? > Thank you all for your time > Alex Elger > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
