- Posted by
- Holy crap, Tim! I started to run the find and replace and it didn't work. I was looking at the string, because I have only just started to learn about how to use these symbols and make formulas in the find and replace. I was sure that with a string that well laid out you knew what you were talking a...Posted in Find/Replace/Regular Expressions
-   Topics
-   Views
- cfay
Oct 17, 2008
- I have a bunch of comma delimited files. The first two columns have no double quotes for text qualifiers, and the rest of every column for the rows have double quotes (don't know if that matters) What I need to do is keep the first 11 columns, remove everything but the 45th column, and then remove t...Posted in Find/Replace/Regular Expressions
-   Topics
-   Views
- cfay
Oct 16, 2008
- I don't know if this is the right forum, but here it goes. I ran a dos directory listing and it is over 100MB. The problem is that I can't put it into Access or anything to group and report on it. There is a line with the path for a directory, then all of the files under it, which looks like fixed w...Posted in Macros
-   Topics
-   Views
- cfay
Sep 25, 2007
- Thanks, I will look at this, although I have never gotten into perl, even a little. Will this copy the line to another file? It looks like perl will let me specify all extensions with a pipe delimiter. I think I can do this, but wanted to understand the part that copies the lines to the other file. ...Posted in Macros
-   Topics
-   Views
- cfay
Sep 13, 2007
- Well, I am not sure if I just need to be patient for someone to be able to reply or I just explained poorly. Anyway, I have a macro that partly works. If anyone can help with the issues, I would love it. Here is what I have: InsertMode ColumnModeOn HexOff UnixReOff Find "TIFF"^p" Replace All "" Find...Posted in Macros
-   Topics
-   Views
- cfay
Sep 13, 2007
- I am new to macros and have been reading up on how they work. Because I need to get this project done, I was thinking I should post this question and see if someone might be able to point me in the right direction. Once I get into these macros, I am sure I will be able to build and learn. Anyway, he...Posted in Macros
-   Topics
-   Views
- cfay
Sep 13, 2007