Deleting Certain Words in a Free Form Field 1

[NavyFederalDetta]

I would like to suppress certain words from a free form field. Ex., we have an application that has an auto-fill for the initial step ("0 EM:"). I would like to suppress just that value throughout the field but leave all other text in tact. Is there a formula I can write in order to accomplish this?

Thank you!!!

 

[Madawc]

Yes, do a replace in a formula field and then display that field. E.g.

Replace({your.field}, "0 :PEM:", "")

This can also be used to turn it into something else, say

Replace({your.field}, "0 :PEM:", "[Auto-Fill]")

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[NavyFederalDetta]

Thank you!! Is there a code for a hard return? It actually reads
0
EM: (text)...

I was able to get rid of the "EM:" part but not in connection with the 0.

 

[Madawc]

Try Chr(10) and Chr(13)

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[NavyFederalDetta]

Crystal doesn't like this. I get messages like "the ) is missing," .

I am writing Replace ({HPD_HelpDesk.Work Log}, "0" chr (13), "")

If I include it in the quotes it looks for that exact string. If I don't I get the error message.

any ideas?

Thank you!

 

[h0h0h0]

try \n

 

[NavyFederalDetta]

I just decided to set up two separate formulas. The first one takes out the "O", the second one uses the first one then takes out the "EM:".

Thank you for all your assistance!!

 

[NavyFederalDetta]

Replace ({HPD_HelpDesk.Work Log}, "0"+chr (10)+"EM: Added to by NetCmmnd, ", "")

This got rid of the blank line that I was struggling with. Chr (10) is "new line".


above is the final code used and it worked like a charm!!