N
Nate
Hello folks,
I am in the process of moving records from an older Access DB to a newer one
which has a slightly different design. In order for the move to succeed, I
need to be able to remove a number of different text strings from a field.
Specifically, I need to remove file suffixes and extensions but leave the
rest of the data intact. For example: the filename field may contain a record
like "holidayseg01_320.flv". I need to remove the "_320.flv" There are
another 15-20 suffixes w/ extensions that I need to remove and I'd like to
find a proceedural way to set this up so that I can reproduce my results
without having to spend half the day using Find and Replace for each
extension. I've looked through some of the discussions but was unable to find
(or maybe understand) the answer I need. Can somebody walk me through? You
may need to dumb it down a bit as I'm not fluent in SQL or VB, but I do know
my way around the Access interface...
Thanks in Advance!
I am in the process of moving records from an older Access DB to a newer one
which has a slightly different design. In order for the move to succeed, I
need to be able to remove a number of different text strings from a field.
Specifically, I need to remove file suffixes and extensions but leave the
rest of the data intact. For example: the filename field may contain a record
like "holidayseg01_320.flv". I need to remove the "_320.flv" There are
another 15-20 suffixes w/ extensions that I need to remove and I'd like to
find a proceedural way to set this up so that I can reproduce my results
without having to spend half the day using Find and Replace for each
extension. I've looked through some of the discussions but was unable to find
(or maybe understand) the answer I need. Can somebody walk me through? You
may need to dumb it down a bit as I'm not fluent in SQL or VB, but I do know
my way around the Access interface...
Thanks in Advance!