Recent content by ETSMAN

Thank you, all is working great. Once again I appreciate all the help and learning opportunity.

Just need to create a new module for new code correct? 1. new code saved as a module called "trimBadChars" 2. no change to "tblBadChars" fields (should contain any unwanted #letter. combination) 3. no change to "RemoveBadChars-UpdateQuery"

I scrubbed the tblBadChars and put just #., #letter. and all works fine. This is a naming std. issue and I'm sure it could be coded to work, but for this effort this will do. The files for order will have to follow a std. of #letter.space. thx again. I'm sure got my little purple stars;)

let me play w/ it a little more, still seems like my results are not consistent. I'll check the code and vers. etc.

MajP, can u walk me thru the code, trying to understand why I get the following results: my badchar table has (for #s 1-10) 1 1. 1a 1a. . . . 10 10. 10a 10a. if the record is "1a. filename.txt" I get "ename.txt" (7characters trimmed) if the record is "1.a filename.txt" I get "filename.txt"...

Ahhh be nice Skip, I'm new to the whole forum thing, thought I gave credit were credit was due. Per my posts I hope it's obvious that my appreciation for all of MajP is obvious, but thank you for covering me. I click the little purple star once and thought it would tag the all the posts, I...

I think this will work playing w/ some test data, there are a few situations that need to be addressed, but I'll play around and see what I can do. If not I'll hit you up one last time in the morn. thx.

correct only #s, spaces, ., and - typically inconsistent format in usage (1a. xxx, 1a.xxx, etc.)used to sort order in the directory file system.

I see where u r going with the new table unfortunetaly I do not control the directory structure and it changes very dynamically. I'll need a function... to strip off the numbers and spaces. thx

Ex. Before After 2 newfilename.pptx -> newfilename.pptx 1. filename.pptx -> filename.pptx 6filename1.pptx -> filename1.ptx 4-filenameBB.pptx -> filenameBB.ptx Not sure this is the most effiecient statement, but this is how I got all fields starting w/ a number. SELECT...

Query works fine, found the records I need using "Like" command now how do I update the field keeping everything but what I found w/ "Like"? If I update w/ "" that will update complete field to blank correct? I just want to replace my findings and have the field start with the next character...

will do, thx again.

great thx, appreciate the guidance.

MajP, Everythingn is still working great thanks to u. I don't want to take up too much more of your time, but had another question. To clean up the manual part of the "Presentation" field would it be more efficient to wright a macro or sql statement and do an update query? Re-cap of issue...

All seems to be working fine now, I'll play around w/ it for a day or so. THANKS again for all your help.