Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. benniesanders

    find text between <> tags

    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...
  2. benniesanders

    need to get remaining records for dropdown

    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.
  3. benniesanders

    need to get remaining records for dropdown

    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...
  4. benniesanders

    Validate forms when users enter spaces

    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.
  5. benniesanders

    Validate forms when users enter spaces

    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.
  6. benniesanders

    Validate forms when users enter spaces

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

    Validate forms when users enter spaces

    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.
  8. benniesanders

    Validate forms when users enter spaces

    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...
  9. benniesanders

    compile error: automation error

    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...
  10. benniesanders

    Import XML file into access with asp

    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.
  11. benniesanders

    Find IP address in files FSO?

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

    Find IP address in files FSO?

    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...
  13. benniesanders

    Extract email address from bounces

    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...
  14. benniesanders

    Maybe use mid function? to extract data

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

    Extract email address from bounces

    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!
  16. benniesanders

    Maybe use mid function? to extract data

    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.
  17. benniesanders

    Maybe use mid function? to extract data

    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...
  18. benniesanders

    Maybe use mid function? to extract data

    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...
  19. benniesanders

    Maybe use mid function? to extract data

    My apologies. VBScript. Thank you! :)
  20. benniesanders

    Maybe use mid function? to extract data

    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 @...

Part and Inventory Search

Back
Top