Split a string using Match Pattern function

[subhro.kb]

I am trying to split a response string from a climate chamber into different parts. The string goes something like this: 0030.0\s0034.6\s0080.0\s0083.4. I am using the match pattern function to split the string using \s as the search string. But it is not splitting the string as required. If I use only \ , its working fine. Can anyone please suggest why \s is not being recognised as a part of the input string?

Subhro.

[dan_u · Accepted solution]

Is the string you show in normal display mode or in \ codes display mode?

Anyway, if you need to match a '\' character you'll have to mask it using \, so the match string would be '\\s' to match '\s'.

Alternatively you could use spreadsheet string to array with the correct delimiter. For the data you show this would work perfectly.

[subhro.kb]

Thanks a lot! It works perfectly.

Subhro.