select Data input from csv file

[SeanBassett]

I need to get data from a csv (text) file.
I only need to read one piece of data from the csv file.

I am using Python in Blender 2.79 to control the movement of a model using data from the csv file.

CSV FILE:
Line5=58,5,0.5,77.5,1,,,,,,10
Line6=51,5,12,85,1,0,0,,0,1.5,10
Line7=89,0,0,,,,,,,,10
Line8=13,5,29.0,,,,,,,,10

Example - I need to read the second number on the top line (5).
Then convert it to a number so I can use it to move my model by that amount.

See below, this is what I have tried so far but it reads the second number from all the lines and I can not use it to create a single variable.

import csv
data = open(path+"TL3.txt", "r")
reader = csv.reader(data, delimiter=',')
next(reader)
row = data.readlines()
for row in reader:
print(row[1])
data.close()

Any help is greatly received. (I would not like to say how long I have been searching for an answer to this)

Sean

[j.crater]

Hi, please put your code in Python code tags. If you want you can also put CSV file contents in output or inline tags. You can find help here.

[SeanBassett]

I am reposting as I could not edit my original post (10 mins was up)
I need to get data from a csv (text) file.
I only need to read one piece of data from the csv file.

I am using Python in Blender 2.79 to control the movement of a model using data from the csv file.

CSV FILE:

Line5=58,5,0.5,77.5,1,,,,,,10
Line6=51,5,12,85,1,0,0,,0,1.5,10
Line7=89,0,0,,,,,,,,10
Line8=13,5,29.0,,,,,,,,10

Example - I need to read the second number on the top line (5).
Then convert it to a number so I can use it to move my model by that amount.

See below, this is what I have tried so far but it reads the second number from all the lines and I can not use it to create a single variable.

import csv
data = open(path+"TL3.txt", "r")
reader = csv.reader(data, delimiter=',')
next(reader)
row = data.readlines()
for row in reader:
print(row[1])
data.close()

Any help is greatly received. (I would not like to say how long I have been searching for an answer to this)

Sean

[SeanBassett]

New question.
I now have this posted 2 times, How do I delete the original (which did not have Python code tags)

[j.crater]

Threads are merged now, no worries about deleting.

And by the way, your code is not formatted properly (no indentation), so you may want to edit this.

[j.crater]

Your attempt could be made to work with some effort. But it is a bit of a blend (no pun intended) of techniques, and thus not the most optimal/maintainable approach.

Here is a (generalized) piece of code that can serve as a good starting point:

import csv

line = 0
column = 1

with open(path+"TL3.txt", "r") as file:
    mycsv = csv.reader(file)
    mycsv = list(mycsv)
    text = mycsv[line][column]
    print(text)

with means using a context manager. Which is more safe when working with files, since it will close it for you when the program is done using it.

[SeanBassett]

Perfect - it works

Thank you so much

Sean