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. That mistake have costed me hundreds of dollars already.Well, this isn't using PowerShell, but you could suck it into Excel using column positions and then put it out as a. However, the program is very error sensitive when it comes to its input. I now arrange that it can read both tab and comma. The program that uses the CSV is my own custom made program. csv files to contain tab delimited value do not seem to make sense at all. However, if I just save in a hurry, it won't save to.If I try to do file save as, excel will default to "txt" even though the file is clearly.I usually get out of excel and some prompt may have show up. How can that happens at all? The extension is still. But how the hell it become tab delimited in the first place? I never ever instruct excel to save it in tab delimited. Sometimes I open the file and found out that the comma is gone. That's because my program counts on csv files being csv.Īnd I never know, until now, how can my csv file becomes tab delimited format
0 kommentar(er)
