How to extract only numbers from complex mixed alphanumeric format

1 visualizzazione (ultimi 30 giorni)
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!

Risposte (0)

Community Treasure Hunt

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

Start Hunting!

Translated by