Strip the last 4 characters

[IMAUser]

Hi,

Is there a way to strip off the last few characters of a string. ( In my example, I need to stroip the last 4 characters)

So the example input strings are
2276680000EUR201020971
2338810000EUR201021861

And the output I need is
2276680000EUR20102
2338810000EUR20102

I couldnt see any option in the SUBSTR function.

Any ideas ?

Many Thanks.

 

[IMAUser]

Dont worry. Found the answer with regexp_replace

 

[Dagon]

You can do it with SUBSTR using:

substr('2276680000EUR201020971', 1,
length('2276680000EUR201020971')-4)


For Oracle-related work, contact me through Linked-In.