Hi ,
I have a requirement where I need to trim any numeric occurence in a string.
For eg: "abc2def6rg"
should be made :"abcdefrg"
The length of numeric string at any occurence is variant.
I thought Ereplace function wud help,but for this requirement it is not of much use.
Thanx,
Replace numeric string
Moderators: chulett, rschirm, roy
If you only wish to remove numeric digits from the string, you can do a . This will strip out the digits 0-9 in your string.
Code: Select all
CONVERT('01223456789','',In.String)