Search found 110 matches

by ahcahc
08 Aug 2014, 08:04
Forum: Ask For Help
Topic: [Solved]Help with a RegEx?
Replies: 10
Views: 2331

Re: Help with a RegEx?

Code: Select all

string := "71: ,'first part','second part','wanted block','last part','another wanted block'"

string2:= "71: "
startp=1
Loop
{
foundp := RegExMatch(string, "'[^']*?want.*?'", match,startp)
if match is space
	break
string2 := string2 "`," match
startp := foundp+1
}
MsgBox % string2
by ahcahc
06 Aug 2014, 15:35
Forum: Ask For Help
Topic: (Solved) RegEx Problem
Replies: 2
Views: 806

Re: RegEx Problem

Thank you....
by ahcahc
06 Aug 2014, 11:36
Forum: Ask For Help
Topic: (Solved) RegEx Problem
Replies: 2
Views: 806

(Solved) RegEx Problem

Hi, I have a text below that need I need to match a sentence that contains that word "car". This is the pattern I use (\.).*(car)(.*?\.) . I use period (.) as the beginning and end of the sentence. But it matches more than just the sentence. It matches from the first period of the line, I need to ma...
by ahcahc
06 Aug 2014, 11:08
Forum: Ask For Help
Topic: (Solved) Extracting Data from CSV files
Replies: 8
Views: 4617

Re: (Solved) Extracting Data from CSV files

Thanks. I think I'll just use the variable before fileappend.
by ahcahc
03 Aug 2014, 23:23
Forum: Ask For Help
Topic: (Solved) Extracting Data from CSV files
Replies: 8
Views: 4617

Re: (Solved) Extracting Data from CSV files

Well, when using fileappend inside the loop ( loop,parse,csv,`r,`n and loop, read ) the output file has different number of lines (a lot are missing) every time it is executed. My input csv file has around 200+ lines the out has around 90 lines. I then MsgBox the current line and contents just befor...
by ahcahc
02 Aug 2014, 18:50
Forum: Ask For Help
Topic: (Solved) Extracting Data from CSV files
Replies: 8
Views: 4617

Re: Extracting Data from CSV files

Thanks guys! The problem was fileappend was unable to write some lines since the loop is going so fast and my harddrive probably cant keep up. I had to first store the data in a variable then fileappend later after the loop is complete. #NoEnv ; Recommended for performance and compatibility with fut...
by ahcahc
02 Aug 2014, 13:05
Forum: Ask For Help
Topic: (Solved) Extracting Data from CSV files
Replies: 8
Views: 4617

(Solved) Extracting Data from CSV files

Hi, I have a .csv file that has two delimiters, a comma (,) for the cell, and a quotation mark "" for text fields that can contain commas. My script works until it encounters a comma within the text fields. My script gets the product IDs and image links and writes them to a new csv file with semicol...
by ahcahc
26 Jul 2014, 22:08
Forum: Ask For Help
Topic: Challenge, get html source code for Google search results
Replies: 4
Views: 2174

Re: Challenge, get html source code for Google search result

Code: Select all

html := wb.document.documentElement.innerHTML
msgbox % html
by ahcahc
26 Jul 2014, 03:57
Forum: Ask For Help
Topic: (Solved) How to hide cmd window?
Replies: 2
Views: 3263

Re: How to hide cmd window?

Thank you very much....
by ahcahc
26 Jul 2014, 02:29
Forum: Ask For Help
Topic: (Solved) How to hide cmd window?
Replies: 2
Views: 3263

(Solved) How to hide cmd window?

Hi, How do I hide the command prompt window that shows up when I run the following script (or prevent it from ever showing up)? objShell := ComObjCreate("WScript.Shell") objExec := objShell.Exec("cmd /c ping -n 3 -w 1000 www.google.com") While !objExec.Status Sleep 100 strLine := objExec.StdOut.Read...

Go to advanced search