Remove string value

[Anna_10]

Hi, 

My current board have data counting number as example below. The data will have number starting 1 until 10 and will loop until vi stop. I want to remove the counting number in the data string (bold character below) and remain the (0.3456) value as data output.

Current string : 1.0.3456

                         2.0.3456

                         3.0.3456

                         4.0.3456

                         5.0.3456

                         6.0.3456

                         7.0.3456

                         8.0.3456

                         9.0.3456

                         10.0.3456

Thank you.

[GerdW · Accepted solution]

Hi Anna,

you really should implement a better string formatting when separating numeric values!

Suggestion:

[raphschru · Accepted solution]

Hi,

You can use a combination of "Spreadsheet String to Array" and "Match Pattern" to remove the unwanted prefix from your string:

But as said GerdW, maybe the initial formatting could be improved to prevent mixing value separators with decimal separators.

Regards,

Raphaël.

[Anna_10]

Thank you for your help. Really appreciate !