find and replace help

[Shawn Thomas]

I have about 1500 sets of coordinates that I need to modify. I have a list that looks like this:

Z = -126.102 mm,
Z = -126.182 mm,
Z = -126.187 mm,
Z = -126.202 mm,

I would like to find them and replace them all with the same value

Z = -126.000 mm,

Very new user and short on time and struggling with the expression. Can also use a find from Z = to a specific column, all the values are lined up.

Any help would be greatly appreciated.

[Claudia Frank]

@Shawn-Thomas

what I get is that you only want to modify the decimal part, correct?
If so, and if your data look exactly like you posted than

find: \.\d+
replace: .000

. means you are looking for the literal dot followed by
\d+ one or more digits (as much as possible)

Of course you need to check the regular expression box in find repalce dialog.

Cheers
Claudia