How can I separate data that does not fit the required format?

Question

Joey Menicucci 2020-12-10

评论： Joey Menicucci 2020-12-12

Hello,

I'm writing a script that processes hex data from a force/torque sensor. Each reading is a row of 25 characters in the following format:

7FFBC0011FF4200000000FFFC

Every once in a while I'll get a bad reading that looks like the following:

3FFBC00ý“”“&&LL˜˜00FFFC

Note: These bad readings still have 25 characters similar to the good data.

I want to write something that will separate these rows from the rest of the data. What would be the best way to do this?

Maybe something that finds rows that have non-letter and non-integer characters?

Any help is appreciated! Thanks in advance!

Answer 1

Timo Dietz 2020-12-10

Maybe I didn't get your issue, but what about using "contains" and searching for a specific identifier?

E.g. contains([your_hex_array], '&') gives you all indices of an array containing the character '&'

Joey Menicucci 2020-12-12

I think this is the simple answer I was looking for. Thank you!