Do while loop help. 1

[skurkal]

Hi All,

I am using Crystal XI and have an excel file that has the following data.

Mark
B
X
X
R
X
X
B
X
R


So what I want to do is that between the B and the R I want to change all the X's into B's until I find and R. Then mark all the X's into R's until I find a B. and so on. So the result should be


Mark
B
B
B
R
R
R
B
B
R
etc.

Any help on this would be great.
Thanks!

 

[MCuthill]

skurkal,

Create the following formula and place it on the details line.

{@FinalMark_Swapped}

[blue]WhilePrintingRecords[/blue];
[blue]StringVar[/blue] CurrentOutput;

[blue]IF[/blue] {Table.Mark} [blue]in[/blue] ["B","R"] [blue]THEN[/blue] CurrentOutput:={Table.Mark} [blue]ELSE[/blue] CurrentOutput:=CurrentOutput;

CurrentOutput;

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."