Re: [U2] Unidata Hashing

2010-09-17 Thread Dawn Wolthuis
Hi Jeff -- Yes, I suspect that is exactly what you want to do. In our code where we sign something to use with an Amazon API, we have the following two lines. [I know you know this is OO-enhanced mvbasic, using delivered libraries in Cache', but I'll indicate that here for anyone else who might oth

[U2] Unidata Hashing

2010-09-17 Thread Jeffrey Butera
I stumbled upon the DIGEST function in Unidata which happened to be what I needed - I was looking for SHA1 hashing. Is there a way to return the output as HEX instead of binary? I suppose I could use ENCODE to get Base64, but wasn't sure if there was another approach. -- Jeff Butera, Ph.D.

Re: [U2] Help in removing erroneous character from data file

2010-09-17 Thread Tony Gravagno
> From: ggayathri > In the huge amount of data, an erroneous character has > been introduced. Can someone suggest a way to remove > that character? May be a routine that would do it? This may not fit your specific scenario. On our freeware page is a utility to "Find Bad Characters". It tells y

Re: [U2] Help in removing erroneous character from data file

2010-09-17 Thread ggayathri
Another application had problem processing the file that it had pulled from my application with the data. In Line Number : 2506 a field(field comes from a UniVerse table) had a value of 11 and the application is looking for time (XX:XX:XX format) After this field all data is incorrect. Also, the l

Re: [U2] File statistics program

2010-09-17 Thread Wols Lists
On 17/09/10 08:05, Symeon Breen wrote: > Yup - twas me > > http://old.nabble.com/How-to-check-data-dictionary--ts25764186.html#a2577543 > 4 And while it doesn't count stats, there's a similar program on Pickwiki that goes the other way - you tell it what the data should be (int, char(8), whatever)

Re: [U2] File statistics program

2010-09-17 Thread Boydell, Stuart
I suspected so... Thanks much :) S -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, 17 September 2010 17:05 To: 'U2 Users List' Subject: Re: [U2] File statistics program Yup - twas me http

Re: [U2] Help in removing erroneous character from data file

2010-09-17 Thread Mecki Foerthmann
More information would be helpful. On 17/09/2010 06:10, ggayathri wrote: > I have a data file that is sent from my application(on UniVerse) to an > interfacing application. > In the huge amount of data, an erroneous character has been introduced. > Can someone suggest a way to remove that charac

Re: [U2] File statistics program

2010-09-17 Thread Symeon Breen
Yup - twas me http://old.nabble.com/How-to-check-data-dictionary--ts25764186.html#a2577543 4 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: 17 September 2010 01:28 To: U2 Users List Subject: [

Re: [U2] Help in removing erroneous character from data file

2010-09-17 Thread Symeon Breen
If you are on *nix the tr command will do this very fast. cat filename | tr -d \NNN > outputfile Where NNN is the octal character value -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ggayathri Sent: 17 September 2