Convert text file to csv vbscript

I just modified it. I cited the original StackOverflow question in the files in this gist. Maybe there will be more information there. Hope that helps. Skip to content. Sign in Sign up. Instantly share code, notes, and snippets.

Last active Oct 6, Code Revisions 4 Stars 28 Forks 6. Embed What would you like to do? Embed Embed this gist in your website. Share Copy sharable link for this gist. Learn more about clone URLs. Download ZIP. Instructions Copy both files into the directory containing the files you want converted Run excel-to-csv.

This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters Show hidden characters. Copy link. This is amazing. Is this correct? Nick Holness wrote: Where you have 'info' in the column data can this be "anything" so contain commas, spaces, etc i. You going to say you've got s of these to convert now aren't you : I do not have any control over the report.

It get's generated from a program and there is no option to change the format when it's generated. Unfortunately I only have a starter version of Excel and it doesn't have that feature.

Not but I do need to find a way to automate the process best I can. Jpars Nov 19, at UTC. BloodHoundGang wrote: Wayne Andersen wrote: Well, this isn't using PowerShell, but you could suck it into Excel using column positions and then put it out as a.

Have you tried LibreOffice? That should work. LibreOffice It's more of a sample it actually has many more. I can always try to just get the body first and then go back and manually enter in the header. If the text columns are variable width, then it'll be much harder to accomplish. BloodHoundGang wrote: Nick Holness wrote: Where you have 'info' in the column data can this be "anything" so contain commas, spaces, etc i. Just pop it in LibreOffice and save an Excel file.

Free and easy. Jpars wrote: BloodHoundGang wrote: Nick Holness wrote: Where you have 'info' in the column data can this be "anything" so contain commas, spaces, etc i. I've actually tried it on another PC with and the issue is the formatting.

It doesn't allow me to format it the way i need without re-typing almost everything. Does the real file have the same number of header columns as data columns? Does the data have spaces and commas? These questions were asked above, but I didn't see a clear answer.

Also: Is here always more that one space separating columns? No it has more data columns than header columns.

The header has commas the body has spaces. There are some that are almost tabbed and some with only a few spaces.

Beginning with Excel , the wizard is removed from the ribbon as a legacy feature. However, you can still make use of it:. In step 2 of the wizard, you are suggested to choose from the predefined delimiters tab, comma, semicolon, or space or specify your custom one:. Microsoft Excel and higher provides one more easy way to import a csv file - by connecting to it with the help of Power Query.

When creating a Power Query connection, you can choose the delimiter in the Preview dialog window:. To change the default List separator not only for Excel but for all programs installed on your computer, here's what you need to do:.

For this change to work, the List separator should not be the same as Decimal symbol. Click OK twice to close both dialog boxes. When done, restart Excel, so it can pick up your changes. Before changing the List separator on your machine, I encourage you to carefully read this section, so you fully understand possible outcomes. First off, it should be noted that depending on the country Windows uses different default separators. It's because large numbers and decimals are written in different ways across the globe.

List separator: comma ,. In most European countries, the default list separator is a semicolon ; because a comma is utilized as the decimal point:.

List separator: semicolon ;. For example, here's how two thousand dollars and fifty cents is written in different countries:.

How does all this relate to the CSV delimiter? The point is that the List separator CSV delimiter and Decimal symbol should be two different characters.

That means setting the List separator to comma will require changing the default Decimal symbol if it's set to comma. As the result, numbers will be displayed in a different way in all your applications.