Changing names in a directory from data contained within a spreadsheet.
in [Visual Studio]
|
Prev: biological query
Next: Passing object across processes
From: lamalatrin on 30 Dec 2009 16:11 I have a spreadsheet with information on homes that need to be photographed. There are 4 photos per home loaded in the directory in the exact same sequence as the spreadsheet. I need the 4 photos in the directory to have the name with the data contained in [ column B ]. Example photo 1, 2, 3, 4 to be renamed to 33704374.1, 33704374.2, 33704374.3 & 33704374.4 then 5, 6, 7, 8 to be named 33123918.1, 33123918.2, 33123918.3, 33123918.4. If the program could ask for the spreadsheet name and the directory name would be much appreciated. A B C D E F 33704374-1 4604 JENNIE AVENUE KEYES CA 95328 33123918-1 4301 SUNSET TER KEYES CA 95328 33162984-1 5317 CLARK STREET KEYES CA 95328 33336029-1 5237 CLARK ST KEYES CA 95328 33612380-1 4700 NORMA WAY KEYES CA 95328 33088836-1 5329 8TH.STREET KEYES CA 95328 33807154-1 5419 LEANDRA COURT KEYES CA 95328 33075556-1 5316 CLARK ST KEYES CA 95328 33531121-1 4217 WARDA AVENUE KEYES CA 95328 33497258-1 4733 ISABELLA AVE KEYES CA 95328 33602790-1 5504 8TH STREET KEYES CA 95328 33816210-1 5528 7TH STREET KEYES CA 95328 33296745-1 5400 CLARK STREET KEYES CA 95328 32938800-1 5117 GREENDALE DR KEYES CA 95328 33034851-1 5404 ROSELENA WAY KEYES CA 95328
From: lamalatrin on 31 Dec 2009 14:50 On Dec 31, 6:37 am, "Auric__" <not.my.r...(a)email.address> wrote: > On Wed, 30 Dec 2009 21:11:11 GMT, lamalatrin wrote: > > I have a spreadsheet with information on homes that need to be > > photographed. There are 4 photos per home loaded in the directory in > > the exact same sequence as the spreadsheet. I need the 4 photos in the > > directory to have the name with the data contained in [ column B ]. > > Example photo 1, 2, 3, 4 to be renamed to 33704374.1, 33704374.2, > > 33704374.3 & 33704374.4 then 5, 6, 7, 8 to be named 33123918.1, > > 33123918.2, 33123918.3, 33123918.4. > > > If the program could ask for the spreadsheet name and the directory > > name would be much appreciated. > > What's the format for the photo names *before* renaming? Sequential? Is it > literally "1.jpg", "2.jpg", etc.? > > -- > We are more familiar with wackos than I'd like to admit. The camera name them in sequential order. The renaming is determined by the each number in colum b in the spreadsheet. The files are in that order with 4 pictures per address. 100_1000 100_1001 100_1002 100_1003 100_1004 100_1005 100_1006 100_1007 100_1008 100_1009
From: Druidic Ranger on 3 Jan 2010 00:12 On Dec 31 2009, 7:37 am, "Auric__" <not.my.r...(a)email.address> wrote: > On Wed, 30 Dec 2009 21:11:11 GMT, lamalatrin wrote: > > I have a spreadsheet with information on homes that need to be > > photographed. There are 4 photos per home loaded in the directory in > > the exact same sequence as the spreadsheet. I need the 4 photos in the > > directory to have the name with the data contained in [ column B ]. > > Example photo 1, 2, 3, 4 to be renamed to 33704374.1, 33704374.2, > > 33704374.3 & 33704374.4 then 5, 6, 7, 8 to be named 33123918.1, > > 33123918.2, 33123918.3, 33123918.4. > > > If the program could ask for the spreadsheet name and the directory > > name would be much appreciated. > > What's the format for the photo names *before* renaming? Sequential? Is it > literally "1.jpg", "2.jpg", etc.? > > -- > We are more familiar with wackos than I'd like to admit. This is not what the group was chartered for. It says very plainly in the FAQ that this is a place for discussing the human genome. -- Snake Eyes
From: Druidic Ranger on 3 Jan 2010 00:18 On Dec 30 2009, 2:11 pm, lamalatrin <lamalat...(a)yahoo.com> wrote: > I have a spreadsheet with information on homes that need to be > photographed. There are 4 photos per home loaded in the directory in > the exact same sequence as the spreadsheet. I need the 4 photos in the > directory to have the name with the data contained in [ column B ]. > Example photo 1, 2, 3, 4 to be renamed to 33704374.1, 33704374.2, > 33704374.3 & 33704374.4 then 5, 6, 7, 8 to be named 33123918.1, > 33123918.2, 33123918.3, 33123918.4. > > If the program could ask for the spreadsheet name and the directory > name would be much appreciated. > > A B > C D E F > 33704374-1 4604 JENNIE AVENUE KEYES CA 95328 > 33123918-1 4301 SUNSET TER KEYES CA 95328 > 33162984-1 5317 CLARK STREET KEYES CA 95328 > 33336029-1 5237 CLARK ST KEYES CA 95328 > 33612380-1 4700 NORMA WAY KEYES CA 95328 > 33088836-1 5329 8TH.STREET KEYES CA 95328 > 33807154-1 5419 LEANDRA COURT KEYES CA 95328 > 33075556-1 5316 CLARK ST KEYES CA 95328 > 33531121-1 4217 WARDA AVENUE KEYES CA 95328 > 33497258-1 4733 ISABELLA AVE KEYES CA 95328 > 33602790-1 5504 8TH STREET KEYES CA 95328 > 33816210-1 5528 7TH STREET KEYES CA 95328 > 33296745-1 5400 CLARK STREET KEYES CA 95328 > 32938800-1 5117 GREENDALE DR KEYES CA 95328 > 33034851-1 5404 ROSELENA WAY KEYES CA 95328 Oh I get it, these are DNA codekeys. Funny thing is I once saw a 33497258 in the supermarket checking me out. -- Snake Eyes
From: Druidic Ranger on 3 Jan 2010 00:19
On Dec 31 2009, 12:50 pm, lamalatrin <lamalat...(a)yahoo.com> wrote: > On Dec 31, 6:37 am, "Auric__" <not.my.r...(a)email.address> wrote: > > > > > On Wed, 30 Dec 2009 21:11:11 GMT, lamalatrin wrote: > > > I have a spreadsheet with information on homes that need to be > > > photographed. There are 4 photos per home loaded in the directory in > > > the exact same sequence as the spreadsheet. I need the 4 photos in the > > > directory to have the name with the data contained in [ column B ].. > > > Example photo 1, 2, 3, 4 to be renamed to 33704374.1, 33704374.2, > > > 33704374.3 & 33704374.4 then 5, 6, 7, 8 to be named 33123918.1, > > > 33123918.2, 33123918.3, 33123918.4. > > > > If the program could ask for the spreadsheet name and the directory > > > name would be much appreciated. > > > What's the format for the photo names *before* renaming? Sequential? Is it > > literally "1.jpg", "2.jpg", etc.? > > > -- > > We are more familiar with wackos than I'd like to admit. > > The camera name them in sequential order. The renaming is determined > by the each number in colum b in the spreadsheet. The files are in > that order with 4 pictures per address. The colum? Is that the bone between the shoulder and the left ventricle? -- Snake Eyes |