How do I remove the first 12 characters AND drop the last character in a string?

Question

question

Cricket132 asked Jun 15, '19

my table has the following:

IDLogin1abcdefghijk\smith02abcdefghijk\roberts03abcdefghijk\canton04abcdefghijk\mortenson05abcdefghijk\anderson0

I need to see only the name, without the 0.

This following removes the first 12 characters:

select substring(loginid, 12, 11) from DBSec;

and this removes the last character

select left([LoginID], len([LoginID])-1) from DBSec;

HOW DO I COMBINE THE BOTH to get, for example:

IDNo Column Name1smith2roberts3canton4mortenson5anderson

substring left

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cricket132 commented · Jun 15, 2019 at 03:45 PM

This is my very first post so apologies if it in not in the correct format.

0 ·

Answer 1 · 2019-06-17T07:05:22Z

Kev Riley answered Jun 17, '19

simply combine the two:

substring(left([LoginID], len([LoginID])-1), 13, len(left([LoginID], len([LoginID])-1)))

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.