Replacing comma by dot only in numbers in a texteditor using search and replace function
i got a table as txt.file with all the variables beeing seperated by ;.
Lets say i got 3 Variables: ID, Size and Comment.
My Data could look something like this:
1;1.5;hello. how are you?
2;2.5;a comment.
3;2.1;another comment.
Now i would like to replace the comma-sign from dot to comma.
If i use the standard search and replace function in my text-editor it will change all . to , without any problem. But i want to change only those . to , which are surrounded by numbers left side and right side.
1.5 should be changed to 1,5 but hello. how are you? should not be changed to hello, how are you?
I found a regular expression for searching only dots surroundet by numbers:
[0-9][\\.][0-9]
Now i would like to replace those surroundet dots, but unfortunately it doesn't work yet. When replacing [0-9][\\.][0-9] by ,, 1.5 is changed to , only instead of 1,5.
Is there any nice way to use search and replace from a texteditor to solve this problem?
Thanks in advance!
EditPlus does not support lookbehinds, so you need to use groups.
(\d)\.(\d)
Substitution: \1,\2
()Capturing group\dmatches a digit (equal to[0-9])\1\2Capturing group 1. and group 2.
- JS Regex MatchAll with combination of Comma & Semicolon
- Symfony Routing Host Regular Expression
- Regular Expression to parse Common Name from Distinguished Name
- Add a value and sum it up using Notepad++
- Regex for Number "05XXXXXXXX"
- Replace one character but not two in a string
- how to escape hyphen in regex character group in c
- Why do some regex engines match .* twice in a single input string?
- What do 'lazy' and 'greedy' mean in the context of regular expressions?
- How to test if a RegExp contains capturing groups in its definition?
- create regex to match format of 00:00:00 for duration (not time)
- regex for expression with one separator hyphen
- Remove special character and units form Pandas column name with Python
- Replace variables in a formula with their definitions
- RegEx to differentiate chemical compound names from pattern
- Replace letters inside words that start with and end with a specific letter not occurring anywhere else with the same amount of a specific character
- open vimeo url in colorbox using jQuery filter
- Split address and numbers
- Pyspark Regular Expression add double quotes after comma
- In the regex world what's a flavor and which flavor does Java use?
- Problems with table extraction using pdfplumber - empty fields in large tables
- How do I pass a variable into regex with Node js?
- How do I use regex in a SQLite query?
- Python RegEx: match words in a string only if they are not preceded by a specific character
- Regular expression that ignores HTML entities
- Allow access to page only from certain referrer
- Regex to match string containing two names in any order
- Matching boot times from log using sed -E
- Validate Bangladeshi phone number with optional +88 or 01 preceeding 11 digits
- Using setCustomValidity stops input from validating