How to export to txt and use "-sign
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"""" |
How to export to txt and use "-sign
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"""" |
How to export to txt and use "-sign
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"""" |
How to export to txt and use "-sign
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 |
How to export to txt and use "-sign
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"""" |
How to export to txt and use "-sign
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"""" |
How to export to txt and use "-sign
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 |
How to export to txt and use "-sign (Sollution)
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"""" |
How to export to txt and use "-sign (Solution - additional info)
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"""" |
How to export to txt and use "-sign
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 |
All times are GMT +1. The time now is 10:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com