Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Text file read issues
#14
Thanks both

snippsat - that worked like a charm, thank you. I'll have to check out chardet. It looks very handy for figuring out encoding.

Ok, next question (sorry!)

I've tried to put this data into a list so I can work with it but it looks different in list format to printed format:

datapoints = []
with open("C:\\...\\170825  t05 L11O44S3.txt", encoding ='UTF-16') as f:
    for i in f:
        datapoints.append(i)

print(datapoints)
Output:
['25 August 2017 09:15:00\t23.19\n', '25 August 2017 09:00:00\t22.98\n', '25 August 2017 08:45:00\t22.76\n', '25 August 2017 08:30:00\t22.62\n, ....'
So I tried removing the \, t and n in the list by modifying the code to

datapoints = []
with open("C:\\...\\170825  t05 L11O44S3.txt", encoding ='UTF-16') as f:
    for i in f:
        datapoints.append(i)

for data in datapoints:
    data = data.replace('\\t',' ')
    data = data.replace('\\n','')

print(datapoints)
but this results in exactly the same output as before.

What am I doing wrong?
Reply


Messages In This Thread
Text file read issues - by Complex_Potential - Jul-23-2018, 08:06 AM
RE: Text file read issues - by gontajones - Jul-23-2018, 10:16 AM
RE: Text file read issues - by buran - Jul-23-2018, 11:03 AM
RE: Text file read issues - by Complex_Potential - Jul-23-2018, 11:32 AM
RE: Text file read issues - by buran - Jul-23-2018, 12:04 PM
RE: Text file read issues - by Complex_Potential - Jul-23-2018, 12:18 PM
RE: Text file read issues - by buran - Jul-23-2018, 01:46 PM
RE: Text file read issues - by Complex_Potential - Jul-23-2018, 02:13 PM
RE: Text file read issues - by snippsat - Jul-23-2018, 02:20 PM
RE: Text file read issues - by Complex_Potential - Jul-23-2018, 02:41 PM
RE: Text file read issues - by Complex_Potential - Jul-24-2018, 02:05 PM
RE: Text file read issues - by gontajones - Jul-24-2018, 02:22 PM
RE: Text file read issues - by snippsat - Jul-24-2018, 02:24 PM
RE: Text file read issues - by Complex_Potential - Jul-24-2018, 03:52 PM
RE: Text file read issues - by buran - Jul-24-2018, 04:03 PM
RE: Text file read issues - by Complex_Potential - Jul-24-2018, 04:10 PM
RE: Text file read issues - by buran - Jul-24-2018, 04:23 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Connecting to Remote Server to read contents of a file ChaitanyaSharma 1 289 May-03-2024, 07:23 AM
Last Post: Pedroski55
  Recommended way to read/create PDF file? Winfried 3 2,985 Nov-26-2023, 07:51 AM
Last Post: Pedroski55
  python Read each xlsx file and write it into csv with pipe delimiter mg24 4 1,628 Nov-09-2023, 10:56 AM
Last Post: mg24
  read file txt on my pc to telegram bot api Tupa 0 1,186 Jul-06-2023, 01:52 AM
Last Post: Tupa
  parse/read from file seperated by dots giovanne 5 1,174 Jun-26-2023, 12:26 PM
Last Post: DeaD_EyE
  Formatting a date time string read from a csv file DosAtPython 5 1,434 Jun-19-2023, 02:12 PM
Last Post: DosAtPython
  How do I read and write a binary file in Python? blackears 6 7,343 Jun-06-2023, 06:37 PM
Last Post: rajeshgk
  Read csv file with inconsistent delimiter gracenz 2 1,254 Mar-27-2023, 08:59 PM
Last Post: deanhystad
  Read text file, modify it then write back Pavel_47 5 1,725 Feb-18-2023, 02:49 PM
Last Post: deanhystad
  Correctly read a malformed CSV file data klllmmm 2 2,087 Jan-25-2023, 04:12 PM
Last Post: klllmmm

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020