VB Script and Field Marks (OpenInsight 32-bit Specific)
At 10 JAN 2011 04:01:09PM Brad Bishop wrote:
I'm using VBscript to check data within OInsight. Setting up the Oengine and the associated queue was fairly easy. The procedure the script is executing is also used within the OI app, so I can't (and don't want to create a 2nd instance) change it for the VB interface. The data being returned has multiple field marks in it and I need to be able to separate the data into it's respective fields. The command "a=Split(RetData,uvFM)" correctly splits the data into the variable array "a" as long as I pull the uvFM (field mark)from the data ("uvFM=mid(RetData,6,1)"). This requires that I know the exact location of at least 1 field mark. However, I cannot guarantee this in the live data.
The Field mark seems to come back as UTF8 -3842 and a value mark seems to be UTF8 -3843. Does anyone know how to define the UTF8 field mark within VBScript ?
At 11 JAN 2011 09:05AM Jared Bratu wrote:
The ChrW() and AscW() VBScript functions should allow you to assign and retrieve the UTF-8 value of a character. See http://msdn.microsoft.com/en-us/library/ws6aa3sf(VS.85).aspx
At 11 JAN 2011 01:42PM Brad Bishop wrote:
Thanks Jared
chrW(-3842) got the job done.