Substrinng without "/"

[Anamika22]

• I have strings as /progresstalk/qad/progress and /progress/qad/forum/ i want text without "/".I don't know the length of string.Using index i' able to get positions of "/".How can we write code for this.

 

[RealHeavyDude]

Could this

TRIM ( expression [ , trim-chars ] )

do what you want to do - assuming your want to get rid of the last forward slash ?

Heavy Regards, RealHeavyDude.

 

[Anamika22]

No.From above string I need output like "progresstalkqad" and "progressqa".

 

[LarryD]

REPLACE(mystring,"/","").

Is that what you are looking for?

 

[Anamika22]

I don't know length of the string before "/" and after "/".I need all characters which comes before "/" and 2 characters which comes after "/".

 

[TomBascom]

The INDEX() and SUBSTRING() functions are your friends.