Remove last character after last space in a string

Question

Post reply

Remove last character after last space in a string

vigneshkumart50

Ten Centuries

Points: 1205
More actions
September 22, 2014 at 3:58 am

#290214

Hi All,
I'm having string values like mentioned below.
String Values:
George, Matt J
Rambla, Tony G.
Expected Output:
George, Matt
Rambla, Tony
I would need to trim the letters like mentioned above. Can anyone help me with this

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Neil Burton SSC-Insane Points: 23015 More actions · Answer 1

declare @String as varchar(20) = 'Rambla, Tony G.'

select left(@string,len(@string)+1-charindex(' ',reverse(@string)))

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

vigneshkumart50 Ten Centuries Points: 1205 More actions · Answer 2

Is there any way I can achieve this in MS Access? I tried this and it doesn't recognize charindex.

Neil Burton SSC-Insane Points: 23015 More actions · Answer 3

There's a function called InstRev that might do it. I've never used Access in my life though so I can't be more helpful than that I'm afraid.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

BWFC (9/22/2014)
There's a function called InstRev that might do it. I've never used Access in my life though so I can't be more helpful than that I'm afraid.

Someone else answered it in the duplicate post at http://www.sqlservercentral.com/Forums/Topic1618194-131-1.aspx%5B/url%5D.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions