X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Rename A Part Of A Folder, Access 2016    
post Oct 4 2019, 02:10 PM

Posts: 79
Joined: 6-August 15

Good morning, everyone,

I would like to standardize the labels of my files. So I have a folder

c: Staff Eric Lepetit (123) folder1 Folder2 Folderx ABC.txt
c: Personnel John Medium 456 folder1 Folder2 Folderx DEF.txt
c: Staff Matt Eric Lepetit folder1 Folder2 Folderx GHI.txt

And I would like to have as a result

c:\Staff\Eric Lepetit (123)\folder1\Folder2\Folderx\ABC.txt
c:\Staff\John Medium (456)\folder1\Folder2\Folderx\DEF.txt
c:\Staff\Matt lesage (789)\folder1\Folder2\Folderx\GHI.txt

To do this I have an access table (DEC) with NomNameMatr field (ex: Eric Lepetit (123))

In fact it would be a rename of
c:\Staff\& 'NomNameMatr'&\folder1\Folder2\Folderx\xxx.txt
Go to the top of the page
post Oct 5 2019, 09:36 AM

UA Admin
Posts: 36,023
Joined: 20-June 02
From: Newcastle, WA

First, I would recommend you avoid using parenthesis as part of a path name. An avoidable potential source of problems.

Is there a question here? You state you want to do this, but not the context in which it is to be done?

What have you tried so far? What happened?

How can we help?

My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    13th November 2019 - 05:35 AM