Remove Special Charactors From Excel Report

Kau_147

Dear All,

I have created report in classic which is exported in Excel. Now I want to delete all the Special charators from 4-5 columns. Which is I tried but I am not able to solve.
Please help ASAP. ](*,)

Savatage

What do you mean by special charaters?

Do you just want to delete them or do you want to replace them?

For example à to A?

Else you can cleanup the field before exporting.

txtCharsToKeep := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
"My Field" := DELCHR("My Field",'=',DELCHR("My Field",'=',txtCharsToKeep));

raveendran.s

Savatage wrote:

What do you mean by special charaters?

Do you just want to delete them or do you want to replace them?

For example à to A?

Else you can cleanup the field before exporting.

txtCharsToKeep := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
"My Field" := DELCHR("My Field",'=',DELCHR("My Field",'=',txtCharsToKeep));

Nice Idea... =D>

Kau_147

Thanks for reply
But I want to replace the Special Charactor with Space.
For example :
AccountNo. : HDFC/2012/15-12/001 (Remove the '-' and replace it with ' ' space).
Like AccountNo : HDFC/2012/15 12/001

raveendran.s

Find the position of the symbol and replace with Space

Kau_147

Thanks for the reply!
This issue is resolved. \:D/ \:D/ =D>