03-05-2009 05:06 PM - edited 03-05-2009 05:09 PM
Hi everyone,
I got another more complicated one here.
I need to split '+0,+0.00000000E+000, -4.76517000E+001,-4.64744200E+001,-6.18140500E+001,-5.93055600E+001' by ',' into an array without '+0,+0.00000000E+000'.
I am using a regular expression as '[+-]([0-9]+[1-9]+)[E][+]\d' but it failed to, just wondering what is happening there.
Any idea is well appreciated,
Thanks,
+Kunsheng
Solved! Go to Solution.
03-05-2009 08:14 PM
03-05-2009 08:24 PM
First, don't bother with regular expressions. Use the function Spreadsheet String to Array with a commas as the delimiter, %f as the format string, a 1D array of floats as the array type. Next, delete the first two elements from the results and you're done.
Mike...