[RESOLVED] Removing characters from a string?

[vert]

Hello,

This is what you need

Dim MyStr As String
MyStr = Left("Xyzaaa1234567", 6)

Best Regards,
Didier.

The problem with this is that it extracts the first 6 letters. In my program only the last 7 letters are CONSTANT and I need to remove that constant letters.

[RhinoBull]

Have you tried what I posted, vert?

[smUX]

The problem with this is that it extracts the first 6 letters. In my program only the last 7 letters are CONSTANT and I need to remove that constant letters.

Actually, left() reduces the string to only its leftmost characters...the left characters will be retained and the rest removed.

However, how about you give us something to work with here...The stuff you're trying to remove, is it ALWAYS the same text, is it ALWAYS numbers, is it ALWAYS letters? If it's always the same, you can use a very simple replace() function to remove it, if it's always letters or numbers you can use a modified function (one that uses replace()) that can remove them :-)

[vert]

Actually, left() reduces the string to only its leftmost characters...the left characters will be retained and the rest removed.

However, how about you give us something to work with here...The stuff you're trying to remove, is it ALWAYS the same text, is it ALWAYS numbers, is it ALWAYS letters? If it's always the same, you can use a very simple replace() function to remove it, if it's always letters or numbers you can use a modified function (one that uses replace()) that can remove them :-)

Example:

1) michaelA12345P1
2) johnC12345P2

I want to retain the michaelA and johnC.

[DigiRev]

Then you can use the Left$() or Mid$() functions like Rhino posted.