- Posted by
- Thank you Jane!!!! That is exactly what it was. 60336600 00644044 KZZ82A464 K64AWC ASST 47811 W812 12 000702407 00000000000000 60336600 00644045 KZZ82A464 K64AWC ASST 47811 W812 12 000702407 00000000000000 60336600 00644046 KZZ82A464 K64AWC ASST 47811 W812 12 000702407 00000000000000 60336600 006440...Posted in Macros
-   Topics
-   Views
- jeremyw
Dec 09, 2008
- Thanks Jane. I'm driving myself nuts on the last one. I have added the Find MatchCase RegExp "^(\d{8})\n" Replace All "\1 " to the end of the macro and that seems to be the only thing that is not working. This is the full macro I have. InsertMode ColumnModeOff HexOff PerlReOn Bottom IfColNumGt 1 " "...Posted in Macros
-   Topics
-   Views
- jeremyw
Dec 08, 2008
- PERFECT!!! If possible, could you help with 2 more things on this file? I guess if I had put it in the original spec it would have been better, but as I'm working with this more, I see 2 more things that would make this easier when I transition this to the person that will be taking over for me. 1. ...Posted in Macros
-   Topics
-   Views
- jeremyw
Dec 04, 2008
- Thanks Jane & Mofi. It's strange, the code Mofi gave works on the test file, but when I load a different test fil, it appears to remove all the OBINP100 lines (leaving the customer #), but it doesn't appear to move on to the OBINP200 lines. I'm not sure if you can step through a macro like you can i...Posted in Macros
-   Topics
-   Views
- jeremyw
Dec 04, 2008
- Just so I'm clear, on the data you supplied, based on the column matching criteria you gave, you would delete all starting with OBINP200 except rows 9, 18, and 27 because these have all zeros at 537-550 - is that correct? Correct Then you want to remove the ranges specified for ALL ROWS? There appe...Posted in Macros
-   Topics
-   Views
- jeremyw
Nov 26, 2008
- Not sure if this can be done. I have UE 12.20b+1 What I would like to do is loop through the file and if the following is TRUE, then delete the entire line. If line begins with OBINP200 AND Column 522 - 530 value NOT EQUAL to all zero's or blank AND Column 537 - 550 value NOT EQUAL to all zero's or ...Posted in Macros
-   Topics
-   Views
- jeremyw
Nov 26, 2008