I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename | filename.pdf | "file name.pdf"

Export to txt:

rename | filename.pdf | """"file name.pdf""""

You could enter it into the cell as a formula, like this:

=CHAR(34)&"file name.pdf"&CHAR(34)

and this will give you:

"file name.pdf"

Hope this helps.

Pete


On Aug 7, 2:18*pm, X-Ray wrote:
I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename * * | *filename.pdf * | * * *"file name.pdf"

Export to txt:

rename * * | *filename.pdf * | * * *""""file name.pdf""""

Why dont you just open the .txt file in a notepad and do a find/replace

Find: """
Replace: "

If this post helps click Yes
---------------
Jacob Skaria


"X-Ray" wrote:

I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename | filename.pdf | "file name.pdf"

Export to txt:

rename | filename.pdf | """"file name.pdf""""

You could use a helper column (column D??) that contained formulas like:

=a1&" """&b1&""" """&c1&""""

Then copy that column and paste into a notepad file. Then save that file as
something.bat



X-Ray wrote:

I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename | filename.pdf | "file name.pdf"

Export to txt:

rename | filename.pdf | """"file name.pdf""""

--

Dave Peterson

Nice workaround, I completely didn't think of it. But not really desirable. I
prefer to not have any actions outside Excel, so I can further automate the
actions in Excel.

"Jacob Skaria" wrote:

Why dont you just open the .txt file in a notepad and do a find/replace

Find: """
Replace: "

If this post helps click Yes
---------------
Jacob Skaria


"X-Ray" wrote:

I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename | filename.pdf | "file name.pdf"

Export to txt:

rename | filename.pdf | """"file name.pdf""""

When exporting to a text-file I still get extra undesired quotes.

"Pete_UK" wrote:

You could enter it into the cell as a formula, like this:

=CHAR(34)&"file name.pdf"&CHAR(34)

and this will give you:

"file name.pdf"

Hope this helps.

Pete


On Aug 7, 2:18 pm, X-Ray wrote:
I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename | filename.pdf | "file name.pdf"

Export to txt:

rename | filename.pdf | """"file name.pdf""""

Nice and simple workaround to copy the selection to notepad. But not really
desirable. I prefer to not have any actions outside Excel, so I can further
automate the actions in Excel.

And I already tested to make use of a helper column. But thanks anyway.


"Dave Peterson" wrote:

You could use a helper column (column D??) that contained formulas like:

=a1&" """&b1&""" """&c1&""""

Then copy that column and paste into a notepad file. Then save that file as
something.bat



X-Ray wrote:

I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename | filename.pdf | "file name.pdf"

Export to txt:

rename | filename.pdf | """"file name.pdf""""

--

Dave Peterson

I have found a solution. When I save as "Space delimited (*.prn)" there are
no extra quotes added.

Thx everybody for your suggestions.

"X-Ray" wrote:

I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename | filename.pdf | "file name.pdf"

Export to txt:

rename | filename.pdf | """"file name.pdf""""

I forgot to mention that it is still necessary to enter the quotes yourself,
but there are no extra qoutes added.

"X-Ray" wrote:

I have found a solution. When I save as "Space delimited (*.prn)" there are
no extra quotes added.

Thx everybody for your suggestions.

"X-Ray" wrote:

I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename | filename.pdf | "file name.pdf"

Export to txt:

rename | filename.pdf | """"file name.pdf""""

If you really don't want any actions outside of excel, maybe you should have a
macro that runs against the data--avoiding the .bat file completely.

Excel's VBA has its own Name command (see VBA's help) to rename files.



X-Ray wrote:

Nice and simple workaround to copy the selection to notepad. But not really
desirable. I prefer to not have any actions outside Excel, so I can further
automate the actions in Excel.

And I already tested to make use of a helper column. But thanks anyway.

"Dave Peterson" wrote:

You could use a helper column (column D??) that contained formulas like:

=a1&" """&b1&""" """&c1&""""

Then copy that column and paste into a notepad file. Then save that file as
something.bat



X-Ray wrote:

I want to make a batch rename file. Therefore I put the commands and
parameters in columns in Excel and save this to a txt file.
But I run in to the following problem. When a filename contains a white
space I have to enclose the name between double quotes. But when I do this in
Excel and make an export extra quotes are added.
How do I add the double qoute sign the right way ?

Example (|-sign to indicate columns):

Excel:
rename | filename.pdf | "file name.pdf"

Export to txt:

rename | filename.pdf | """"file name.pdf""""

--

Dave Peterson


--

Dave Peterson