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.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto: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
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
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
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=FXI1,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.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto: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
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
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
One solution is MAXV = DCOUNT(FXI,@VM) FOR I = MAXV TO 1 STEP -1 IF FXI1,I = '' THEN DEL FXI1,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 gar...@charlesmcmurray.com To: U2 Users List u2-users@listserver.u2ug.org 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
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
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
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),) snip 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
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
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
George said: If the field were just a VM, trim would have left it there. Actually, if recordx is just a VM, TRIM(recordx,@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
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 recordx is just a VM, TRIM(recordx,@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
[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
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 gar...@charlesmcmurray.com 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
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 gar...@charlesmcmurray.comwrote: 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