Macro Scheduler Forums

GalaxyMan

I use huge databases of 100+ columns and 30,000+ rows. I often need to do a search (with a delete or replace involved). Sometimes it can take almost a minute for the search to complete, sometimes it only takes a few seconds. Is there a method whereby I can move onto the next line of code once the se...

GalaxyMan

That did the trick! Thanks for the guidance. And I promise you, I searched for an answer to this before posting for help. I prefer working things out myself, but when I can't...

GalaxyMan

Hi, Marcus. I tried your suggestion. This is the actual lines of code that I'm trying to work with. I wasn't sure whether to use the Let> before each line or not, so I started by trying it just once before them all. Here is the actual code I'm using. Let>comma=, StringReplace>theFileData,150000,$150...

GalaxyMan

:roll: I've got tables of information. Some of the cells are not properly formatted. They are displaying numbers instead of properly formatted currency. 150000 instead of $150,000. Sometimes it's 150000. when it needs to be $150,000. I have to use the tags in the definition because of the various si...

GalaxyMan

Deep, very deep....I'll do some reading on RegEx and see what I can learn. I was just getting comfortable with StringReplace, too.

Thanks again...

GalaxyMan

Amazing. I can feel myself actually beginning to grok what you've done. One problem is that I have many tables in my document, but only 4 of them are relevant to this process. They all have a unique tag: Is there any way to limit this action to only tables displaying this particular table tag? Will ...

GalaxyMan

Wow, that was a quick day.......I was able to get this done before the system crashed, had the prelim done already, just needed the final detail that you provided. This seems to work for me: Let>vSample=<table><tr><td>1</td><td>R3003808</td><td>214 Via Palacio</td><td>Palacio</td><td>5</td><td>6.3<...

GalaxyMan

Bob Hansen wrote:Have you tried ti disable the HTML in the posting to get the text format that you want?

Never occurred to me...

214 Via Palacio

That is what the 3rd and 4th tags are supposed to look like after the change.

Thanks...

GalaxyMan

I suspect we can use RegEx to do this. Could you provide some lines of the HTML document, showing the "before" and desired "after" results? Could use that to do some RegEx testing. Hi, Bob. Here is a bit, showing the starting tag and then going down two rows. Keep in mind, each table has a differen...

GalaxyMan

I have an HTML document with several tables in it. The tables are of different size in terms of both rows and columns and they vary every time. They are never the same twice. I need to change the tag in each cell of two adjacent columns of each table. Even though there are a different number of colu...

GalaxyMan

You seriously ROCK!!!

Thank you so much. I understand how this will extrapolate to any other explicit commands, using the % (percent) symbol as a bracket.

I actually have another question I thought of, but that will be at another time and its own Topic/Subject.

Ronen

GalaxyMan

gdyvig wrote:Try this:

Code: Select all

StringReplace>theFileData,>%CRLF%VAREXPLICIT=1.

Gale[/quote]

No, that didn't help. I also tried it with a comma before theFileData where it appears at the end of the StringReplace expression.

[code]

StringReplace>theFileData,>%CRLF%VAREXPLICIT=1

GalaxyMan

>CRLF< shows up, literally. It doesn't seem to recognize or execute the CRLF. I've set up maybe 30 different StringReplace statements for this particular macro, to run consecutively, and this is the only one that doesn't seem to work, which wouldn't ruin my day in the great scheme of things. I can a...

GalaxyMan

Hi Ronen, Can I use CRLF as a search and/or replace parameter? Yes. Example: StringReplace>theFileData,CRLF,:,theFileData Gale Hi, Gale. I'm trying to replace the end bracket of an HTML tag followed immediately by the opening bracket of an HTML tag with the same but with the opening bracket on a ne...

GalaxyMan

Hi, Gabe.

I write this with my head hanging in embarrassment. In the code I used the .html file extension, while in reality my file was .HTM. Jeesh!!!

Needless to say, it works magnificently now.

Live & Learn...

Many thanks once again,

Ronen

Search found 40 matches

Timing a pause

StringReplace: How do I also include commas?

StringReplace parsing

Re: Try percent signs to enclose CRLF

Re: StringReplace with CRLF

Re: run from top when in editor