Start a new topic

Regular Expression/RegEx to remove last three characters, append a value, and prefix a value

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})

image





In the second screen shot, we are prefixing the "$" to the string.

Replacement Values = $
Values to match on = ^

image


Login or Signup to post a comment