Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


String pattern find and set as variable

String pattern find and set as variable

String pattern find and set as variable


I was wondering if anyone could suggest how i may accomplish this.
I wanted to have users enter in a pattern in a note field of an application and then run an AFTER INSERT trigger that would "read" the note and look for a pattern and then set the value within that pattern as a variable.

AN example is this.
if an user inputs ##jedwards## in the note field, then the note would be inserted and then the trigger would assign the note to that user, jedwards. Currently the application is a closed app and i can only manipulate the backend. this is one way that notes can be assigned to users other than the ones entering the note, so they can be alerted of the note, such as a callback.

i was contemplating using some sort of preg_replace function i can install, lib_mysqludf_preg, but i am not sure this will apply too well.
since the user name within the '##' grouping is a variable field, it makes this a bit tricky. i can however force users to enter in the username in any pattern suggested, but i am not sure how to parse the record to pull it out and then update the note to be assigned to the username in that variable...

any ideas?


RE: String pattern find and set as variable

You can probably do the whole thing with a mysql stored procedure rather than use a trigger.

Do the initial insert inside the procedure
Parse the notes field
Test to see whether a corresponding user exists and
If so write to that user's row.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close