Striping Strings 1

[ganjass]

CR10
SQL2000

Hi all, i've got an issue when exporting to excel. When exporting certain fields, 2 boxes appear to the right of my fields. On further investigation the boxes are chrw(10). the problem i have is getting rid of them i've tried using replicate to change the chrw(10) to a space and split to get rid of them, but only one box dissapears, with the other still visable

Any ideas??

thanks in advance

 

[synapsevampire]

Not sure why you'd get a chr(10).

Perhaps it's in the data, if so, replace the data field with the following Crystal formula:

replace({table.field},chr(10),"")

-k

 

[ganjass]

I still have the problem of one of the chr(10) characters appearing to the right of the field, any ideas?

 

[ganjass]

replace(replace({table.field},chr(10),""),chr(13),"") did the trick as the second character was a chr(13)