Remove text from field

[Vinny Stabbone]

I have a field which is the result of a calculation (a listing of all the tables in the database file) whose result is as follows:

Application

FTP

Passwords

Web Admin

If I wanted to delete "Passwords" from the list, what script would I use? I tried to Substitute "" for Password, but all that leaves me with a blank line as is the following:

Application

FTP

Web Admin

Any assistance you could offer would be appreciated.

Mark

[Lee Smith]

How was this "List" obtained. i.e., is it the result of a calculation, manually imputed, etc.?

If it it just text, then you might try

Substitute (YourField; "Password ¶", "")

Lee