convert excel to pipe delimited text file

Writer_delim.writerow(row) # print value in each line 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. In brief, to retain any value in a column exactly as it is, you can enclose the value in quotation marks or an apostrophe.Writerow() takes exactly one argument: the entire row you want to write/append to your csv. If no character is specified as the text qualifier, 'Albany, NY' is imported into two adjacent cells as Albany and NY. To treat the city and country names as one value and import them into one Excel cell we have to use double quotes or an apostrophe as a text qualifier. Microsoft Excel can read the comma (,) in between the two words as a delimiter. In a text file with city and state names, there may be some values like 'Albany, NY'.

Do remember that the value between the assigned delimiter can have another delimiter character, but it needs a quotation mark (') or an apostrophe (').Ĭonfusing? Not so much. Any value that follows the delimiter and precedes the next occurrence of the delimiter is imported as one value. The Text Delimiter keeps each value separate from the next.

Convert excel to pipe delimited text file