regular expression for Scan from String

[jin1234]

I am trying to pick out three numbers with pattern $number1:number2:number3# from a stream, for instance 8.559509#$-1.686432:-2.427051:-7.281153#$-6.160924:-1.763356:

So far, I use "Scan from String" with Format string "$%f:%f:%f #". However I don't know how to ignore/delete the items before $. Would you like to help me with that? Cheers

[billko]

You know that your sequence of numbers begins with the $ and ends with the #, so you can separate them into groups first, then separate each number out.

[jin1234]

Which function should I use to separate these according to $ and #

[jin1234]

I have solved the problem. Thank you the hint!

[GerdW]

Hi jin,

SpreadsheetStringToArray should help:

[jcarmody]

A submatch from a Match Regular Expression node can get you there: