Replace Comma Before & After All 13 Digit Numbers
-
I am looking to replace the comma after all 13 digit numbers in a document.
Example:
,1490998078635,End Goal:
|1490998078635|How exactly would I do that in the find & replace tool?
-
@BecauseICanTBH
I note you said replace the commaAFTERall 13 digits (in the post), yet the example you provided suggested you want to change the commaBOTHbefore and after as per the post heading.
If there are exactly 13 digits everytime then the following Replace solution should suffice.
Find What:,(\d{13}),
Replace With:\|\1\|
This is a regular expression so the Replace settings must be search mode ‘regular expression’ and have the ‘wrap around’ ticked.Give it a go and get back to us if any issues.
Terry
-
Worked! Thanks a lot!
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