How to extract last 23 digits from this string
-
I have a string
6.4985424784218431045194480How can I replace the 23 digits following .49 with ;
-
@breakfreerut-rut said in How to extract last 23 digits from this string:
How can I replace the 23 digits following .49 with ;
Find What:
(\.\d\d)\d{23}
with:${1};
This is a regular expression (in case you didn’t know) and used in the Replace function you need the search mode to be regular expression.Note I took your “.49” as being representative of the first 2 digits following the DOT character “.”. If however you want a replacement ONLY if “.49” is present then the Find regex would be
(\.49)\d{23}So is the number possibly going to be longer than 25 digits after the DOT character, or maybe shorter. These would be regarded as edge cases as currently the supplied solutions may not give you exactly what you want.
Terry
-
GREAT! Thanks. The search expression worked.
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