Hi folks, I hope this is a simple solution. I've look in the manuals and googled for the solution and I could not find what I was looking for. Here is my situation. I have a note field in the SQL database that has multiple sentences. However, at the end of each sentences there will be a "[user_name]" without quotes. I would like to be able to trim out the user_name on the report. How do I do this?

I appreciate your time and effort on this matter.

We are trying to create a media report, but do not want to give out to the public the user names.

Let me rephrase the issue, here is an example of the note field content: White male subject was last seen wearing blue pants, white shirt with a baseball cap. [KEWLRAY]

So, I need to redact the word between the brackets inside the note field. I thought TRIM would work, but I do not see any solutions on the net for that. The bracket is just a stamp to track users who enters descriptive notes. It is not a field itself.

I will try your solution Kewlray...Thanks.



Edited by gilinnc - 30 Sep 2013 at 2:05pm

since it is always at the end you can use a left() and instr() together as another solution

That's perfect, I have been looking throught the formula language reference and I did not think Left would work.  I have a long way to go.

Edited by gilinnc - 01 Oct 2013 at 5:43am