I have Spice simulation output file "Sim.txt". The data within is in a weird non-standard format (the two columns are '\t' separated):
Freq. V(output) 1.00000000000000e+000 (7.99999776894160e+001dB,1.79999988069699e+002°) 1.12201845430196e+000 (7.99999776899954e+001dB,1.79999986613982e+002°) 1.25892541179417e+000 (7.99999776907247e+001dB,1.79999984980640e+002°) 1.41253754462275e+000 (7.99999776916429e+001dB,1.79999983148001e+002°) 1.58489319246111e+000 (7.99999776927988e+001dB,1.79999981091746e+002°) 1.77827941003892e+000 (7.99999776942540e+001dB,1.79999978784591e+002°) 1.99526231496888e+000 (7.99999776960861e+001dB,1.79999976195919e+002°) 2.23872113856834e+000 (7.99999776983925e+001dB,1.79999973291382e+002°) 2.51188643150958e+000 (7.99999777012960e+001dB,1.79999970032438e+002°) 2.81838293126445e+000 (7.99999777049514e+001dB,1.79999966375842e+002°) ...
How can I import this data into 3 respective lists?
Import["Sim.txt","Table"] imports the first column correctly, but the second and third are imported as one, as text I assume, with parenthesis and units and what not.
Is there a way to
Import with a defined pattern? Or how would this be done?