Results 1 to 2 of 2

Thread: MagicCell

  1. #1
    Join Date
    Oct 2002
    Posts
    28

    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

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •