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.

Replacement Values = $
Values to match on = ^