>>I'm trying to only keep the first unique value of the GroupHeading field, blanking all others like it until I get to a different value. The code below is kicking out of the DO WHILE because the value of GroupHeading is changed by the REPLACE. I understand why, but how can I get around it?.
>>
>> SELECT WorkListXMLCursor
>> SCAN
>> m.GroupHeading = GroupHeading
>> DO WHILE GroupHeading = m.GroupHeading
>> SKIP
>> REPLACE GroupHeading WITH ''
>> ENDDO
>> ENDSCAN
>>
>
>why not replace GroupHeader with "" for GroupHeader = m.GroupHeader ?
I'm sorry, but that makes no sense to what I'm trying to do.
I start with this in the first field (there are others not listed here):
1 RECEIVER
2 RECEIVER
3 RECEIVER
4 SUBSCRIBER
5 SUBSCRIBER
6 SUBSCRIBER
7 SUBSCRIBER
8 DEPENDENT
9 DEPENDENT
10 DEPENDENT
11 DEPENDENT
12 DEPENDENT
And want this:
1 RECEIVER
2
3
4 SUBSCRIBER
5
6
7
8 DEPENDENT
9
10
11
12