AutoHotkey Community

carno

IMEime's solution fails for all numbers that don't have at least four 0s at the end. For example, 123.456700 fails, it will not match the pattern and will stay as it is, when it should really become 123.4567 . Strangely enough, IMEime's solution returns 123.456700 for 123.4567000000 (while no criti...

carno

Looks like the first script from jeeswg also failed with 0.000000814. It returns 0.00814. So the winner is IMEime whose script is so far standing tall.

carno

IMEime wrote: ↑
29 Jan 2019, 13:44
try to love simple one

I agree. Yours is the simplest and easiest to understand -- specially for someone who is still struggling with basic RegEx.

carno

Both jeeswg and IMEime solutions seem to return solid results!

carno

SALZKARTOFFEEEL wrote: ↑
29 Jan 2019, 12:58
Not wanting to brag or anything, but my solution is the most fail-safe and perhaps the cleanest so far

I think I found the first dangerous bug:
3453/4242443=0.000814 (8.13917829891881E-04)
But when the RegEx code is run, it returns: 0.00814 (one zero is missing)

carno

Thanks, jeeswg , SALZKARTOFFEEEL and IMEime! These are great RegEx solutions that I'll be running and testing them.

carno

Looking for a RegEx so that I can trim any number with 6 decimal places so that I can trim the leading floating zeros only after the decimal point but leave 2 zeros after the decimal point if all digits after the decimal point are zeros and 1 zero after the first non-zero digit following the decimal...

carno

How can this be modified so that I can trim the leading floating zeros only after the decimal point but leave 2 zeros after the decimal point if all digits after the decimal point are zeros and 1 zero after the first non-zero digit following the decimal point if the remaining digits are also zeros? ...

carno

By image I meant the constant image of a clockwise circle reload button with an arrow that is specific to Google toolbar and is situated to the left of Home button and to the right of Go Forward ->. Firefox has a similar button but is called Refresh. You need to capture that button image and save it...

carno

Pseudocode #include FindClick.ahk ... GoSub, RE ; RE stands for Refresh/Reload. Here, it waits until the page is fully loaded and "Reload this page" is confirmed Sleep, 1000 ... RE: ;WinWaitActive,ahk_class MozillaWindowClass Loop { MyImage := "refresh.png" ; your saved chrome's "Reload this page" p...

carno

Thanks, SOTE. When it rains, it pours!

Your method does not leave a blank line at the top and obviates the need to remove it.

carno

LOL. I'm in Mountain View, CA, and it has been sunny and warm for the last several days.

carno

Awesome! My only question is that when I replace s with clip it seems that it doesn't work:
FileRead, s, Clip.txt ; Works great!
FileRead, Clip, Clip.txt ; Doesn't seem to work

Code: Select all

MsgBox % RegExReplace(Clip, "Clip).*Total(.*?)Currency.*", "$1") ; No go?

carno

I have the following text and I would like to extract only the middle block that begins with the first date string and ends with the last decimal string on the last line of the block to be extracted and just before the last line that begins with Currency: USD. As for my efforts, I can use something ...

carno

Thanks, I also tested and looks good so far. Now this is a comprehensive solution!

carno

I ran your version with my big file of over 4,700 lines. It seems case-sensitive and flexible with various options as you mentioned. Thanks!

carno

I was using sinkfaze's version for a very long file with over 4,700 lines and noticed it not only finds identical lines but also strings within those lines (and in my longer file version, space, hyphen and some other cases as duplicates) as demonstrated in this short version below: #NoEnv #SingleIns...

carno

This archived thread also provides a few other methods:
https://autohotkey.com/board/topic/9168 ... ith-regex/

carno

Thanks rommmcek for a very clear explanation.

carno

If column contains additional signs, you have to strip them. For speed you need to do it "on the fly". So use: for 8. column Round(RTrim((StrSplit(A_LoopField, ",").8), "%")*100) and for 5. column Round(LTrim((StrSplit(A_LoopField, ",").5), "%")*100) respectively. The trick is to get pure Integer (...

Search found 265 matches

Re: RegEx to trim floating decimal places Topic is solved

Re: RegEx to trim floating decimal places Topic is solved

Re: RegEx to trim floating decimal places Topic is solved

Re: RegEx to trim floating decimal places Topic is solved

Re: RegEx to trim floating decimal places Topic is solved

Re: RegEx to trim floating decimal places Topic is solved

RegEx to trim floating decimal places Topic is solved

Re: ZTrim() : Remove redundant leading/trailing zeroes from a number

Re: How to wait until web page is fully loaded on Chrome

Re: How to wait until web page is fully loaded on Chrome

Re: RegEx - Extracting the text block in the middle Topic is solved

Re: RegEx - Extracting the text block in the middle Topic is solved

Re: RegEx - Extracting the text block in the middle Topic is solved

RegEx - Extracting the text block in the middle Topic is solved

Re: Sorting Rows of 8 Columns (Comma or Tab Separated) Topic is solved

Re: How to find duplicate lines? Topic is solved

Re: How to find duplicate lines? Topic is solved

Re: How to find duplicate lines? Topic is solved

Re: Sorting Rows of 8 Columns (Comma or Tab Separated) Topic is solved

Re: Sorting Rows of 8 Columns (Comma or Tab Separated) Topic is solved