Python Forum
Thread Rating:
  • 1 Vote(s) - 2 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Issue with reading CSV file
#11
If the file's content is that simple, you can perhaps parse it yourself without the csv module
with open(datafile) as infile:
    for line in infile:
        row = [x.strip() for x in line.split(',', 1)]
        # do something with the row
Reply
#12
But i need to add few words with in the lines like
Input line Column1 Number(10,2)
convert to
CAST (Column1 as NUMBER(10,2)) as Column1
Reply
#13
You can use
c, n = row
s = "CAST ({c} as {n}) as {c}".format(c=c.capitalize(), n=n.upper())
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Sad problems with reading csv file. MassiJames 3 559 Nov-16-2023, 03:41 PM
Last Post: snippsat
  Reading a file name fron a folder on my desktop Fiona 4 851 Aug-23-2023, 11:11 AM
Last Post: Axel_Erfurt
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,046 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Reading a file JonWayn 3 1,058 Dec-30-2022, 10:18 AM
Last Post: ibreeden
  Reading Specific Rows In a CSV File finndude 3 940 Dec-13-2022, 03:19 PM
Last Post: finndude
  Excel file reading problem max70990 1 865 Dec-11-2022, 07:00 PM
Last Post: deanhystad
  Replace columns indexes reading a XSLX file Larry1888 2 951 Nov-18-2022, 10:16 PM
Last Post: Pedroski55
  Failing reading a file and cannot exit it... tester_V 8 1,757 Aug-19-2022, 10:27 PM
Last Post: tester_V
  I have an issue with Netmiko Error reading SSH protocol banner omarhegazy 2 3,513 May-16-2022, 06:05 PM
Last Post: omarhegazy
  Reading .csv file doug2019 4 1,659 Apr-29-2022, 09:55 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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