Selecting specific columns to import from a CSV
4 views (last 30 days)
Show older comments
Answered: sathish kumar rb on 11 Nov 2017
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?
dpb on 12 Feb 2015
fmt=[repmat('%*f',1,4) repmat('%f',1,2) '%*[^\n]'];
doc textscan % for details...
More Answers (1)
sathish kumar rb on 11 Nov 2017
hi need to select a specific colomns and rows copy one to another csv file how
Find more on Text Files in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!