find and replace help



  • 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.



  • @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


Log in to reply