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.

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 …

Not Nulls, spaces.

Otherwise trim would be worthless….

Mike

Mike ..

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

Don

View this thread on the forum...