there must be a regex way to do this

lklawrie · Post by **lklawrie** » Wed Oct 21, 2015 2:05 pm

I am just not that expert in regular expressions.

I want to search for

City=<word>.<word>.<word>

where the number of words is unknown.

and replace the . with space.

ben_josephs · Post by **ben_josephs** » Wed Oct 21, 2015 4:01 pm

Do you want every dot that's immediately preceded and followed by words to be replaced by a space?

If so, try

Find what: (\w)\.(\w)
Replace with: $1_$2 [Replace the underscore with a space]

[X] Regular expression

Replace All

ben_josephs · Post by **ben_josephs** » Wed Oct 21, 2015 4:10 pm

Or

Find what: \b\.\b
Replace with: _ [Replace the underscore with a space]

lklawrie · Post by **lklawrie** » Wed Oct 21, 2015 4:12 pm

There are numbers in the file too. I don't want their . to be replaced. Only on the lines that start with "city="

ben_josephs · Post by **ben_josephs** » Wed Oct 21, 2015 6:36 pm

Find what: ^(City=.*)\b\.\b
Replace with: $1_ [Replace the underscore with a space]

[X] Regular expression

Replace All -- do this repeatedly until it beeps