Re: [U2] Huge Dynamic Unidata file

2012-04-26 Thread Symeon Breen
Out of interest, how big is this file and how many records ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 25 April 2012 21:30 To: 'U2 Users List';

Re: [U2] Huge Dynamic Unidata file

2012-04-26 Thread Baakkonen, Rodney A (Rod) 46K
Indexes and all, 91 G with about 75 million records. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, April 26, 2012 4:08 AM To: 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata

Re: [U2] Huge Dynamic Unidata file

2012-04-26 Thread Symeon Breen
That's is pretty big, my personal experience with big files on udt was up to about 60Gig - we did use memresize no problems - but had to set the TMPPATH to another drive. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] Huge Dynamic Unidata file

2012-04-26 Thread Symeon Breen
You are of course right - in my defence it was a few years ago ;) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 26 April 2012 12:21 To: 'U2 Users List' Subject: Re: [U2] Huge

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Wols Lists
Except that CONVERT will take a from list and a to list. Much as Wil winds me up,he is spot on here. I often use that trick when validating input - if say I only want numbers I will do something like INPUT INPUTVAR JUNK = CONVERT( 01234567890, , INPUTVAR) CONVERT JUNK TO IN INPUTVAR It relies

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Greg Coelho
Thanks all! I was trying to remove both CR and LF with a CONVERT and it did not appear to be working... but when remove one item (CR or LF) at a time it does indeed work. Tony and Will - Thanks! Greg From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Date:

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Bob Witney
I use this : Bit of a sledgehammer but it works and it's quick too FOR CHARACTER = 127 TO 249 CONVERT CHAR(CHARACTER) TO '' IN THIS.MESSAGE NEXT CHARACTER Gets rid of all sorts of nasty webby characters :-) Bob -Original Message- From:

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Charles Stevenson
UV's CHANGE or EREPLACE are synonyms: EREPLACE(expression, substring, replacement [,occurrence [,begin] ] ) CHANGE (expression, substring, replacement [,occurrence [,begin] ] ) which pretty much mimic ED's Change command or Pick Editor's Replace. UV's SWAP is different: SWAP

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Allen Egerton
Convert as mentioned by others does a character by character replacement, so convert abc to def will convert all occurrences of a to d, all occurrences of b to e and all occurrences of c to f in the target string. If the to string contains less characters than the from string, then the to string

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Scott Howder
I'm jumping in so this option may have been discussed already but I think the following would also do the trick: X = ICONV(X,'MCB') Scott ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Jeff Butera
On 04/26/12 09:41, Allen Egerton wrote: ALHA.UC = ABCDEFGHIJKLMNOPQRSTUVWXYZ ALPHA.LC = OCONV(ALPHA.UC, MCL) NUMBERS = 0123456789 OKAY.PUNCTUATION.CHARS = -/() * GOOD.CHARS = ALPHA.UC: ALPHA.LC: NUMBERS: OKAY.PUNCTUATION.CHARS * * INPUT SOMETHING FROM USER BAD.CHARS = SOMETHING CONVERT

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Scott Howder
Sorry...I was a bit hasty in sending my previous response. In the case where ONLY the ^010 and ^013 characters are to be removed I'd use CONVERT as suggested. The ICONV function would remove the ^010 and ^013 characters out of the string but it may remove a bunch of other characters from the

Re: [U2] YYMMDD easy way?

2012-04-26 Thread Bill Brutzman
Fleshing it out makes it easier to read and maintain. thisYear = oconv(today, 'DY2') thisMonth = oconv(today, 'DM') thisDate = oconv(today, 'DD') yyMMdd = thisYear : thisMonth : thisDate Counting SLoCs is meaningless. Also... functional programming is out there

Re: [U2] YYMMDD easy way?

2012-04-26 Thread Charlie Noah
Hi Bill, You'll still need to make sure the month and day are zero padded to get YYMMDD. Could you explain this: /Counting SLoCs is meaningless. Also... functional programming is out there now... multiple threads... running on multiple cores. I am starting to treat variables as though

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Greg Coelho
Bob, Good idea! Currently I'm wrestling with just 2 control characters (010 and 013), but as you point out there are others that can cause trouble as well. I should create an array of Trouble Makers and just loop through them! Thanks again, Greg From: Bob Witney b...@explore.co.uk To:

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Greg Coelho
Thanks Scott for the insight... From: Scott Howder howd...@cedarville.edu To: U2 Users List u2-users@listserver.u2ug.org Date: 04/26/2012 10:16 AM Subject:Re: [U2] ASCII ^010^013 Removal (LF CR) Sent by:u2-users-boun...@listserver.u2ug.org Sorry...I was a bit hasty in

Re: [U2] YYMMDD easy way?

2012-04-26 Thread Bill Brutzman
1. SLoC = Source Lines of Code. Complaining about code bloat reminds me of the king in the Amadeus movie complaining about... too many notes. 2. Just like when .Net came out and many VB programmers moaned about the horrors of object-oriented programming... there is some fresh angst forthcoming

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Charles Stevenson
Why not, during program init, build the undesired char list once, then call CONVERT only once instead of hundreds of times each time THIS.MESSAGE needs adjusting? UNDESIRABLES = CHAR(127) FOR CHARACTER = 128 TO 249 UNDESIRABLES:= CHAR(CHARACTER) NEXT CHARACTER or for better

[U2] The CONTINUE statement

