Clear Filters
Clear Filters

Extract data from ASCII format

12 views (last 30 days)
Majid Mohamod
Majid Mohamod on 11 Apr 2018
Commented: Majid Mohamod on 26 Oct 2018
Hi all, I have GLDAS Land Water Content (monthly) data. it says on the website that these data type are ASCII format. However, when I download the data the file extension is txt. Please, I need help to figure out a way to convert the file to csv format or xyz text file.
I have a script I used it before and it works very well to convert asc format but doesn't work with the current data! I attached one of the files The script here:
  2 Comments
Teresa
Teresa on 26 Oct 2018
Hi Majid,
I just read your post and perhaps you may give me a few guidelines. I actually have an .asc file but I cannot accede it in matlab. I have tried the functions: 'importdata', 'fopen' to define a Fid and then 'textscan'. However, I am not acceding correctly the data as I am only getting the number of rows. Could you tell me which function were you using? Thank you in advance. Teresa
Majid Mohamod
Majid Mohamod on 26 Oct 2018
Hi Teresa,
The following code has used to convert weather data (PERSSIAN, CDR and CSS) to csv format. I am not sure if it will work for you. Please, find the attachment.
Thanks, Majid

Sign in to comment.

Accepted Answer

KSSV
KSSV on 11 Apr 2018
Edited: KSSV on 11 Apr 2018
fid = fopen('GLDAS_NOAH10_M.A200101.totalH2O.txt','r') ;
S = textscan(fid,'%f %f %f','HeaderLines',19) ;
fclose(fid) ;
x = S{1} ; y = S{2} ; z = S{3} ;
data = [x y z] ;
save 'myfile_xyz.txt' data -ascii

More Answers (0)

Community Treasure Hunt

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

Start Hunting!