Scan string

[jcarmody · Accepted solution]

[jcarmody]

Or, if you didn't really mean that they were numbers...

[*E*]

Thanks jcarmody this seems to work!

Thanks everyone for yall input also!

[*E*]

One last question

04,05,08,,,,,,2.5,1.3,2.1*E

If i only wanted to display the 2.5 which also will be updating/changing how would i alter what you post inorder to make this work? Also it may not always be in the same position at all times but it would always be after the whole numbers. for example

08,,2.5,1.3,2.1*E

[jcarmody]

One function will do it.

[*E*]

Thank you very much!

[*E*]

sorry I thought this was finished but a new issue came up I can not fix.

The example below the 2.5,1.3,2.1 will always come after the whole number.

The numbers before will be randomly generated and a double comma may come before the end of the whole numbers.

Sorry for the confusion but I didn't notice this case until after running the program several times

example

04,05,08,,10,11,,2.5,1.3,2.1*E

need to extract

04

05

08

10

11

I was able to get 04,05,08 with your first example by searching for the first     2 commas.

but as these numbers were randomly generated not all the time the first 2 commas are the end of the the array  of numbers I was trying to get.

here is another example

04,05,08,,,,,11,15,18,2.5,1.3,2.1*E

Need to extract

04

05

08

11

15

18

[jcarmody]

I used a Match Regular Expression to find the first fractional number because I can't count on the ",," any more.

[*E*]

Thanks jcarmody you have been really helpful.

Appreciate it!

[jcarmody]

You're welcome.  Do you understand everything?