i have a string month one character long (1234567890AB) that I want to convert into a decimal month (123456789,10,11,12)

[ahhah]

 i have a string month which is one character long (1234567890AB) that I want to convert into a decimal month (123456789,10,11,12)

[smercurio_fc]

Did you look in the String palette at the conversion functions?

 

Is your 0 -> 10 a typo, or is it actually supposed to be that?

[RVL2010]

There are two functions called Decimal String to Number and Hexadecimal String to Number (on Function -> String -> String/Number Conversion)

[ahhah]

1=Jan=1, 2=Feb=2, 3=...9=Sep=9, 0=Oct=10, A=Nov=11, B=Dec=12.

I can do it using "matching regular expression" vi but I'm wondering if there's an easier way.  The decimal and hex conversion will screw up at the 0 =10.

Thanks

[Matthew_Kelton · Accepted solution]

I see two easy ways to do this.  After doing the hex to number conversion, you can do a case statement for the value.  For the default case, just pass though the value.  For case 0, pass out 10, for case 10, 11 (A, B) increment the value before passing it out.

The other option is have the data type for the hex conversion be an I32 and index an array.  The array will just be out of order [10, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12].

[smercurio_fc]

Well, there's always the simple lookup method:

Should there another papal decree to change the calendar, then you'd have some problems. Until then, though, you're probably safe...

[RavensFan]

You might want to make a 1-D array of those characters, and do a search 1-D array.  If you set up the 1-D array correctly, the returned index will be your month number.

[JÞB]

---

@ahhah wrote:

1=Jan=1, 2=Feb=2, 3=...9=Sep=9, 0=Oct=10, A=Nov=11, B=Dec=12.

I can do it using "matching regular expression" vi but I'm wondering if there's an easier way.  The decimal and hex conversion will screw up at the 0 =10.

Thanks

---

Time to break out a custom Strict Type Ring

[ahhah]

Thanks.  All great suggestions!