ecoast Posted March 5, 2008 Report Share Posted March 5, 2008 Hello, Joe I just ordered Macros Explained so I eagerly await the reference I have a fairly large MACRO and this a portion has me stumped. what happens is that the macro will run and never return a result, when i know that a one of the words from my list IS in every one of the 3 titles. I have left for over an hour to return, to no result, even though the macro isn't frozen, as I can stop is instantly. I have adjusted speeds and added delays also to no avail. ***The scanning if one-liner's in txt file is derived from Joe's simple method here Read Random Line From Text File in this portion of the macro I am wanting to 1. choose a title randomly from 3 titles of the same line in my example.csv file. (have used for a while w/out any hitches) 2. scan my "title_words_to_modify.txt" file randomly, (which contains one word on each line) --Until a word matches up with a word contained in my randomly chosen title from above. **Now it is a possibility that the randomly chosen title will NOT contain ANY of my words in my "title_words_to_modify.txt" in this is a small chance, but still possible... in this case I would like the macro to leave the title "as is" and move on.** 3. In the common case that a matching word is found, I would like to add a character(s) from my "characters_to_append.txt" file which contains the character(s) on each line -- to either the beginning or end of the word i.e. *WORD or WORD* 4. Then, I would like this modified word inserted back into the title replacing the original word. *********************** The above would be within one days work. The next day I would like to be able to do the same, but to not have the exact same title as end result. each repeat loop created a different titles (originally chosen from one of the 3 per line in the CSV file -- maybe stick titles created from one day into a file and compare them the next dady so the following would be classified as OK Monday = TITLEWORD *SAMETITLEWORD TITLEWORD Tuesday = TITLEWORD SAMETITLEWORD* TITLEWORD That would be all.. as you can see after thinking that couldn't simply modify the current variable, (using the same variable for some repetitive randomizing functions) I started clearing the variable out after each portion. Help would be greatly appreciated, or if I have missed a similar post on this, a reference would be just as appreciated. I have attached the sample files Thank you in Advance! Clear All Variables: All // ASK FOR LINE NUMBER FROM CSV FILE TO START FROM Variable Set Integer %N1% from Prompt Variable Modify Integer: %N1% = %N1% - 1 Repeat Prompt Start (Prompt for repeat count at macro play time) Variable Modify Integer: %N1% = %N1% + 1 Wait Time Delay 0.5 Seconds // LOAD "T" VARIABLES USED IN CSV FILE ASCII File Begin Process: "example.csv" (Comma Delimited Text ) ASCII File End Process Wait Time Delay 0.5 Seconds Keystroke Speed: 4 Milliseconds // RANDOM TITLE IS CHOSEN BY THE "IF" STATEMENTS // AFTER TITLE IS CHOSEN FROM T43, T44, 0R T45 IN CSV FILE // AFTER TITLE IS CHOSEN THEN, IT IS PUT INTO A VARIABLE (T46) Variable Set Integer %N90% with a Random Number <-- MAX VALUE 2 If Variable %N90% = 0 Variable Set String %T46% "%T43%" End If If Variable %N90% = 1 Variable Set String %T46% "%T44%" End If If Variable %N90% = 2 Variable Set String %T46% "%T45%" End If Delay 0.5 Seconds // SEARCHES COMMON WORDS UNTIL ONE IS FOUND THAT IS IN CURRENT TITLE Repeat Until %T46% Contains %T67% Delay 0.5 Seconds Clear Integer Variables: From 11 To 11 Delay 0.5 Seconds Clear Integer Variables: From 2 To 2 Delay 0.5 Seconds Clear Text Variables: From 67 To 67 Delay 0.5 Seconds Clear Text Variables: From 70 To 70 Delay 0.5 Seconds Variable Set Integer %N11% to 0 Text File Begin Process: "title_words_to_modify.txt" Variable Modify Integer: Inc (%N11%) Text File End Process Variable Set Integer %N2% with a Random Number Text File Begin Process: "title_words_to_modify.txt" Text File End Process Wait Time Delay 0.5 Seconds Repeat End Wait Time Delay 0.5 Seconds Clear Integer Variables: From 11 To 11 Wait Time Delay 0.5 Seconds Clear Text Variables: From 70 To 70 Wait Time Delay 0.5 Seconds // CHOOSES RANDOM CHARACTER TO ADD TO COMMON WORD Variable Set Integer %N11% to 0 Text File Begin Process: "characters_to_append.txt" Variable Modify Integer: Inc (%N11%) Text File End Process Variable Set Integer %N2% with a Random Number Text File Begin Process: "characters_to_append.txt" Text File End Process Wait Time Delay 0.5 Seconds Clear Integer Variables: From 11 To 11 Wait Time Delay 0.5 Seconds Clear Text Variables: From 70 To 70 Wait Time Delay 0.5 Seconds // APPENDS CHARACTER(s) TO COMMON WORD FOUND ABOVE Clear Text Variables: From 69 To 69 Wait Time Delay 0.5 Seconds Variable Set String %T69% "%T67%" // SETS UP STRUCTURE OF COMMON WORD AND APPENDED CHARACTER (CHARACTER ADDED BEFORE OR AFTER COMMON WORD) // TO EITHER "COMMON WORD""ADDED CHARACTER" // -OR- // OR "ADDED CHARACTER""COMMON WORD" Clear Text Variables: From 71 To 71 Variable Set Integer %N90% with a Random Number If Variable %N90% = 0 Variable Set String %T71% "%T67%%T68%" End If If Variable %N90% = 1 Variable Set String %T71% "%T68%%T67%" End If // REPLACES COMMON WORD IN TITLE W/ MODIFIED WORD IN FROM ABOVE Replace "%T69%" with "%T71%" in %T46% Wait Time Delay 0.5 Seconds Repeat End sample_files.zip Quote Link to comment Share on other sites More sharing options...
ecoast Posted March 6, 2008 Author Report Share Posted March 6, 2008 Anyone? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.