From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.


Showing results for 
Search instead for 
Did you mean: 

String extract hexadecimal number

Go to solution

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.

0 Kudos
Message 1 of 10

Scan From String is your friend. Smiley Wink


Hint: %x.%x.%x

Message 2 of 10




Message Edited by Chris_VH on 03-26-2009 01:43 PM
Chris Van Horn
Applications Engineer
0 Kudos
Message 3 of 10

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.


0 Kudos
Message 4 of 10
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.
0 Kudos
Message 5 of 10

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 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]+[.]

0 Kudos
Message 6 of 10
Accepted by topic author lvABC

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
Chris Van Horn
Applications Engineer
Message 7 of 10

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.


0 Kudos
Message 8 of 10

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



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


Thank you very much

0 Kudos
Message 10 of 10