DSXchange

Hi,

I have a column like QDL Marine and Static Diesel Engines (In).
Now I need to make it like QDL Marine and Static Diesel Engines (In).The length of this value differs from record to record.

I tried with convert but then it become QDL Marie ad Static Diesel Egies.

Please suggest.

Thanks,
Arnie

There's no difference between your 'before' and 'after' examples that I can see. It looks like you tried to remove all of the 'n' characters but I can't see why. Yet.

Help us out here.

Are you trying to remove the last word from the field? Is what you need actually "QDL Marine and Static Diesel Engines" in this example?

Yes sir

The trims may not be strictly needed but make this more fool-proof:
Pop quiz: what exactly is this doing?

So, Arnie... not going to take the pop quiz?

I generally don't like to give pure code solutions for things like this as I'm afraid there's no learning going on, one can simply plug it in and move on without have to actually understand how it works. I feel like I'm handing out fish rather than a fishing pole. Oh, well, hope you take the time to break it down and understand the bits so you can leverage the techniques elsewhere should the need arise.