convert excel to pipe delimited text file

Writer_delim.writerow(header) # add headerįor record_index, row in enumerate(reader_pipe, 1): # loop to read file Writer_delim = csv.writer(file_comma, delimiter = ',') Reader_pipe = csv.reader(text_pipe, delimiter = '|') With open('datafile.txt', mode='r') as text_pipe, open('output.csv', 'w', newline= '') as file_comma: Since you're just counting on a loop, consider using enumerate() for a counter rather than managing your own. If you're just going to exit immediately if either open fails and you're done with them at the same time, then you might want to put them in the same with and save some indent space. You don't need two separate contexts to open two files.

If you want to add record_index to your CSV, modify row directly to put that value in the row. CSV file, it will automatically use a comma as the delimiter, which is what you don't want.Writerow() takes exactly one argument: the entire row you want to write/append to your csv. TXT file, so Excel will ask you what the Field Delimiter Character is. If you want to import it, I'd recommend renaming it to a. Once this is done, you can save the file. Only replace the commas that are delimiters of the data, and nothing in quotation marks. The reason for this, is that if there are commas in your data as well, this will break your file. In 'Replace with:', type the character you want to use for the separator. Once you find that the character you want to use isn't being used elsewhere in your document, then you can do a Search and Replace. To search for a tab easily, I'd recommend using Notepad++. If you hit any results, do not use this character. If you want a pipe, search for a pipe ( |). Do a search for whatever character you want to use (i.e. Open a text editor like Notepad or Notepad++. If you do not want a comma as a separator, you can save the file as a CSV still, then edit it manually. What happens if you have a comma in your data though? Excel will automatically surround that cell's content with quotation marks ( '), so the program importing the file will know when that cell actually ends. To break this means it will not follow the specification. Remember that CSV files are Comma Separated Values, which follows a standard: Data, a comma, data, a comma, etc. I don't see an option immediately in Excel, but I can offer some advice.

Convert excel to pipe delimited text file