AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Convert txt file into csv5/10/2023 ![]() Where you have 'info' in the column data can this be "anything" so contain commas, spaces, etc i.e. ![]() I was hoping powershell might be able to help me. I need to convert a text report.to a csv so I can send it in. At least if everything is comma delimited I might be able to work with it a little easier. This is why I'm trying to convert it so I can work with it in excel. No but it does contain a "header" and "body" that are formatted differently. It's a rather large report and that would just take too long.Ī CSV file is technically a text file, but with a different name, so why not simply rename the file?ĭoes your text file actually contain a string that says "" and "?" When I try to rename it doesn't format it to anything I'll be able to use without re-typing the whole thing. ![]() The issue here is that I don't have a version of excel that will allow me to do text to columns. Well, this isn't using PowerShell, but you could suck it into Excel using column positions and then put it out as a.
0 Comments
Read More
Leave a Reply. |