Prev: How to assign a long text to a DocBlock via the command line?
Next: consultant needed
From: exosceleton on 7 Jun 2010 10:38
Maybe i'm just tired and thinking about this too long, but perhaps some of you can help me because i'm stuck.

I've got a (large) text file containing measurement results.

Each row contains several tab delimited values.
The problem is that some values are numerical, and some are textual (is that a word?)

I don't really care about the text, so i read the data with a combination of
'%f' and '%c' or '%5c' and then select the column's of numeric values i need.

The problem is however when the textual values do not have a fixed length.
you can't mix '%f' and '%s'

What is the best way to extract my numeric columns from the text file?

(as i said, the files are large so operations on a singe value/row/tab at a time will run into very long calculation times)

The stuff looks like this:
line1:
"[072] 28.574 445.664 0.100 -769.51 0Z 4°40.34828350 52°6.85336384 0.100 106043.581 458684.920 0.100"
line2:
"[072] 26.196 416.414 0.100 -1542.18 0[A 4°40.33766516 52°6.83895274 0.100 106031.196 458658.318 0.100"

With the "0Z" and "0[A" bit being variable.

Thanks
From: Walter Roberson on 7 Jun 2010 10:52
exosceleton wrote:

> I've got a (large) text file containing measurement results.
>
> Each row contains several tab delimited values.
> The problem is that some values are numerical, and some are textual (is
> that a word?)
>
> I don't really care about the text, so i read the data with a
> combination of '%f' and '%c' or '%5c' and then select the column's of
> numeric values i need.
>
> The problem is however when the textual values do not have a fixed length.
> you can't mix '%f' and '%s'

First you discuss using %c, which does require knowing the number of
characters ahead of time, but then you discuss using %s, which does
_not_ require knowing the number of characters ahead of time unless
there is a number after it _in the same field_ and you need the number.
Just using %s should be fine for what you described -- or, since you do
not care about the text, %*s so that the text is discarded rather than
being stored for you.
 | 
Pages: 1
Prev: How to assign a long text to a DocBlock via the command line?
Next: consultant needed