Regular Expression/RegEx to remove last three characters, append a value, and prefix a value
T
Tiffany Theissen
started a topic
over 10 years ago
A client passed this one on to me today. She needed to turn "863911.75" into "$863911;" without the " "
This could be used for other things. Hope you find it helpful!
-Tiffany
In the first screen shot, we are removing the last three characters from the incoming data ".75" and replacing them with a ";". You could easily replace it with BLANK instead.
Replacement Values = ; Values to match on = \.(\d{2})
In the second screen shot, we are prefixing the "$" to the string.
Tiffany Theissen
This could be used for other things. Hope you find it helpful!
-Tiffany
In the first screen shot, we are removing the last three characters from the incoming data ".75" and replacing them with a ";". You could easily replace it with BLANK instead.
Replacement Values = ;
Values to match on = \.(\d{2})
In the second screen shot, we are prefixing the "$" to the string.
Replacement Values = $
Values to match on = ^