2012-04-26 Thread Wjhonson
FOR I = 1 TO X do something IF some condition THEN CONTINUE do something else NEXT I versus FOR I = 1 TO X do something IF NOT(some condition) THEN do something else NEXT I ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] The CONTINUE statement

2012-04-26 Thread Bill Brutzman
1. I do not see a continue statement in the UniVerse manual. 2. There is the exit command... used to break out of a loop... when a certain condition is satisfied. 3 The point of the original post is not clear to me. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] The CONTINUE statement

2012-04-26 Thread Wjhonson
at TCL type HELP BASIC CONTINUE -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 26, 2012 2:26 pm Subject: Re: [U2] The CONTINUE statement 1. I do not see a continue statement in the UniVerse manual. .

Re: [U2] The CONTINUE statement

2012-04-26 Thread Bill Brutzman
- || || MoreEnd Help List Commands || - ||

Re: [U2] The CONTINUE statement

2012-04-26 Thread Wjhonson
You said you had no idea what it was. How are you going to respond to the point, without knowing what the code actually does? -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 26, 2012 2:36 pm Subject: Re: [U2]

Re: [U2] The CONTINUE statement

2012-04-26 Thread Martin Braid
Here we go again. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 26 April 2012 22:39 To: u2-users@listserver.u2ug.org Subject: Re: [U2] The CONTINUE statement You said you had no idea what it was.

Re: [U2] The CONTINUE statement

2012-04-26 Thread George Gallen
If there is only one condition then that's ok (also, you will need to zero the condition Prior to do something, otherwise, it will function as an EXIT) But, if you have more than one place and/or condition in the loop that you want to jump To the next iteration, then I prefer to use

Re: [U2] The CONTINUE statement

2012-04-26 Thread Wjhonson
You mean like FOR I = 1 TO X do something IF condition1 THEN CONTINUE IF condition2 THEN CONTINUE IF condition3 THEN CONTINUE do something else NEXT I -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent:

Re: [U2] The CONTINUE statement

2012-04-26 Thread George Gallen
No more like FOR I=1 TO X Do some stuff If condition1 THEN CONTINUE Do some more stuff If condition2 THEN CONTINUE Do a little more stuff If condition3 THEN CONTINUE Do the last part of the stuff NEXT I -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] The CONTINUE statement

2012-04-26 Thread George Gallen
Of course this breaks the more than one exit point in a loop rule, but then again, Who cares about that one, since were already breaking the pseudo goto rule!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of

Re: [U2] The CONTINUE statement

2012-04-26 Thread Bill Brutzman
1. I never used the words... no idea. 2. I must have had some idea as I mentioned the exit statement. 3. the fightin' Irish... they do not know what they want... but they are ready to fight ya for it. 4. Please consider... stating the point. --Bill -Original Message- From:

Re: [U2] The CONTINUE statement

2012-04-26 Thread Wjhonson
The point is versus, compare and contrast, opine, pontificate, soapbox, et cetera -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 26, 2012 2:52 pm Subject: Re: [U2] The CONTINUE statement 1. I never used

Re: [U2] The CONTINUE statement

2012-04-26 Thread Wjhonson
You're trying to make me form an argument, and that was not my intention at all. Merely to present two contrasting forms of programming to solicit opinion. I have no argument. (Hell freezes over) -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List

Re: [U2] The CONTINUE statement

2012-04-26 Thread Paul Wilson
Some of you are PATHETIC - needing to pat your own back - wtf From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Thursday, April 26, 2012 6:19 PM Subject: Re: [U2] The CONTINUE statement You're trying to make me form an argument, and

Re: [U2] The CONTINUE statement

2012-04-26 Thread Larry Hiscock
Please don't feed the troll -- you'll only encourage it to come back for more. If we don't restore a modicum of civility to this list, we will be forced to judiciously apply the moderator tools at our disposal... Larry Hiscock Moderator -Original Message- From:

Re: [U2] The CONTINUE statement

2012-04-26 Thread dennis bartlett
Hey fella who said he didn't see a CONTINUE.. isn't the point of a user group to learn new things? I bet there are many things you've never seen - happens to me too. What I love about user groups is that, while there are a hundred good ways to achieve something, there are really clever ways, e.g.

Re: [U2] The CONTINUE statement

2012-04-26 Thread Bill Brutzman
I have always admired Peter Norton's gift for writing with clarity. If a valid definition of the word obvious... is... easy to see... It was not apparent to me... that there were two code snippets being compared to each other. Thus, I would LIKE to apologize... but I am NOT going to do so.

Re: [U2] The CONTINUE statement

2012-04-26 Thread Bill Haskett
What I'm wondering, and I probably shouldn't, is what this thread, and similar ones, are meant to be; trolling, pontificating, postulating, or just sowing the seeds of discontent? :-) Bill - Original Message -

Re: [U2] The CONTINUE statement

2012-04-26 Thread Wjhonson
If those are the only options, then *Other* Whatever happened to assuming good faith ? -Original Message- From: Bill Haskett wphask...@advantos.net To: Paul Wilson sfr192...@yahoo.com; U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 26, 2012 6:09 pm Subject: Re: [U2]

Re: [U2] The CONTINUE statement

2012-04-26 Thread dennis bartlett
ha ha, you lot _are_ funny! All programmers are wordsmiths; it's all we do all day, so collecting just the right word is something we have a penchant for... _but_ when I'm following a bug-trail thru UniVerse, via SB+, into a variety of aspx, and vb's along the way, I've certainly not got that