Extracting data from a CSV file

Hi I am trying to extract some information from a CSV file, the data fields I want are in rows and not columns. I also want some rows to be ignored. I have tried but have been unsucessful hoping someone can help.

I am attaching the original report in a pdf and csv. What I would like to extract is:

Record Name : John Dingle
Date of treatment 20/01/2014
Location Home
Type of Treatment Counselling

There are several different names so I would like the above to be shown for all listed.

Many thanks

Hi thanks for the reply which I tried and it works. I forgot to include the Time Allocated field as being required, which is in the csv field. I tried to see if I could add it but far too complex for me.

Would you be able to add it?

Many thanks in advanced, I had spent ages trying to use text to columns thinking this was the option!

Yeap sure..

Add this line just above the "End Select" statement..

Please Login or Register  to view this content.

I have reattached the file with this added in case you run into problems adding the code..

Many thanks again for your help.