Conditional replacing
-
Hello everyone!
I have a .txt file separated with commas (,). In some cases, there is a field containing data like “7,5 cm”, making an extra field. How can i replace the commas with dots to avoid extra fields, but don’t replacing the separators?
Thank you!
-
by using a regular express like
find what:(\d+)(,)(\d+) replace width: $1\.$3
Means it is looking for any number of digits followed by a comma and again digits
To find out more about regular expression I would recommend reading
nearly every post by @guy038 and the regex engines details as described here. In addition sites like http://www.rexegg.com/ and https://regex101.com/
are useful too.Cheers
Claudia