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 Mike Lewis 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. Trebor423

    Parse delimited text from field into new row

    Thanks, will be sure to include better definition next time. Yes this will get run on a scheduled interval (every 4 weeks). I will look into having this done on SQL Server. Would the algorithm change?
  2. Trebor423

    Parse delimited text from field into new row

    So after I got past the rookie things (set warnings, naming, prebuild, …) I'm running the code. It's still running. This is the second time I'm running it, I killed it the first time after 20 minutes, but it had written 92k rows so it was working as hoped for. I feel like this will work but...
  3. Trebor423

    Parse delimited text from field into new row

    Working on it, novice issues to overcome first.. will post success/question soon. Thank you!
  4. Trebor423

    Parse delimited text from field into new row

    This looks like exactly what I need, thank you!
  5. Trebor423

    Parse delimited text from field into new row

    Thanks, but when I use the split function in a query it returns 'undefined' and I don't know enough (if any) VBA to write it
  6. Trebor423

    Parse delimited text from field into new row

    I have 2 columns, one with a product, the other with a ";" delimited string associated to that product in an Access 2016 table. I need to break that string up into multiple rows and into a new table. For instance Product = 1234 and Location = abd;DEF;ghij;kLmNo into 1234 abd 1234 DEF 1234...

Part and Inventory Search

Back
Top