Reading a CSV

[lewoc]

I have a CSV file that looks like this:

htt ps://gyazo. c om/51b69c4d128286521e86cb5715b5fd9a

I need a program that does this:

If Title = 'Title 1(2, 3, 4)' Data should = '1'("Live", 3.6)

The program basically needs to check that each column holds the correct data type.

I have tried to do this loads of way but everything seems to work with rows not columns and it is confusing me.

Thanks a lot guys

[camp0]

I think your friend in this case is "split"

[lewoc]

How would I implement this to work how I want it to

[ichabod801]

Show us what you've tried, tell us (precisely) how it is not working right, and we'll help you fix it. We're here to help, not to do.

[Axel_Erfurt]

From your picture I can not read much, because almost all lines are identical.