Regular Expression Replace
-
Hi
I have a .csv text file where monetary values for amounts of 1000 or more are displayed as 1 150.00 with a space a a thousands separator. I need to import these files into Excel and need to correct the money values. I can find the entries with a regular expression as [0-9] [0-9], but can’t figure out what to enter into rhe replace field. to change: ‘1 150.00’ to ‘1150.00’.
Any help, thanks,
Peter -
@Peter-Heesen said in Regular Expression Replace:
[0-9] [0-9]
given the example, make two capture groups in find what like:
([0-9]) ([0-9])
and use in replace the captured groups like::$1$2that will get rid of the space in between.
If this does work for you file depends on the exact data you are having. -
@Ekopalypse said in Regular Expression Replace:
([0-9]) ([0-9])
Thank you, yes. That works perfectly.
I’m really grateful/
Rgds, Peter
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login