Converting .txt to .csv file

[pruthvi666]

In Python, you can convert a .txt file to a .csv file using the csv module. Here's a simple example assuming your .txt file is structured with lines of values separated by spaces or tabs:

import csv

# Specify the path for the input .txt file
input_txt_path = 'input.txt'

# Specify the path for the output .csv file
output_csv_path = 'output.csv'

# Read data from the .txt file
with open(input_txt_path, 'r') as txt_file:
    # Assuming the values in each line are separated by spaces or tabs
    lines = [line.strip().split() for line in txt_file]

# Write data to the .csv file
with open(output_csv_path, 'w', newline='') as csv_file:
    csv_writer = csv.writer(csv_file)
    csv_writer.writerows(lines)

print(f'Conversion from {input_txt_path} to {output_csv_path} completed.')

buran write Jan-19-2024, 08:02 PM:
spam link removed

Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[Larz60+]

how about:

>>> import csv
>>> fauxfile = [ 'mary had\ta little\tlamb', 'Its Fleece was\twhite as snow']
>>> for n, item in enumerate(fauxfile):
...     fauxfile[n] = item.replace(' ', ',').replace('\t', ',')
... 
>>> fauxfile
['mary,had,a,little,lamb', 'Its,Fleece,was,white,as,snow']
>>>