MagicCell

I have a field that contains the MAC address of a device. I would like to format it so that it looks like 00a0:25bb:0412 instead of 00a025bb0412. I know you can use # to format an all numeric value. What do I use for an alpha/numeric value?

Thanks

I thought MAC address is always in format
00-a0-25-bb-04-12? Not True or it can be anything like 00a025bb0412 or 00a0:25bb:0412? To start, what raw format does the MAC address comes in to the MagicCell?

Use the MagicCell SS function to parse the string. See the following code. While testing the code (VB and C# versions), it returns the incorrect result if the string length is 'odd'. It is now fixed. But in your case - If you MAC is always coming in as even 12 digits, it'll work.




Dim LOG2 As New Tornado.z
With LOG2
.dbQP = "U=5| D=Nwind| S=2| TH = Tit=Magic SS Demo| Q=Select firstname From employees"
.dbMagicCell = "fi=0| Mac=#0:_ss=s=0~c=2#-#0:_ss=s=2~c=2#"
.ASPdbNET()
End With




Frank