String extract hexadecimal number

[lvABC]

I have device that returns multi line response where I need to extract hex number in this patten f01a.ad70.db84

The hex number will chamge, but will be in same patten (FFFF.FFFF.FFFF)

Thanks you.

[smercurio_fc]

Scan From String is your friend.

Hint: %x.%x.%x

[Chris_VH]

Exactly,

 

Message Edited by Chris_VH on 03-26-2009 01:43 PM

[lvABC]

Both of thank you for your help and point me right deriction.

Because of multi line and muti number, I had to change little bit.

Let me know if there is easier way...

Thank you again.

[smercurio_fc]

There may be an easier way. I don't quite understand what you're doing in your code. What do you mean by "multi line" and "multi number"?  I can understand the "multi line", but I don't get the "multi number". Do you mean you have more than 3 numbers per line? If so, how many. Can you provide a sample file? For multiple lines you can just use the Spreadsheet String to Array function to get your array and auto-index a for-loop.

[lvABC]

Hello smercurio_fc, thank you for help.

I am attaching Test VI. What I was looking for is way to extract hex number; in this case I was able extract IP address that get return in message. This was easy because they are in decimal format, so I made a match pattern “[0-9]+[.][0-9]+[.]+[0-9]+[.][0-9]+” (ie 10.10.10.10). But I wasn’t sure how to make pattern for hexadecimal number, I need to extract MAC Address as well; so I ask the question.

Is there a easy way to make match pattern?

Something like [0-9]or[a-f]+[.] [0-9]or[a-f]+[.] [0-9]or[a-f]+[.]

[Chris_VH · Accepted solution]

I tried removing all the "enters" with a "space" to make it one line. Then I just kept passing the remaining string through a shift register. Not sure if its more simple, just another way to do it.

 

Message Edited by Chris_VH on 03-26-2009 04:22 PM

[lvABC]

Thank you for help.

I was able to just extract the hexadecimal number by have pattern [0-9|a-f]. "[0-9|a-f]+[.][0-9|a-f]+[.][0-9|a-f]+"

This way I don't have worry about if any other data come between ip and mac address.

Thank you again for help.

🙂

[smercurio_fc]

You can also use Match Regular Expression to find your hex string:

 

Message Edited by smercurio_fc on 03-26-2009 05:02 PM

[lvABC]

Excellent!

Thank you very much