New Line

[sjc1956]

I'm needing to start a new line after each colon that comes after the words in all caps in this group of notes. I use CR 10. Thanks.

Rec Therapy Intervention: SUBJECTIVE: OBJECTIVE: Activity: Special music Lunch bunch Time: 60 min LEVEL OF PARTICIPATION/SOCIALIZATION: Appropriate Responds to conversation FIM Score: 7 Pt. Transferred 4 PLAN: continue plan of care

 

[bdreed35]

Can you post wha tthe expected output of the formula should be? Should it include all the colons?

~Brian

 

[sjc1956]

Rec Therapy Intervention:
SUBJECTIVE: (TEXT)if any
OBJECTIVE: (TEXT)
LEVEL OF PARTICIPATION/SOCIALIZATION: (TEXT)
FIM Score: (#)
Pt. Transferred 4 PLAN: (TEXT)

 

[bdreed35]

This formula should get you pretty close:

stringvar input := "Rec Therapy Intervention: SUBJECTIVE: OBJECTIVE: Activity: Special music Lunch bunch Time: 60 min: LEVEL OF PARTICIPATION/SOCIALIZATION: Appropriate Responds to conversation FIM Score: 7 Pt. Transferred 4 PLAN: continue plan of care";
stringvar output := "";
stringvar array t_array := split(input,": ");
numbervar i := 0;

for i := 1 to ubound(t_array) do
(
        if t_array[i] = UCASE(t_array[i]) then
            output := output & chr(13);
        output := output & t_array[i] & ": ";
);
output

Also, go into File, Report Options, and make sure that the proprty "Database Server is Case Insensitive" is not selected. Yo uwill need to do that in order for this formula to work. Just make sure that it doesn't mess anything else up in your report.

~Brian