Calculation to filtering particular line

[AndiM]

Hello hello again,

anybody knows::?

When I have the following record ( the numbers/values change in every new record created, but the order and other marks(letters etc) stays the same)...

SN:3222

E:015

19.4.2005 17:40

R:13,208 mm/s @ 23,2 Hz

V:14,224 mm/s @ 22,2 Hz

T:25,400 mm/s @ 17,6 Hz

VS:26,924 mm/s

A: 0 dB

Is there any function to get some particular line of data filtered automatically from that record even the values change, so I could make a filtering by choosing the line ?What calculation would do?

Thanks much more than a lot for anyone who can help.

[Ano Nimus]

Behind the lines in that field, you can't see 'em, but they're there, are CR signs (¶).

With "Position", you can count the how manieth ¶ is just in front of the line that you want to extract and the how manieth is just behind.

Once you determine the positions of the two ¶, you can use "Middle" to extract the text in between both.

You'd get the third line, as an example, by creating this calculation:

// Take characters from the field YourTextField

Middle ( YourTextField ;

// starting with the the 1st character behind the position of the 2nd ¶

(Position ( YourTextField ; "¶" ; 1 ; 2 ) +1 ) ;

// the number of characters equals the difference between the positions of the 2nd and the 3rd ¶

(Position ( YourTextField ; "¶" ; 1 ; 3 ) - Position ( YourTextField ; "¶" ; 1 ; 2 ) ) )

[Singlequanta]

Attached is a custom function to make your life a little easier. :)

SNIP.zip