dear All
anyone knows how to extract time series in sac file to excel sheet ?
I need this time series in order to use it in EERA.
regards
anyone knows how to extract time series in sac file to excel sheet ?
I need this time series in order to use it in EERA.
regards
-
Hello Firdaus,
The easiest solution is to convert the SAC data to simple ASCII format and “import” the text values into Excel.
One possibility is to use the ‘sac’ program to write the data in “SAC alphanumeric” format, which is just ASCII. The challenge is that this data is not easily imported into Excel due to how it is formatted (the series spans multiple columns).
An easier possibility is to use one of many programs to convert the SAC data to simple ASCII in a single column of data (and time stamps).
If you can compile software from source code, one such program that I would recommended is called "sacdump” available here:
https://seiscode.iris.washington.edu/projects/sacdump
To print all the defined headers and the all the samples, you can use a command line like this:
$ sacdump -a -D mydata.sac > mydata.txt
That command would save the output to a file mydata.txt, which can then be easily imported into Excel.
The man page (and Wiki) contains full usage:
https://seiscode.iris.washington.edu/projects/sacdump/wiki
If you cannot compile software you should let the list know what system you are running on for other suggestions.
regards,
Chad
On Jan 6, 2014, at 5:47 PM, Firdaus firdaus <alikomeini<at>gmail.com> wrote:
dear All
anyone knows how to extract time series in sac file to excel sheet ?
I need this time series in order to use it in EERA.
regards
_______________________________________________
sac-help mailing list
sac-help<at>iris.washington.edu
http://www.iris.washington.edu/mailman/listinfo/sac-help
-
Hello
you can also use 'saclst' command to read the time you want and then put
them in a text file:
saclst a f mydata.sac >> mydata.txt
On Tue, Jan 7, 2014 at 6:08 AM, Chad Trabant <chad<at>iris.washington.edu>wrote:
Hello Firdaus,
--
The easiest solution is to convert the SAC data to simple ASCII format and
“import” the text values into Excel.
One possibility is to use the ‘sac’ program to write the data in “SAC
alphanumeric” format, which is just ASCII. The challenge is that this data
is not easily imported into Excel due to how it is formatted (the series
spans multiple columns).
An easier possibility is to use one of many programs to convert the SAC
data to simple ASCII in a single column of data (and time stamps).
If you can compile software from source code, one such program that I
would recommended is called "sacdump” available here:
https://seiscode.iris.washington.edu/projects/sacdump
To print all the defined headers and the all the samples, you can use a
command line like this:
$ sacdump -a -D mydata.sac > mydata.txt
That command would save the output to a file mydata.txt, which can then be
easily imported into Excel.
The man page (and Wiki) contains full usage:
https://seiscode.iris.washington.edu/projects/sacdump/wiki
If you cannot compile software you should let the list know what system
you are running on for other suggestions.
regards,
Chad
On Jan 6, 2014, at 5:47 PM, Firdaus firdaus <alikomeini<at>gmail.com> wrote:
dear All
_______________________________________________
anyone knows how to extract time series in sac file to excel sheet ?
I need this time series in order to use it in EERA.
regards
_______________________________________________
sac-help mailing list
sac-help<at>iris.washington.edu
http://www.iris.washington.edu/mailman/listinfo/sac-help
sac-help mailing list
sac-help<at>iris.washington.edu
http://www.iris.washington.edu/mailman/listinfo/sac-help
-