Hi Jared
Great news! It worked!
Take a look at this link to see my results Test Script
Thank you soo much!
Kind regards
Dan
User Profile
Collapse
-
Hi Jared
Can you keep your test script live until I post back so I have something to verify against..?
Thanks again!
DanLeave a comment:
-
Hi Jared
Thanks for this! I'm gonna give a whirl ASAP...
I'm ok with the code, thanks for the offer!
I'll post back after testing
Thanks again
DanLeave a comment:
-
Hi jhardman
Thanks, I see your logic, however the syntax I am struggling with... Can you help me write the regex's
Kind regards
DanLeave a comment:
-
Hi jhardman
Thanks for your reply and in essence I agree with you, unfortunately the peeps entering the info are paying customers... No matter how much I tell the sales dept. to tell their clients not to do this, they will always try to push it, which annoys all the other customers who do not.
With a DB of over 1 million description records, I could really use a funcion to do this rather than me wasting my life checking...Leave a comment:
-
Regular Expression Function to remove email address in string
I have a form with text description field, but some people keep putting email addresses, telephone numbers, HTML and URL's in the descriptions.
I can remove the HTML tags using a regular expression, but I can't figure out how to remove email addresses, telephone numbers and URL's from a text string... eg.
'Lorem ipsum dolor sit amet, some.email@mydo main.com consectetur adipisicing elit, anotheremail@so medomain.com sed do... -
MySQL Subselect
This may seem simple to most, but for some reason i cannot get this to work!!
I have 2 tables, table_a & table_b
Both tables have a string reference number used to join. table_a will only ever have one occurance of the reference number, where as table_b has multiple records with the same reference reference number, ordered by a column called 'order'.
I am trying to pull out all records in table_a and...
No activity results to display
Show More
Leave a comment: