How to extract only numbers from complex mixed alphanumeric format

4 views (last 30 days)
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!

Answers (0)

Categories

Find more on App Building 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!