Importing selected rows

It's time to practice importing only a few rows from a file as opposed to importing the entire file. You will be importing the following file:

id,"name",val
29192,"Robert Whitaker", 200
49301 ,"Elisa Waters,190  
34456 , Karla Schmidt,458  

END-OF-DATA
METADATA
attr;value
date;"2018-01-01"
data;"cash payment" 

Unfortunately, files like these do exist in real life.