Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    StrConversion (Excel 2000)

    Hi all,

    I have this code here that I was able to recieve from a measuring device, that I wanted to convert, '0f0xfxxx03'f3x?xx<x03

    I'm not sure that this code means anything, but would like to convert it to a string. or even an long format,

    Anyone?[img]/forums/images/smilies/smile.gif[/img]

    thanks,
    Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: StrConversion (Excel 2000)

    In what form do you receive this code? It already looks like a string to me.

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: StrConversion (Excel 2000)

    It comes in the form of ASCII, but I think it might be hexi-decimal
    Actually the word struture is 1 start bit, 7 bits of data, 1 parity bit set to space condition, 1 stop bit, 1200 baud.

    Darryl.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: StrConversion (Excel 2000)

    It is not hexadecimal, it might be the ascii representation of a numeric value. You will need to know how the device encodes its measurements to be able to do anything meaningful with it.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: StrConversion (Excel 2000)

    It looks to me like the port that is receiving that data is not set to expect 1 start bit, 7 data bits, 1 parity bit, and 1 stop bit.
    Legare Coleman

  6. #6
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: StrConversion (Excel 2000)

    Thanks Hans and Legare.

    As it turned out my setting on the reading unit weren't correct.

    Thanks,
    Darryl.

Posting Permissions

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