Trim and Replace Function

[burrina]

I have almost solved this but I am missing something. The whole Forest because of the Trees thing.

I need to remove 1 final - from my string. Here is my sql.

SELECT tblmaintenance.sernu, Right([sernu],10) AS m10digit, InStr([m10digit],"-") AS [Space]
FROM tblmaintenance;

 

[stopher]

If you want to remove all instances of "-" the you can use:

Replace([sernu],"-","")

However if if your string has many instances of "-" and you only want to remove the last one then try:

StrReverse(Replace(StrReverse([sernu]),"-","",1,1))

It works like this:
- reverse the string
- replace the first instance of "-" with empty string
- reverse the string

hth
Chris

 

[CJ_London]

This code does not make sense to me

Right([sernu],10) AS m10digit, InStr([m10digit],"-") AS [Space]

I susepect you getting the position of '-' whereas I think you need the postion after so try

Right([sernu],10) , InStrRev([sernu],"-") +1)

 

[burrina]

Thanks everyone. I managed to solve it,
1.

Result: Replace([sernu],Chr(45),"")

2.

m10digit: Right([Result],10)

Thanks,