Macro Scheduler Forums

hagchr

Hi, sorry for the late reply, but in case you have not resolved it... The code should normally take care of the ' as well, see example below. Is something else happening? You probably have something like "'" that needs to be handled. Maybe you can paste a couple of HTML lines around and inc...

hagchr

Hi, expanding on Dorian's suggestion: For Regex, \K means forget what you have matched already and continue, so in the example you match dc:title until content=" then forget everything (\K) and continue and match subsequent characters that are not ", ie Warriors:. Hope it helps. //Read source file i...

hagchr

Hi, I think you can use regex to find the sort order, or to check if sort order is higher than position 8. The following lines will extract the sort order for all examples (by taking the right-most digits in each case), and separately, also extracting the sort order, only for examples with numbers h...

hagchr

To develop it further: (Here you look for a position that is followed by a pair of numbers. If you find a position, then take the first number) Let>string=2;7;49;4;16;19;42;38;39;1;8;17;13;12;39;51;9;20;29;35;36;37;10;50; Let>pattern=(?=(49|38|17);(13|26|39|52))\d+ Regex>pattern,string,0,matches,num...

hagchr

Hello,

This works for me:

Code: Select all

CSVFileToArray>C:\Users\Christer\Desktop\msTest.txt,msArrCurrPagePath
Let>msArrCurrPageRowLast=msArrCurrPagePath_%msArrCurrPagePath_COUNT%_0

How do you define:

Code: Select all

%msArrCurrPageSize%

hagchr

Also I note the number of brackets (), that all capture information. Not a performance problem here but could be for larger data sets. For larger problems, if you need brackets but want to turn capturing off then simply change (xxxx) to (?:xxxx).

hagchr

Hi, you can eg try: let>Pattern2=(?=((%Listb%):(\d\d?)|(\d\d?):(%Listb%));(\d\d?:\d\d?);((%Lista%):(\d\d?)|(\d\d?):(%Lista%)))[^;]+;\K[^;]+ Basically what is does is start from the left and look for positions that are followed by the three pairs (where the first and third pair contain number(s) from...

hagchr

Hi, you need to use the clipboard value, eg

Code: Select all

GetClipBoard>NewValue

hagchr

Hi, If --> if> MessageModel --> MessageModal Let>IGNORESPACES=1 Let>VAREXPLICIT=1 Let>str_One=A Let>str_Two=B If>str_One=str_Two MessageModal>Method One Match Else MessageModal>No match with method one EndIf Let>str_One={"A"} Let>str_Two={"B"} If>str_One=str_Two MessageModal>Match Two Match Else Mes...

hagchr

Hello, You can try: let>Pattern1=((%NumOrList%):(\d\d?);\K(\d\d?:\d\d?))|((\d\d?):(\1);(\d\d?:\d\d?)) (where \K instructs to forget what was just matched and continue.) or since right part is not used here: let>Pattern1=((%NumOrList%):(\d\d?);\K(\d\d?:\d\d?)) or to reduce further: let>Pattern1=(%Num...

hagchr

For the last one you want to change to center alignment to get the padding uniform beginning/end.

hagchr

Hi, alternative using xPath Let>EDGEDRIVER_EXE=C:\Users\Christer\Desktop\EdgeDriver\msedgedriver.exe EdgeStart>strSessionID Let>tmpURL=file:///C:/Users/Christer/Desktop/Test.html EdgeNavigate>strSessionID,url,tmpURL // Two examples of xPath Let>strXPATH=//tr[contains(.,'Color')][2]//td[2] //Let>strX...

hagchr

If you click on "Try the new and improved charts" and "join beta" then it seems they have added a "Table View" where you can access all the Bollinger bands per day in table format. This should make your life much easier.

hagchr

Hi, using CSVFileToArray and looking through the watch list, it seems rows starts at 1 and cols start at 0 (don't know why), ie you need to reflect that in the loop starts and stops. One example for dumping the (non-empty) items into a file: Let>source=C:\Users\Christer\Desktop\Test.csv Let>target=C...

hagchr

Hi, I think it gets confused by the "," in your xpath. You can try

Code: Select all

Let>tmp0=//*[contains(text(),'No, thanks!')]//parent::a
ChromeFindElements>session_id,xpath,tmp0,elements
ChromeElementAction>session_id,elements_1,click

Search found 331 matches

Re: Strip out specific characters from string

Re: Strip out specific characters from string

Re: Find Sort Order and Count Character Position

Re: RegEx Pattern Help

Re: Accessing Array elements

Re: RegEx Help

Re: RegEx Help

Re: Copy some data and store it to an Array without leaving current page

Re: String Matching

Re: RegEx Help

Re: Dialog padding/margin for labels

Re: Using xpath to find Nth instance of desired value

Re: Screen scraping values from a page

Re: CSVtoarray get column values

Re: Unable to click the a href