Abbreviating in Crystal Reports 1

[12345ITguy]

Hi Guys,

I have a more difficult question than last time, I am wanting to abbreviate data in a crystal report using a formula, ie.

North
South West
South South West
East

Then in the report I would like it to display

N
SW
SSW
E

Any help is appreciated!

Thanks,

 

[IanWaterman]

Provided you know all permutations. Then use a formula like

If Field = 'North' then 'N' else
If Field = 'South' then 'S' else
.....


Ian

 

[Madawc]

If there are many combinations, you could use SPLIT to separate the words, UBOUND to count them and LEFT to get the first character.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

Use a formula like this:

stringvar array x := split({table.field}," ");
numbervar i;
numbervar j := ubound(x);
stringvar y := "";
for i := 1 to j do(
y := y + x[1]
);
y

-LB

 

[12345ITguy]

Thanks for the great tips, this forum is the best!