[94vette]

Hello all,

I need a little help with something. I have a program that has many different Z heights (all G01 are negative Z) that range from Z-0.002 to Z-0.124. I would like to force all of the negative Z values to be at a constant Z height.

I thought it would be easy to open an editor and do a search and replace. But none of the editors that I have tried will allow you to use a wildcard for the search. (ex. search Z-0.***, replace Z-0.020)

Is there an easy way to do this?

[ImanCarrot]

Yep,

Use Excel to open the file (select all files so it can see it)

Use "Fixed Width" option.
Tell it where you want the column separators to be

Select the column you want to delete and delete it

Stick your value 0.0000 (for example) on the first cell you want and copy and paste that to the rest of the column cells.

Save the file using a different file name but with the original extension.

:::ting::: :idea:

If there's any spaces, commas etc you dun want just use Word to Replace (EG Find Z,00.000 Replace with Z0.000 etc).


ANy probs gimme a shout- hope this helps! home time for me nearly so if I dun reply am not ignoring you.

Iain

[ger21]

http://www.gmayor.com/replace_using_wildcards.htm
or using Open Office, which is free.
http://plan-b-for-openoffice.org/wri...sing-wildcards

[94vette]

http://www.gmayor.com/replace_using_wildcards.htm
or using Open Office, which is free.
http://plan-b-for-openoffice.org/wri...sing-wildcards

This is what I was looking for. Thank you. At first I had a little problem getting it to work the way I wanted it to.

When I checked the use wildcars box I still had this problem;
Example: search for Z-0.0** , replace with Z-0.050
Results: Z-0.044 would be replaced with Z-0.05044. (not good)

But toward the bottom of the page in link http://www.gmayor.com/replace_using_wildcards.htm There is an option ^# for any digit.

Example: search for Z-0.0^#^# , replace with Z-0.050
Results: Z-0.044 would be replaced with Z-0.050. (perfect)

Thank you for your help.