Selecting specific columns to import from a CSV

4 views (last 30 days)
The data I import from my GPS is formatted as CSV files with the following headers:
ID, Session_ID, Heading, Altitude, Latitude, Longitude, Created_DateTime
I only need the Latitude and Longitude values in columns 5 and 6. Is there any way of achieving this?
Currently I delete the last column manually in excel (Created_DateTime) and then use:
data = csvread('gps.csv',1,4);
This returns my latitude/longitude data but I'm wondering if there is a way of doing this without having to manually delete the Created_DateTime column in excel?

Accepted Answer

dpb on 12 Feb 2015
fmt=[repmat('%*f',1,4) repmat('%f',1,2) '%*[^\n]'];
doc textscan % for details...
Stanley Kubrick
Stanley Kubrick on 12 Feb 2015
Actually just found a "Generate Script for Selection" under an Import button, thanks for your help though!

Sign in to comment.

More Answers (1)

sathish kumar rb
sathish kumar rb on 11 Nov 2017
hi need to select a specific colomns and rows copy one to another csv file how

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!