parse numbers from .lst file

[eMKay]

Hi,

I have a .lst file with a text and numbers in different lines.

Now I'm trying to read the floating point number from a specific line.

I'm using the "read from spreadsheet" function and have a "index array" function connected to the all rows outlet.

But it doesn't read anything. 

[mallyaprs]

Hi,

Try using read from binary file. Try finding the number of lines using match pattern (\n\r,\n,\r..) then use it to create an arrary of individual lines using "Pick line" primitive from string pallete in a for loop. This will finally give u an array of individual lines. Hope this is what you are looking for.

[jcarmody]

Posting what you have is worth a thousand words.  I'm not sure I understand what you want.

[Ray.R]

What delimiter are you using to seperate the numbers from the non-numeric characters?

Can you post the file?

[Ray.R]

The code snippet below should work for most cases, unless your text follows the numbers or if you have text after your number.  You can easily modify the code to cure that..

 

Message Edited by Ray.R on 12-09-2009 08:13 AM

[Ray.R]

Here's the content of the test file I was using:

i want to 123.12
read 333.232
this  2121.86
line 555.1212
here 31.67
not  98.89
this one 999.333

When I ran it, I entered 'here' as the text to search (control on front panel).