COUNT incorrect after deleting AMV field (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== COUNT incorrect after deleting AMV field (AREV Specific) ====
=== At 13 AUG 2001 11:43:38AM Heidi Korell wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I have an AMV group where the last AMV field in the group is a Processed Date.  This date gets manually filled in once an installment is processed.  I have a symbolic that looks at the Processed Date and counts the # processed.  If a user deletes a Processed Date, the symbolic does not count correctly.  When I EDIT the record, there is still an @VM character at the end.



Example:



12069²12100²



The above example is where there were three dates, but the last one was deleted.  However, it is still counting three.
</QUOTE>
----

=== At 13 AUG 2001 01:17PM Carl Johnson wrote:  ===

<QUOTE>Yes, this does happen.  Depending on your view point it can be a good thing sense it tells you that someone manually deleted the data in the field.



To correct your count in the symbolic you'll need to account for the null value.  If you are enumerating the number of values by using:



Count(myArray,@VM) + 1



Change the code to:



Count(myArray,@VM) + (myArray # '')



This will add 1 to the count when there is a value and 0 when there is not.  

</QUOTE>

----

=== At 13 AUG 2001 01:42PM Heidi Korell wrote:  ===

<QUOTE>Carl,



That works great.  Thanks for your help!



Heidi Korell

</QUOTE>

----

=== At 13 AUG 2001 02:03PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Counting AMV's..

Your solution will work if counting a list which is deleted from the end, however, if the user is allowed to delete from the middle then it fails:

For example

Data=123@vm:@vm:456 should probably return 2 rather than 4 values.  This is one way to correct for this:

k1=count(yourfield@vm)+(yourfield # '') ;* accounts for no @vm

knt-0

for i=1 to k1

 if yourfield # '' then knt+=1

next i

@ans=knt



Don Miller

C3 Inc.

</QUOTE>

----

=== At 13 AUG 2001 05:19PM Mike Ruane wrote:  ===

<QUOTE>For getting rid of extraneous delimiters, How about this:



convert @vm to ' ' in string

string=trim(string)

convert ' ' to @vm in string



(only works when data has no ' ' in it, obviously, but it's very fast...



Mike

</QUOTE>

----

=== At 14 AUG 2001 09:32AM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Mike ..

Maybe I'm missing something

Convert @vm to '' IN String  ;* converts @vm to null

String=Trim(String)          ;* get rid of spaces

Convert '' to @vm in String  ;* ?????

For example:

'ABC'@VM:@VM:'DEF' becomes 'ABCDEF'

* now where does the @VM go???

I understand that Convert @vm to '|' (vertical bar) in String would work ..

but nulls???

Don M.

Oh well, maybe something got stripped out ...

</QUOTE>

----

=== At 14 AUG 2001 10:10AM Mike Ruane wrote:  ===

<QUOTE>Not Nulls, spaces.



Otherwise trim would be worthless....



Mike

</QUOTE>

----

=== At 14 AUG 2001 12:03PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Mike ..

Spaces work for me.  Pretty quick too!  Neat..

Don

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=0F0A47472FD995A085256AA7005664A2|View this thread on the  forum...]]