Re: [U2] How to Clear Empty VM marks in Field
HMMI seem to remember that if I convert a character to space with CONVERT, then did a TRIM on it (and it was just spaces), would leave one space. BUT...testing does not produce that, and does indeed remove all. Not sure where that came from? Maybe one of the flavors in the past did it and I never felt the need to reconfirm. So cool, but I'll probably still always check for to see if it's just a space after a trim, just because that's the way I've always done it :) just in case. > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Rex Gozar > Sent: Monday, January 31, 2011 2:19 PM > To: U2 Users List > Subject: Re: [U2] How to Clear Empty VM marks in Field > > George said: > >If the field were just a VM, trim would have left it there. > > Actually, if record is just a VM, TRIM(record,@VM) will trim out > the single value-mark, resulting in "" (empty field). Tested in > Universe 10.2 > > rex > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
George said: >If the field were just a VM, trim would have left it there. Actually, if record is just a VM, TRIM(record,@VM) will trim out the single value-mark, resulting in "" (empty field). Tested in Universe 10.2 rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
TRIM(expression,@VM,'T') I have not tested this but I believe the above will remove all trailing @VM characters. leaving any embedded ones. > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of George Gallen > Sent: Tuesday, 1 February 2011 6:30 a.m. > To: U2 Users List > Subject: Re: [U2] How to Clear Empty VM marks in Field > > If the field were just a VM, trim would have left it there. > > I didn't reject TRIM, I just didn't consider it (and not vehemently). > > In general, I use TRIM to eliminate extras and CHANGE/CONVERT to >eliminate ALL > > Since the original questions was to get rid of all the VM's I went with > CHANGE/CONVERT > > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann > > Sent: Monday, January 31, 2011 11:58 AM > > To: U2 Users List > > Subject: Re: [U2] How to Clear Empty VM marks in Field > > > > George, > > > > why do you so vehemently reject the TRIM or TRIMB solutions? > > I think it is the cleanest offered so far and requires the least > > coding. > > > > just my 2 pence > > > > Mecki > > > > On 31/01/2011 16:33, George Gallen wrote: > > > The only problem will be if there are multivalued data elements by > > > eliminating the VM's, it will combine into one big element. > > > > > > Maybe a subroutine to scan the string first to make sure there is > > only one > > > element, then do the elimination (by whatever method). > > > > > > ex. > > > > > > 0001: one^253two^253^253 > > > > > > will become > > > > > > 0001: onetwo > > > > > > George > > > > > >> -Original Message- > > >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > >> boun...@listserver.u2ug.org] On Behalf Of Steve Romanow > > >> Sent: Monday, January 31, 2011 11:03 AM > > >> To: U2 Users List > > >> Subject: Re: [U2] How to Clear Empty VM marks in Field > > >> > > >> I like George's solution. > > >> > > >> On 1/31/2011 9:12 AM, George Gallen wrote: > > >>> Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI > > >>> not > > >> do the job? > > >>> or FXI=CHANGE(FXI,CHAR(253),"") > > >>> > > >>> Maybe: > > >>> > > >>> EQU CLEARVM TO CONVERT CHAR(253) TO "" IN ... > > >>> ... > > >>> ... > > >>> CLEARVM FXI > > >>> > > >> ___ > > >> U2-Users mailing list > > >> U2-Users@listserver.u2ug.org > > >> http://listserver.u2ug.org/mailman/listinfo/u2-users > > > ___ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
Would TRIM not work? VAL=TRIM(VAL,@VM) Support: James F Thompson Senior Systems Analyst Cypress Business Solutions 678.494.9353 supp...@cypressesolutions.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, January 31, 2011 11:27 AM To: U2 Users List Subject: Re: [U2] How to Clear Empty VM marks in Field On 01/31/11 11:02, Steve Romanow wrote: > I like George's solution. > > On 1/31/2011 9:12 AM, George Gallen wrote: >> Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not >> do the job? >> or FXI=CHANGE(FXI,CHAR(253),"") >> >> Maybe: >> >> EQU CLEARVM TO CONVERT CHAR(253) TO "" IN >> ... >> ... >> ... >> CLEARVM FXI This would work if your data was a single non-null field with numerous null values. But if your list had more than a single non-null value this would be bad. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 "...we must choose between what is right and what is easy..." Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
On 1/31/2011 9:12 AM, George Gallen wrote: > Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not do the > job? > or FXI=CHANGE(FXI,CHAR(253),"") That would work for the original poster's specific example which has trailing value marks. It would fail badly in any other situation. Consider a string of "a": @VM: "b": @VM: @VM Convert it and your result is "ab", which is a single value. I think perhaps the best answer to the original poster's question depends upon what the true need and possible data structures are. -- Allen Egerton ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
If the field were just a VM, trim would have left it there. I didn't reject TRIM, I just didn't consider it (and not vehemently). In general, I use TRIM to eliminate extras and CHANGE/CONVERT to eliminate ALL Since the original questions was to get rid of all the VM's I went with CHANGE/CONVERT > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann > Sent: Monday, January 31, 2011 11:58 AM > To: U2 Users List > Subject: Re: [U2] How to Clear Empty VM marks in Field > > George, > > why do you so vehemently reject the TRIM or TRIMB solutions? > I think it is the cleanest offered so far and requires the least > coding. > > just my 2 pence > > Mecki > > On 31/01/2011 16:33, George Gallen wrote: > > The only problem will be if there are multivalued data elements > > by eliminating the VM's, it will combine into one big element. > > > > Maybe a subroutine to scan the string first to make sure there is > only one > > element, then do the elimination (by whatever method). > > > > ex. > > > > 0001: one^253two^253^253 > > > > will become > > > > 0001: onetwo > > > > George > > > >> -Original Message- > >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > >> boun...@listserver.u2ug.org] On Behalf Of Steve Romanow > >> Sent: Monday, January 31, 2011 11:03 AM > >> To: U2 Users List > >> Subject: Re: [U2] How to Clear Empty VM marks in Field > >> > >> I like George's solution. > >> > >> On 1/31/2011 9:12 AM, George Gallen wrote: > >>> Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not > >> do the job? > >>> or FXI=CHANGE(FXI,CHAR(253),"") > >>> > >>> Maybe: > >>> > >>> EQU CLEARVM TO CONVERT CHAR(253) TO "" IN > >>> ... > >>> ... > >>> ... > >>> CLEARVM FXI > >>> > >> ___ > >> U2-Users mailing list > >> U2-Users@listserver.u2ug.org > >> http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
Thanks to all that replied. I had coded the array loop looking for nulls and decrementing the counter. Now, I am trying Colin's reply of: FXI = TRIM(FXI,@VM) which looks to work during my initial testing. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, January 31, 2011 8:27 AM To: U2 Users List Subject: Re: [U2] How to Clear Empty VM marks in Field On 01/31/11 11:02, Steve Romanow wrote: > I like George's solution. > > On 1/31/2011 9:12 AM, George Gallen wrote: >> Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not >> do the job? >> or FXI=CHANGE(FXI,CHAR(253),"") >> >> Maybe: >> >> EQU CLEARVM TO CONVERT CHAR(253) TO "" IN ... >> ... >> ... >> CLEARVM FXI This would work if your data was a single non-null field with numerous null values. But if your list had more than a single non-null value this would be bad. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 "...we must choose between what is right and what is easy..." Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
One solution is MAXV = DCOUNT(FXI,@VM) FOR I = MAXV TO 1 STEP -1 IF FXI<1,I> = '' THEN DEL FXI<1,I> NEXT I This handles embedded nulls as well as leading and trailing nulls. This would also give you a value if there are associated fields that would need to be removed. Rich Richard Sammartino Systems Analyst School District of Philadelphia 440 N Broad Street Philadelphia, PA 19130 Phone (215) 400-5086 Fax (215) 400-4411 - Original Message - From: "Garry Smith" To: "U2 Users List" Sent: Friday, January 28, 2011 7:29:48 PM Subject: [U2] How to Clear Empty VM marks in Field FXI = 1ýý DCount(FXI,VM) returns 3 Is there function to clear the blank value marks so that FXI = 1 and then DCOUNT would return 1 TIA Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
George, why do you so vehemently reject the TRIM or TRIMB solutions? I think it is the cleanest offered so far and requires the least coding. just my 2 pence Mecki On 31/01/2011 16:33, George Gallen wrote: > The only problem will be if there are multivalued data elements > by eliminating the VM's, it will combine into one big element. > > Maybe a subroutine to scan the string first to make sure there is only one > element, then do the elimination (by whatever method). > > ex. > > 0001: one^253two^253^253 > > will become > > 0001: onetwo > > George > >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >> boun...@listserver.u2ug.org] On Behalf Of Steve Romanow >> Sent: Monday, January 31, 2011 11:03 AM >> To: U2 Users List >> Subject: Re: [U2] How to Clear Empty VM marks in Field >> >> I like George's solution. >> >> On 1/31/2011 9:12 AM, George Gallen wrote: >>> Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not >> do the job? >>> or FXI=CHANGE(FXI,CHAR(253),"") >>> >>> Maybe: >>> >>> EQU CLEARVM TO CONVERT CHAR(253) TO "" IN >>> ... >>> ... >>> ... >>> CLEARVM FXI >>> >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
The only problem will be if there are multivalued data elements by eliminating the VM's, it will combine into one big element. Maybe a subroutine to scan the string first to make sure there is only one element, then do the elimination (by whatever method). ex. 0001: one^253two^253^253 will become 0001: onetwo George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Steve Romanow > Sent: Monday, January 31, 2011 11:03 AM > To: U2 Users List > Subject: Re: [U2] How to Clear Empty VM marks in Field > > I like George's solution. > > On 1/31/2011 9:12 AM, George Gallen wrote: > > Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not > do the job? > > or FXI=CHANGE(FXI,CHAR(253),"") > > > > Maybe: > > > > EQU CLEARVM TO CONVERT CHAR(253) TO "" IN > > ... > > ... > > ... > > CLEARVM FXI > > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
That gets rid of all @VMs not just the empty trailing ones. I realize it answers the very specific example posted , but if that example was really the case being questioned I would say just use FXI=FXI<1,1,1> or count=1 I would assume that this question is really being asked about a more general situation such as FXI = 1ý2ýý In which case >> FXI=trim(FXI,@VM,'T') To remove all empty @VM delimited fields >> FXI=trim(FXI,@VM,'R') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: January 31, 2011 09:13 AM To: U2 Users List Subject: Re: [U2] How to Clear Empty VM marks in Field Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not do the job? or FXI=CHANGE(FXI,CHAR(253),"") Maybe: EQU CLEARVM TO CONVERT CHAR(253) TO "" IN ... ... ... CLEARVM FXI > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman > Sent: Friday, January 28, 2011 8:26 PM > To: U2 Users List > Subject: Re: [U2] How to Clear Empty VM marks in Field > > I suspect that there is no canned function. > > I little homemade sub could look like > > SUBROUTINE SUB.XM.Counter(FXI, XM.Count) > > XM.Count = 0 > Total.String.Length = len(FXI) > For Posn = 1 to Total.String.Length > > Next = Posn + 1 > > This.Char = FXI[Posn, 1] > Next.Char = FXI[Next, 1] > > Begin case > Case This.Char = VM ; begin case > Case This.Char = > Next.Char ; null > Case 1 ; > XM.Count += 1 >Endcase > End case > > Next Posn > > return > END > > I hope that I made no speling mistakes this time... > > --Bill > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Garry Smith > Sent: Friday, January 28, 2011 7:30 PM > To: U2 Users List > Subject: [U2] How to Clear Empty VM marks in Field > > FXI = 1ýý > > DCount(FXI,VM) returns 3 > Is there function to clear the blank value marks so that FXI = 1 > and then DCOUNT would return 1 > > TIA > > Garry L. Smith > Dir Info Systems > Charles McMurray Company > V# 559-292-5782 F# 559-346-6169 > > -Original Message- > From: Garry Smith > Sent: Friday, January 28, 2011 2:04 PM > To: 'U2 Users List' > Subject: RE: [U2] What do you do with CallHTTP? > > I tried to but we are still using AIX 4.3.3 and UV 9.6 > > Garry L. Smith > Dir Info Systems > Charles McMurray Company > V# 559-292-5782 F# 559-346-6169 > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Steve Romanow > Sent: Friday, January 28, 2011 1:29 PM > To: U2 Users List > Subject: Re: [U2] What do you do with CallHTTP? > > On 1/28/2011 1:50 PM, David Wolverton wrote: > > What uses have you found for CallHTTP for in your applications? > None whatsoever. > > Are you 'eating' someone else's data with it - like doing lookups > > against a web service call? > > > > Or are you using it to 'serve' data to others? Rocket says you can > do > > this, but I can't see how it would work offhand and would like to > know > > the scenario. > > > > How complex have you found it and how stable? > > > Too complex, not sure about stability. > > I am following someone on c.d.p's lead from 2006 and using curl. I > have also used wget in the past for a dictionary items to do a > filecheck on web images. You can use wget in --spider mode and it will > just give you back an http 200 if the file resolves, but will not > actually download it. > > Thanks for your thoughts! > > > > > > > > > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
On 01/31/11 11:02, Steve Romanow wrote: I like George's solution. On 1/31/2011 9:12 AM, George Gallen wrote: Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not do the job? or FXI=CHANGE(FXI,CHAR(253),"") Maybe: EQU CLEARVM TO CONVERT CHAR(253) TO "" IN ... ... ... CLEARVM FXI This would work if your data was a single non-null field with numerous null values. But if your list had more than a single non-null value this would be bad. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 "...we must choose between what is right and what is easy..." Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
I like George's solution. On 1/31/2011 9:12 AM, George Gallen wrote: Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not do the job? or FXI=CHANGE(FXI,CHAR(253),"") Maybe: EQU CLEARVM TO CONVERT CHAR(253) TO "" IN ... ... ... CLEARVM FXI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI not do the job? or FXI=CHANGE(FXI,CHAR(253),"") Maybe: EQU CLEARVM TO CONVERT CHAR(253) TO "" IN ... ... ... CLEARVM FXI > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman > Sent: Friday, January 28, 2011 8:26 PM > To: U2 Users List > Subject: Re: [U2] How to Clear Empty VM marks in Field > > I suspect that there is no canned function. > > I little homemade sub could look like > > SUBROUTINE SUB.XM.Counter(FXI, XM.Count) > > XM.Count = 0 > Total.String.Length = len(FXI) > For Posn = 1 to Total.String.Length > > Next = Posn + 1 > > This.Char = FXI[Posn, 1] > Next.Char = FXI[Next, 1] > > Begin case > Case This.Char = VM ; begin case > Case This.Char = > Next.Char ; null > Case 1 ; > XM.Count += 1 >Endcase > End case > > Next Posn > > return > END > > I hope that I made no speling mistakes this time... > > --Bill > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Garry Smith > Sent: Friday, January 28, 2011 7:30 PM > To: U2 Users List > Subject: [U2] How to Clear Empty VM marks in Field > > FXI = 1ýý > > DCount(FXI,VM) returns 3 > Is there function to clear the blank value marks so that FXI = 1 > and then DCOUNT would return 1 > > TIA > > Garry L. Smith > Dir Info Systems > Charles McMurray Company > V# 559-292-5782 F# 559-346-6169 > > -Original Message- > From: Garry Smith > Sent: Friday, January 28, 2011 2:04 PM > To: 'U2 Users List' > Subject: RE: [U2] What do you do with CallHTTP? > > I tried to but we are still using AIX 4.3.3 and UV 9.6 > > Garry L. Smith > Dir Info Systems > Charles McMurray Company > V# 559-292-5782 F# 559-346-6169 > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Steve Romanow > Sent: Friday, January 28, 2011 1:29 PM > To: U2 Users List > Subject: Re: [U2] What do you do with CallHTTP? > > On 1/28/2011 1:50 PM, David Wolverton wrote: > > What uses have you found for CallHTTP for in your applications? > None whatsoever. > > Are you 'eating' someone else's data with it - like doing lookups > > against a web service call? > > > > Or are you using it to 'serve' data to others? Rocket says you can > do > > this, but I can't see how it would work offhand and would like to > know > > the scenario. > > > > How complex have you found it and how stable? > > > Too complex, not sure about stability. > > I am following someone on c.d.p's lead from 2006 and using curl. I > have also used wget in the past for a dictionary items to do a > filecheck on web images. You can use wget in --spider mode and it will > just give you back an http 200 if the file resolves, but will not > actually download it. > > Thanks for your thoughts! > > > > > > > > > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
On 29/01/11 04:33, Colin Alfke wrote: > If you don't have to worry about associated fields and you're trying to > clear null attributes or you want a count of the non-null attributes then > trim is probably the easiest way (plus there are options to only clear > leading,trailing,or all): > > FXI = TRIM(FXI,@VM) I was wondering if trim could do that... But my immediate reaction was matparse, matbuild. They all strip trailing delimiters by default. > > Hth > Colin Alfke > Calgary, Canada Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
Garry, Since you described a simple situation, I'll provide a simple solution. FXI = 1ýý DCOUNT(TRIM(FXI,@VM),@VM) should return 1. Best Regards, Richard Lewis On Fri, Jan 28, 2011 at 5:29 PM, Garry Smith wrote: > FXI = 1ýý > > DCount(FXI,VM) returns 3 > Is there function to clear the blank value marks so that FXI = 1 and > then DCOUNT would return 1 > > TIA > > Garry L. Smith > Dir Info Systems > Charles McMurray Company > V# 559-292-5782 F# 559-346-6169 > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
If you don't have to worry about associated fields and you're trying to clear null attributes or you want a count of the non-null attributes then trim is probably the easiest way (plus there are options to only clear leading,trailing,or all): FXI = TRIM(FXI,@VM) Hth Colin Alfke Calgary, Canada -Original Message- From: Allen Egerton On 1/28/2011 7:29 PM, Garry Smith wrote: > FXI = 1ýý > > DCount(FXI,VM) returns 3 > Is there function to clear the blank value marks so that FXI = 1 and then DCOUNT would return 1 If your field is associated with any other fields, simply removing all value marks preceding null fields will potentially de-synchronize (is there such a word?) the relationships. That is, you can remove any trailing VMs, but not any embedded ones. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
On 1/28/2011 7:29 PM, Garry Smith wrote: > FXI = 1ýý > > DCount(FXI,VM) returns 3 > Is there function to clear the blank value marks so that FXI = 1 and then > DCOUNT would return 1 If your field is associated with any other fields, simply removing all value marks preceding null fields will potentially de-synchronize (is there such a word?) the relationships. That is, you can remove any trailing VMs, but not any embedded ones. If I were doing this, I'd start with the base rule that we're working from the end of the string and rolling backwards until we hit a character that isn't a VM, and keeping everything up to there. So, using your example of "FXI = 1ýý"; here's a code sample: 0001 fxi = "a": @vm: @vm 0002 crt "fxi = ": fxi 0003 crt "dcount = ": dcount(fxi, @VM) 0004 len.fxi = len(fxi) 0005 if (len.fxi) then 0006 for i.char = len.fxi to 1 step -1 0007 if (fxi[i.char, 1] ne @vm) then exit 0008 next i.char 0009 * 0010 if (i.char lt len.fxi) then 0011 fxi = fxi[1, i.char] 0012 end 0013 end 0014 crt "fxi = ": fxi 0015 crt "dcount = ": dcount(fxi, @VM) 0016 crt "done" 0017 stop 0018end And here's the output from it: >RUN PGMS TT fxi = aýý dcount = 3 fxi = a dcount = 1 done ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
I suspect that there is no canned function. I little homemade sub could look like SUBROUTINE SUB.XM.Counter(FXI, XM.Count) XM.Count = 0 Total.String.Length = len(FXI) For Posn = 1 to Total.String.Length Next = Posn + 1 This.Char = FXI[Posn, 1] Next.Char = FXI[Next, 1] Begin case Case This.Char = VM ; begin case Case This.Char = Next.Char ; null Case 1 ; XM.Count += 1 Endcase End case Next Posn return END I hope that I made no speling mistakes this time... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Garry Smith Sent: Friday, January 28, 2011 7:30 PM To: U2 Users List Subject: [U2] How to Clear Empty VM marks in Field FXI = 1ýý DCount(FXI,VM) returns 3 Is there function to clear the blank value marks so that FXI = 1 and then DCOUNT would return 1 TIA Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: Garry Smith Sent: Friday, January 28, 2011 2:04 PM To: 'U2 Users List' Subject: RE: [U2] What do you do with CallHTTP? I tried to but we are still using AIX 4.3.3 and UV 9.6 Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, January 28, 2011 1:29 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? On 1/28/2011 1:50 PM, David Wolverton wrote: > What uses have you found for CallHTTP for in your applications? None whatsoever. > Are you 'eating' someone else's data with it - like doing lookups > against a web service call? > > Or are you using it to 'serve' data to others? Rocket says you can do > this, but I can't see how it would work offhand and would like to know > the scenario. > > How complex have you found it and how stable? > Too complex, not sure about stability. I am following someone on c.d.p's lead from 2006 and using curl. I have also used wget in the past for a dictionary items to do a filecheck on web images. You can use wget in --spider mode and it will just give you back an http 200 if the file resolves, but will not actually download it. > Thanks for your thoughts! > > > > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org<mailto:U2-Users@listserver.u2ug.org> http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
We've long had a "strip nulls" subroutine we use to do this sort of thing. You'd have to write a program to select the records, read, strip and write out the data. Jeff Butera Sent from my iPhone On Jan 28, 2011, at 7:29 PM, "Garry Smith" wrote: > FXI = 1ýý > > DCount(FXI,VM) returns 3 > Is there function to clear the blank value marks so that FXI = 1 and then > DCOUNT would return 1 > > TIA > > Garry L. Smith > Dir Info Systems > Charles McMurray Company > V# 559-292-5782 F# 559-346-6169 > > -Original Message- > From: Garry Smith > Sent: Friday, January 28, 2011 2:04 PM > To: 'U2 Users List' > Subject: RE: [U2] What do you do with CallHTTP? > > I tried to but we are still using AIX 4.3.3 and UV 9.6 > > Garry L. Smith > Dir Info Systems > Charles McMurray Company > V# 559-292-5782 F# 559-346-6169 > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow > Sent: Friday, January 28, 2011 1:29 PM > To: U2 Users List > Subject: Re: [U2] What do you do with CallHTTP? > > On 1/28/2011 1:50 PM, David Wolverton wrote: >> What uses have you found for CallHTTP for in your applications? > None whatsoever. >> Are you 'eating' someone else's data with it - like doing lookups >> against a web service call? >> >> Or are you using it to 'serve' data to others? Rocket says you can do >> this, but I can't see how it would work offhand and would like to know >> the scenario. >> >> How complex have you found it and how stable? >> > Too complex, not sure about stability. > > I am following someone on c.d.p's lead from 2006 and using curl. I have also > used wget in the past for a dictionary items to do a filecheck on web images. > You can use wget in --spider mode and it will just give you back an http 200 > if the file resolves, but will not actually download it. >> Thanks for your thoughts! >> >> >> >> >> >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] How to Clear Empty VM marks in Field
FXI = 1ýý DCount(FXI,VM) returns 3 Is there function to clear the blank value marks so that FXI = 1 and then DCOUNT would return 1 TIA Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: Garry Smith Sent: Friday, January 28, 2011 2:04 PM To: 'U2 Users List' Subject: RE: [U2] What do you do with CallHTTP? I tried to but we are still using AIX 4.3.3 and UV 9.6 Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, January 28, 2011 1:29 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? On 1/28/2011 1:50 PM, David Wolverton wrote: > What uses have you found for CallHTTP for in your applications? None whatsoever. > Are you 'eating' someone else's data with it - like doing lookups > against a web service call? > > Or are you using it to 'serve' data to others? Rocket says you can do > this, but I can't see how it would work offhand and would like to know > the scenario. > > How complex have you found it and how stable? > Too complex, not sure about stability. I am following someone on c.d.p's lead from 2006 and using curl. I have also used wget in the past for a dictionary items to do a filecheck on web images. You can use wget in --spider mode and it will just give you back an http 200 if the file resolves, but will not actually download it. > Thanks for your thoughts! > > > > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users