Importing specific data from .csv

[skunal]

I have .csv file containing 60 columns and i want the records of only 39 42 and 45 columns and store in Temp table.does anyone know the solution for thnis

 

[TomBascom]

define variable inLine as character no-undo extent 256.

input from value( "inFile.csv" ).
repeat:
  import inLine delimiter ",".
  display inLine[39] inLine[42] inLine[45].
end.
input close.

return.

I'll leave creating and populating the temp-table records as an exercise for the student.

Debugging is also an exercise