How to separate words and numbers in a string?

[Ouinon]

Hello everyone,
I’d like to know if it’s possible to separate words from numbers in a string.
For example, my string is: "CH0: float, CH1: float, CH2: float". I’d like to extract the float values in order to plot them in different charts.
Thanks in advance to anyone who takes the time to look into this !

To provide more context, my VI acts as a TCP server that reads messages sent by the client, which are of the format described above.

[GerdW · Accepted solution]

Hi Quinon,

---

@Ouinon wrote:

I’d like to know if it’s possible to separate words from numbers in a string.
For example, my string is: "CH0: float, CH1: float, CH2: float". I’d like to extract the float values in order to plot them in different charts.

---

Yes, it's possible.

1. Use SpreadsheetStringToArray with "," (comma) as separator to change the string into an array of strings.
2. Parse each string element with ScanFromString and the format string "CH%d: %f" to get the channel number and the float value.

What have you tried and where are you stuck?

[altenbach · Accepted solution]

---

@Ouinon wrote:

For example, my string is: "CH0: float, CH1: float, CH2: float".

---

the only "numeric" in your example string are 0, 1, and 2.

If the "float" in you string are numbers, and the "trimmings" are always the same, all you needs is the following:

[Ouinon]

Thank you altenbach !

Your solution is simple so perfect for me 🙂