I want to replace only the first and last occurance of a string.
For the first occurance i am using Ereplace command.
Code: Select all
Ereplace(colname,"A",'')
Code: Select all
I/P : dbklasasaaada
O/P : dbklsasaaad
Moderators: chulett, rschirm, roy
Code: Select all
Ereplace(colname,"A",'')
Code: Select all
I/P : dbklasasaaada
O/P : dbklsasaaad
Code: Select all
If Right(InLink.TheString,1) = "X" Then Left(InLink.TheString,Len(InLink.TheString)-1) : "Y" Else InLink.TheString