format text part in colour

• Jul 16, 2018

• #2

lbass

Technical User

Feb 9, 2002

32,818

US

Are you trying to color the first segment red? Or are you trying to color any segment that equals ‘xxxx’ red?

-LB

 

Upvote 0 Downvote

• Jul 17, 2018

• Thread starter
• #3

mart10

MIS

Nov 2, 2007

394

GB

sorry should have made much clearer, its the first segment - should always be 4 characters but to be safe upto the first space

 

Upvote 0 Downvote

• Jul 17, 2018

• #4

lbass

Technical User

Feb 9, 2002

32,818

US

Break the field into two sections by creating two formulas:

//{@firstsegment}:
stringvar array z := split({table.textfield}," ");
z[1]

//{@remaining}:
stringvar array z;
numbervar i;
stringvar y;

for i := 2 to ubound(z) do(
y := y + z+" "
);
y

Drop these into a text box, adding one space between. Then right click->format text and select the first segment and format it to red. Repeat for the other formula in the text box.

-LB

 

Upvote 0 Downvote

• Jul 24, 2018

• Thread starter
• #5

mart10

MIS

Nov 2, 2007

394

GB

Hello

sorry taken while t get back

The first formula worked and created correct data xxxx

the second formula returned nothing at all

//{@remaining}:
stringvar array z;
numbervar i;
stringvar y;

for i := 2 to ubound(z) do(
y := y + z+" "
);
y

 

Upvote 0 Downvote

• Jul 24, 2018

• #6

lbass

Technical User

Feb 9, 2002

32,818

US

It worked properly when I tested it, but try defining z again in the second formula:

//{@remaining}:
stringvar array z := split({table.textfield}," ");
numbervar i;
stringvar y;

for i := 2 to ubound(z) do(
y := y + z+" "
);
y

-LB

 

Upvote 0 Downvote