• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Use portion of record value as heading for launch

New Here ,
Dec 08, 2006 Dec 08, 2006

Copy link to clipboard

Copied

Hello,

I have a comment log running, with each new comment I auto enter the email time and date of the comment. I also insert an <hr> to visually deliniate the comments.

What I would like to do is "capture" the text from the begginning ofthe COMMENT field to the first <hr> tag for use as a summary on other pages........


TextThe dog is on the fence, the cat is gone!

by: alan_henderson@agilent.com
12/08/2006 12:08:13 PM
--------------------------------------------------------------------------------

There seems to be a cat bothering the dog..

by: alan_henderson@agilent.com
12/08/2006 11:45:53 AM
--------------------------------------------------------------------------------

I know one thing! It is not my cat!!!

by: alan_henderson@agilent.com
12/08/2006 11:45:23 AM

TOPICS
Advanced techniques

Views

300

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Dec 08, 2006 Dec 08, 2006

Copy link to clipboard

Copied

Try this:

REReplace(commenttext,'<hr>.*','')

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Dec 08, 2006 Dec 08, 2006

Copy link to clipboard

Copied

assuming you've read your file in and assigned it to the variable 'foo'...

rereplace(foo, '<hr />.*$', '', 'all')

should remove the first <hr /> and everything that follows, leaving just the first log entry.

caveat: i'm n00bish with regex, so if there are any issues or potential issues that any regex folk can see with that, please feel free to point out 🙂

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 08, 2006 Dec 08, 2006

Copy link to clipboard

Copied

LATEST
Thank you very much!!!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation