How to extract only numbers from complex mixed alphanumeric format
2 views (last 30 days)
Show older comments
The file has a massive header, followed by 7 column data blocks, interbedded with more aphabetic/non-numeric characters.
Need to extract data only into some formatted mat file structure
Example:
{
"SampleRate": 150.0,
"Length": 4096,
"Start": 5,
"End": 900,
"Step": 2000,
"TappingFunction": "BLACKMAN_NUTTALL"
}
]
}
>=DEFINEMEAS
REFLAT=49:51:47.401
REFLONG=84:15:01.923
REFELEV=437
>HMEAS ID=11.001 CHTYPE=HX >HMEAS ID=12.001 CHTYPE=HY >HMEAS ID=13.001 CHTYPE=HZ >EMEAS ID=14.001 CHTYPE=EX >EMEAS ID=15.001 CHTYPE=EY >HMEAS ID=21.001 CHTYPE=HX >HMEAS ID=22.001 CHTYPE=HY >HMEAS ID=23.001 CHTYPE=HZ >EMEAS ID=24.001 CHTYPE=EX >EMEAS ID=25.001 CHTYPE=EY
>=MTSECT
SECTID=SPLINE
NFREQ=63
HX=11.001
HY=12.001
HZ=13.001
EX=14.001
EY=15.001
>!**** FREQUENCIES **! >FREQ // 63 1.040E+04 8.800E+03 7.200E+03 6.000E+03 5.200E+03 4.400E+03 3.600E+03 3.000E+03 2.600E+03 2.200E+03 1.800E+03 1.500E+03 1.300E+03 1.100E+03 9.000E+02 7.765E+02 6.353E+02 5.294E+02 4.588E+02 3.882E+02 3.176E+02 2.647E+02 2.294E+02 1.941E+02 1.588E+02 1.324E+02 1.147E+02 9.706E+01 7.941E+01 6.618E+01 5.735E+01 4.453E+01 3.771E+01 3.250E+01 2.750E+01 2.250E+01 1.875E+01 1.625E+01 1.375E+01 1.125E+01 9.375E+00 8.125E+00 6.875E+00 5.625E+00 4.688E+00 4.063E+00 3.438E+00 2.813E+00 2.344E+00 2.031E+00 1.719E+00 1.406E+00 1.172E+00 1.016E+00 8.594E-01 7.031E-01 5.859E-01 5.078E-01 4.297E-01 3.516E-01 2.975E-01 2.516E-01 2.129E-01
>!**** ROTATION ANGLES **! >ZROT NFREQ=63 // 63 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00 0.000E+00
>!**** IMPEDANCES **! >ZXXR NFREQ=63 ROT=ZROT // 63 1.088E+02 1.056E+02 1.023E+02 9.996E+01 9.851E+01 9.726E+01 9.629E+01 9.580E+01 9.563E+01 9.565E+01 9.595E+01 9.649E+01 9.708E+01 9.797E+01 9.935E+01 1.006E+02 1.027E+02 1.050E+02 1.068E+02 1.089E+02 1.106E+02 1.113E+02 1.114E+02 1.110E+02 1.099E+02 1.083E+02 1.061E+02 1.015E+02 9.184E+01 7.844E+01 6.538E+01 3.995E+01 2.393E+01 1.119E+01 -1.190E+00 -1.395E+01 -2.427E+01 -3.188E+01 -4.022E+01 -4.883E+01 -5.496E+01 -5.860E+01 -6.179E+01 -6.431E+01 -6.535E+01 -6.536E+01 -6.453E+01 -6.255E+01 -6.006E+01 -5.781E+01 -5.499E+01 -5.147E+01 -4.827E+01 1.000E+32 1.000E+32 1.000E+32 1.000E+32 1.000E+32 1.000E+32 1.000E+32 1.000E+32 1.000E+32 1.000E+32
Thanks in advance!
0 Comments
Answers (0)
See Also
Categories
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!