Re: How can I import a file wiht a space as a separator?
- To: mathgroup at smc.vnet.net
- Subject: [mg129416] Re: How can I import a file wiht a space as a separator?
- From: "Hans Michel" <hmichel at cox.net>
- Date: Fri, 11 Jan 2013 22:26:24 -0500 (EST)
- Delivered-to: l-mathgroup@mail-archive0.wolfram.com
- Delivered-to: l-mathgroup@wolfram.com
- Delivered-to: mathgroup-newout@smc.vnet.net
- Delivered-to: mathgroup-newsend@smc.vnet.net
- References: <20130111024157.2E79C6930@smc.vnet.net>
David:
In Mathematica version 9
Using examples from the PDF file in the link:
Example 4:
# GHZ S RI R 50.0
!freq RelS11 ImS11 ReS21 ImS21 ReS12 ImS12 ReS22 ImS22
1.0000 0.3926 -0.1211 -0.0003 -0.0021 -0.0003 -0.0021 0.3926 -0.1211
2.0000 0.3517 -0.3054 -0.0096 -0.0298 -0.0096 -0.0298 0.3517 -0.3054
10.000 0.3419 0.3336 -0.0134 0.0379 -0.0134 0.0379 0.3419 0.3336
To import in Mathematica I saved the data to a file
In[10]:= Import["E:\\Stuff\\touchstone4.txt", "Table", "HeaderLines"->2,
"FieldSeparators"->{" ","\t"}]
Out[10]=
{{1.,0.3926,-0.1211,-0.0003,-0.0021,-0.0003,-0.0021,0.3926,-0.1211},{2.,0.35
17,-0.3054,-0.0096,-0.0298,-0.0096,-0.0298,0.3517,-0.3054},{10.,0.3419,0.333
6,-0.0134,0.0379,-0.0134,0.0379,0.3419,0.3336}}
Example 5:
# GHZ S MA R 50
5.00000 0.60 161.24 0.40 -42.20 0.42 -66.58 0.53 -79.34 !row 1
0.40 -42.20 0.60 161.20 0.53 -79.34 0.42 -66.58 !row 2
0.42 -66.58 0.53 -79.34 0.60 161.24 0.40 -42.20 !row 3
0.53 -79.34 0.42 -66.58 0.40 -42.20 0.60 161.24 !row 4
6.00000 0.57 150.37 0.40 -44.34 0.41 -81.24 0.57 -95.77 !row 1
0.40 -44.34 0.57 150.37 0.57 -95.77 0.41 -81.24 !row 2
0.41 -81.24 0.57 -95.77 0.57 150.37 0.40 -44.34 !row 3
0.57 -95.77 0.41 -81.24 0.40 -44.34 0.57 150.37 !row 4
7.00000 0.50 136.69 0.45 -46.41 0.37 -99.09 0.62 -114.19 !row 1
0.45 -46.41 0.50 136.69 0.62 -114.19 0.37 -99.09 !row 2
0.37 -99.09 0.62 -114.19 0.50 136.69 0.45 -46.41 !row 3
0.62 -114.19 0.37 -99.09 0.45 -46.41 0.50 136.69 !row 4
To import in Mathematica I saved the data to a file
In[11]:=
Import["E:\\Stuff\\touchstone5.txt","Table","HeaderLines"->1,"FieldSeparator
s"->{" ","\t","!row"}]
Out[11]=
{{5.,0.6,161.24,0.4,-42.2,0.42,-66.58,0.53,-79.34,1},{0.4,-42.2,0.6,161.2,0.
53,-79.34,0.42,-66.58,2},{0.42,-66.58,0.53,-79.34,0.6,161.24,0.4,-42.2,3},{0
.53,-79.34,0.42,-66.58,0.4,-42.2,0.6,161.24,4},{6.,0.57,150.37,0.4,-44.34,0.
41,-81.24,0.57,-95.77,1},{0.4,-44.34,0.57,150.37,0.57,-95.77,0.41,-81.24,2},
{0.41,-81.24,0.57,-95.77,0.57,150.37,0.4,-44.34,3},{0.57,-95.77,0.41,-81.24,
0.4,-44.34,0.57,150.37,4},{7.,0.5,136.69,0.45,-46.41,0.37,-99.09,0.62,-114.1
9,1},{0.45,-46.41,0.5,136.69,0.62,-114.19,0.37,-99.09,2},{0.37,-99.09,0.62,-
114.19,0.5,136.69,0.45,-46.41,3},{0.62,-114.19,0.37,-99.09,0.45,-46.41,0.5,1
36.69,4}}
You can try "Table" with the Import options tweaked to your format.
Hans
-----Original Message-----
From: David Kirkby [mailto:drkirkby at gmail.com]
Sent: Thursday, January 10, 2013 8:42 PM
To: mathgroup at smc.vnet.net
Subject: [mg129416] How can I import a file wiht a space as a separator?
You might see from my previous post I'm looking for a function to read a
Touchsone file format, which is defined by this "draft" standard,
http://vhdl.org/ibis/connector/touchstone_spec11.pdf
which has been draft for 30 years, but is still used as the standard. The
main point is a header (which I can skip), but then 9 data points on each
line, but with a space separating them, so not something simple like a
comma. Every attmpt I've made so far to read these in results in one string
per line, rather than 9 data points per line.
Dave
- References:
- How can I import a file wiht a space as a separator?
- From: David Kirkby <drkirkby@gmail.com>
- How can I import a file wiht a space as a separator?