Search results for query: *

I'm having a hard time searching for this answer. I have a SQL text field from which I need a query to extract the text between <> tags, i.e. <some text here> excluding everyting else in the field. There could be as much as a paragraph in the field. I'm absolutely blank on how to handle this...

Thank you both. I'll try Nick's first, then repost either way. If it doesn't work, I'll post the code I have so far. Thanks again.

Greetings, I have a simple delivery calendar project. In Access 2000 there is a calendar table with a date and time field and a time table with 8 different time slots. The user adds a new calendar item by choosing a date then chooing an available time slot. Here's where I'm having problems...

Thank you everybody for this help. Monksnake's answer fixed the spaces problem. I don't know why these kids enter info in all of the other fields and not this one and the highschool field is very important. Go figure! Many thanks again to everyone.

Dian, I'm SO not a javascript guru. I wouldn't even know where to start with the link you sent; how to modify my code with that trim function. Thank you very much anyway.

CORRECTION. It's a Prom Agent form and covers all high schools, but still it's nationwide for a Tuxedo provider.

Hi Monksnake, I wish I could use a dropdown, but no good. It's a nationwide site. It's actually an out of town measurements form for a tuxedo provider :) Diancecht, I'll read the link the you sent. Thanks very much.

Greetings, I have a lengthy user form and we've noticed some of the site visitors are hitting the spacebar for one of the fields. I have a form validator in place, but if they hit the space bar, it moves on to the next field. Here's a snippet of my validation code for the rogue field: if...

Greetings, I'm not sure I'm even posting in the right place, but I couldn't find a better place, so here goes... I have a very small excel spreadsheet that was created on a PC but many users run on a mac. The error occurs in the following vba: Sub Show() emails.show end sub That's it. These...

Greetings, I have an xml file with one field (field1) that I need to import into an access database table with the same field name (field1). Or I could just update the table in the access database with this XML file, whichever is better, easier. Any ideas would be appreciated. Thank you.

I figured it out. I took an old search routine and used the IP address as the search text. It worked. Many thanks.

Greetings, I have a gazillion files that an old, bad IP address could be buried in. Is there a way to open the files using FSO, look for that IP address and response write the filename? I've used this code in the past to get a file list excluding images. I'm not smart enough to figure out...

Hi Robert, Here's the code I'm using to extract email addresses from brackets and <>: brackets email_address: Mid([body],InStr([body],'[')+1,InStr([body],']')-(InStr([body],'[')+1)) <> email_address: Mid([body],InStr([body],'<')+1,InStr([body],'>')-(InStr([body],'<')+1)) I made a few...

Chris, brilliant. I need to do a teeny bit of tweaking, but not much. many thanks for your help!

Hi Robert, that sounds great. Yes those bounces always look like that. Those are the only ones I have probs with. and what you are suggesting sounds great, but I don't now how to do it. Not smart enough to figure out how to do this :( Thanks very much!

Wow, thanks Chris. I was posting to the others when I found yours! I tried it and got: Invalid procedure call or argument: 'mid' on this line GetHostname = mid(strIn, intPos + 1, endPos - intPos) and of course I'm not smart enough to know what to do at this point. Many many thanks.

guys, I can't get any of this to work. I'm not very good at the split thing, and Monk, I'm getting an error on this: if (Instr(arr(a), "@") > 0) then a = arr.length emailAdd = arr(a); I'm not sure DoTNetGnat about yours. Am I supposed to run that after his? I"m totally lost...

Thank you both so much. I will let you know how everything turns out. It's important I figure out a way to extract these. We provide medical training courses and mail course lists. As you can imagine, we have bounces. I've figured out how to extract the bounces with email addresses between...

My apologies. VBScript. Thank you! :)

Greetings, I have 300 records, each with a block of text I need to extract an email address from. Every email address has a space before it and a space after it and of course the @ between. So how would I go about extracting everything to the left of the @ and everything to the right of the @...