I always wished there was!
IF SUM(MAT A)=SUM(MAT B)
It works for numbers (Mostly).
Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of George Tisdale
Sent: Thursday, October 02, 2008 9:47 AM
To: Business Rules Forum
Subject: [BR_forum] Comparing arrays
Is there a quick and efficient way to compare two arrays (assuming they are equally dimensioned) other than going line by line in a loop?
If not mat a$=b$
Does not seem to work
I can create a function of course, but looking for a good solution.
George L. Tisdale, CPA
Tisdale CPA
75 Junction Square Drive
Concord, MA 01742
(978) 369-5585
IRS Circular 230 Notice: "To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. tax advice contained in this communication (including any attachments) is not intended or written to be used, and cannot be used, for the purpose of (i) avoiding penalties under the Internal Revenue Code or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein."
This electronic message transmission contains information which is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination or distribution of this communication to other than the intended recipient is strictly prohibited. If you have received this communication in error, please notify us immediately by calling (978) 369-5585 or by electronic mail (gtisdale@tisdalecpa.com) Thank you.
Post generated using Mail2Forum (http://www.mail2forum.com)
[BR_forum] RE: Comparing arrays
Moderators: Susan Smith, admin, Gabriel
-
GTISDALE at tisdalecpa...
[BR_forum] RE: Comparing arrays
Thanks guys.
One more for FNSNAP.dll
FNARRAYS(mat one$, mat TWO$) will prove true if the arrays match -the result will be the number of elements in the array
FNARRAYSN(mat one, mat two) will prove true if the arrays match -the result will be the number of elements in the array
so we can do
If not fnarrays(mat A$,mat B$) then do something caused by unmatching character arrays
If not fnarraysn(mat A,mat B) then do something caused by unmatching numeric arrays
since the arrays are in memory the loop should be fairly quick
George L. Tisdale, CPA
Tisdale CPA
75 Junction Square Drive
Concord, MA 01742
(978) 369-5585
IRS Circular 230 Notice: "To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. tax advice contained in this communication (including any attachments) is not intended or written to be used, and cannot be used, for the purpose of (i) avoiding penalties under the Internal Revenue Code or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein."
This electronic message transmission contains information which is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination or distribution of this communication to other than the intended recipient is strictly prohibited. If you have received this communication in error, please notify us immediately by calling (978) 369-5585 or by electronic mail (gtisdale@tisdalecpa.com) Thank you.
One more for FNSNAP.dll
FNARRAYS(mat one$, mat TWO$) will prove true if the arrays match -the result will be the number of elements in the array
FNARRAYSN(mat one, mat two) will prove true if the arrays match -the result will be the number of elements in the array
so we can do
If not fnarrays(mat A$,mat B$) then do something caused by unmatching character arrays
If not fnarraysn(mat A,mat B) then do something caused by unmatching numeric arrays
since the arrays are in memory the loop should be fairly quick
George L. Tisdale, CPA
Tisdale CPA
75 Junction Square Drive
Concord, MA 01742
(978) 369-5585
IRS Circular 230 Notice: "To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. tax advice contained in this communication (including any attachments) is not intended or written to be used, and cannot be used, for the purpose of (i) avoiding penalties under the Internal Revenue Code or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein."
This electronic message transmission contains information which is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination or distribution of this communication to other than the intended recipient is strictly prohibited. If you have received this communication in error, please notify us immediately by calling (978) 369-5585 or by electronic mail (gtisdale@tisdalecpa.com) Thank you.
Post generated using Mail2Forum (http://www.mail2forum.com)From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: 10/02/2008 9:56 AM
To: Business Rules Forum
Subject: [BR_forum] RE: Comparing arrays
I always wished there was!
IF SUM(MAT A)=SUM(MAT B)
It works for numbers (Mostly).
Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of George Tisdale
Sent: Thursday, October 02, 2008 9:47 AM
To: Business Rules Forum
Subject: [BR_forum] Comparing arrays
Is there a quick and efficient way to compare two arrays (assuming they are equally dimensioned) other than going line by line in a loop?
If not mat a$=b$
Does not seem to work
I can create a function of course, but looking for a good solution.
George L. Tisdale, CPA
Tisdale CPA
75 Junction Square Drive
Concord, MA 01742
(978) 369-5585
IRS Circular 230 Notice: "To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. tax advice contained in this communication (including any attachments) is not intended or written to be used, and cannot be used, for the purpose of (i) avoiding penalties under the Internal Revenue Code or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein."
This electronic message transmission contains information which is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination or distribution of this communication to other than the intended recipient is strictly prohibited. If you have received this communication in error, please notify us immediately by calling (978) 369-5585 or by electronic mail (gtisdale@tisdalecpa.com) Thank you.