How to extract only numbers from complex mixed alphanumeric format
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (0)
Siehe auch
Kategorien
Mehr zu Text Files finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!