JWalker: -------------------------------------------------------------------------------- Listed below is a data string that I would like to use a macro to remove the leading zeros.. I could easily do this in excel but would like to learn more about macros.. I have created the macro to add the decimal..
00000997.56 00000004.14 00001323.58 00001641.00 00001458.29 00001513.00 00003169.27 00000217.65 00000121.00 00000267.64 -------------------------------------------------------------------------------- You can use the regular expression replacement for this kind of task. for the sample text simply replace [b]"^0+" >> ""[/b] (without quotes) with the option "[x] regular expression" checked. (If you want to handle values like 0000.123 and need them converted as 0.123 instead of .123, the replacement might be a bit different; e.g.: [b]"^0+(?=[^.])" >> "$1"[/b] ). Using a script, it would likely be a similar operation, or a loop over each line of the string. hth, vbr -- <http://forum.pspad.com/read.php?2,50391,50438> PSPad freeware editor http://www.pspad.com
