How to manipulate strings on output

[Wexcel]

Dear experts,

Is there a way how I can manipulate text fields before they are output to a report ?

I.e. I have a field in my table that contains "example_1" and I want it to display in my report as "example: 1". So replace "_" by ": ".

I'm a newbie, can anyone indicate a way to do this ?

Thanks....

 

[Sergeant]

Can't you use the Replace() function in your query or in the report text box?
Like:
MyManipulatedString: Replace([MyFieldName], "_", ": ")
...as a query field.

 

[Wexcel]

Thanks Sergeant!

I also found my answer on how to reproduce replaced newlines from a text field, just use 'Chr(13) & Chr(10)' as the replace string.

A simple answer, but effective !