How to extract only numbers from complex mixed alphanumeric format

2 ビュー (過去 30 日間)
Vlad Kaminski
Vlad Kaminski 2017 年 11 月 27 日
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 件)

カテゴリ

Help Center および File ExchangeText Files についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by