Question: readdata

I have some data in some text files I want to read in with maple. 

The problem is with the format of the data ... 

090101 0354 03.46 44 30.80 110 22.07 2.37 1.17 6 90 6.3 0.14 0.7 16.0
090101 0400 09.83 44 32.24 110 21.26 2.14 1.82 7 96 4.8 0.12 0.6 12.4
090101 0401 35.95 44 32.08 110 21.61 1.98 1.12 6 90 4.7 0.14 0.8 46.9
090101 0454 43.82 44 31.98 110 21.35 0.01 0.82 7 155 5.0 0.12 0.6 0.5
090101 0519 50.87 44 31.76 110 21.41 0.42 W 2.53 9 86 5.2 0.07 0.3 0.5
090101 0529 08.46 44 31.93 110 21.25 0.08 W 2.43 8 90 5.2 0.09 0.3 0.5
090101 0602 49.17 44 31.93 110 22.25 2.06 1.31 8 83 4.3 0.09 0.4 12.4

 

Sometimes there is an extra W in the data.  When I use readdata, and it comes to a line with a W it terminates the line at that point and I only get 8 values for those lines. 

It looks like I need to use the string format and then parse the data?  or map?  or replace?  not too sure on how best to go about that.  I don't really need the W in the data.  How do I remove it?

 

Please Wait...