Please help - last series of characters

[tony tuso]

I have a memo field (resolution) that holds help desk resolutions in a table
called 'tickets'. At the end of the 'resolution' field, in every record,
there is the username of the person that worked on the ticket. I want to
remove all the data in that field except for the username.

Can someone point me in the right direction to try to accomplish this task?

Thanks for your time on this?

T

 

[Tom Ellison]

Dear Tony:

I recommend the following steps:

1. Add a new column to receive this name.

2. Put the name in this column.

3. Check things out thoroughly.

4. Remove the existing memo column.

5. Recreate the removed column, but perhaps with a text datatype. The memo
would probably be overkill.

Why do all this? This gives you a chance to see the existing memo along
side the new name column. You can correct the code that creates this
repeatedly without having destroyed the data on which it runs. This is a
useful caution.

This allows you to make the switch to a different datatype if desired.

A backup of your current data would be a good thing. If things go very
wrong, or if the removed data ever turns out to have contained valuable
information, you could recover it.

I have assumed that the final product will have the name in the same column
name as your existing column. I have attempted to work around this factor.

Now, the actual process of finding and separating the name may be difficult
or complex. Can you suggest a rule to use that will do this, based on what
you see in the table? It is likely you will need to experiment to find the
best methods of processing this. You could also post a number of row
endings (maybe the last 50 characters of the memo would do) so others could
help with suggestions.

With how many rows total will you be dealing?

Tom Ellison

 

[JM]

Try using left, right, mid functions