Search found 60 matches

by Pardeep Tariyal
18 Mar 2019, 07:02
Forum: Ask For Help
Topic: Need to sum duplicate value and price
Replies: 7
Views: 130

Re: Need to sum duplicate value and price

data = (C ; invNr qty type code price 1390431828 1 PC L8511 50.5 1390431831 3 BOX A4456 64.5 1390431836 2 BOX A7507 207 1390431838 1 BOX A5120 25.5 1390431838 1 BOX A5120 21 1390431838 1 BOX A7507 103.5 1390431840 1 BOX A7507 103.5 1390431840 1 BOX A7507 103.5 ) data := RegExReplace(data, "\t\d+\K ...
by Pardeep Tariyal
18 Mar 2019, 06:23
Forum: Ask For Help
Topic: Need to sum duplicate value and price
Replies: 7
Views: 130

Re: Need to sum duplicate value and price

Scr1pter wrote:
18 Mar 2019, 06:14
Why did you merge the 1390431838 and 1390431840 invoice for the A7507 item?
Purpose or mistake?
I know the prices are the same (For all three items),
but I'm asking anyway.

Cheers!

sorry it was mistake
by Pardeep Tariyal
18 Mar 2019, 05:38
Forum: Ask For Help
Topic: Need to sum duplicate value and price
Replies: 7
Views: 130

Need to sum duplicate value and price

Hi, I want to merge duplicate value and price in one line. Like if A5120 listed twice under invoice "1390431838" then the price should be merged. Here is example. 1390431828 1 PC L8511 50.5 1390431831 3 BOX A4456 64.5 1390431836 2 BOX A7507 207 1390431838 1 BOX A5120 25.5 1390431838 1 BOX A5120 21 1...
by Pardeep Tariyal
07 Mar 2019, 01:58
Forum: Ask For Help
Topic: Need to capture text right to left till the tab
Replies: 6
Views: 201

Re: Need to capture text right to left till the tab

There could be several formats. but unique thing is USD and left tab. Here are same samples: [*]1. HCPCS_Code: A7507 Contract Allowed Amt 0.00 -106.20 Patient share 20.00 % 102.96 20 7669 2 SET 138.50 USD 1 SET 277.00 Provox LaryClip HCPCS_Code: A7526 Patient share 100.00 % 277.00 30 LOG104 1 PC 0.0...
by Pardeep Tariyal
05 Mar 2019, 08:11
Forum: Ask For Help
Topic: Need to capture text right to left till the tab
Replies: 6
Views: 201

Need to capture text right to left till the tab

I am trying to capture data right to left but unable to do that. I need to capture line contains USD to left till the tab. Below is example data: Item Material Description Quantity Price Price Unit Value 10 7291 2 BOX 103.50 USD 1 BOX 207.00 I want to capture 10 7291 2 BOX 103.50 USD 1 BOX 207.00
by Pardeep Tariyal
20 Nov 2018, 10:46
Forum: Ask For Help
Topic: Need to merge Duplicate Data
Replies: 1
Views: 99

Need to merge Duplicate Data

I have duplicate data as mentioned below. Now I want to merge duplicate data with original data. Like S.No 1111 is 3 times in list so i want to merge Tab2,Tab3 & Tab4 Values in Tab5 where is S.No 1111 S.No Unit Item Price 1111 1 92133 46.79 1111 1 99214 128.25 1111 1 92015 45 1112 1 66984 200 1112 1...
by Pardeep Tariyal
10 Aug 2018, 09:56
Forum: Ask For Help
Topic: Command line for printer paper size
Replies: 0
Views: 120

Command line for printer paper size

is there any command line to set printer paper size to A3. I have found following command lines from microsoft docs but no idea how to use in AHK.

Code: Select all

PS C:\> Set-PrintConfiguration -PrinterName "Microsoft Print to PDF" -PaperSize A4
by Pardeep Tariyal
05 Aug 2018, 00:33
Forum: Ask For Help
Topic: Help to convert HTML to PDF
Replies: 4
Views: 286

Re: Help to convert HTML to PDF

I m using this code but nothing works

Code: Select all

  
     RunWait, C:\Program Files (x86)\wkhtmltopdf\bin\wkhtmltopdf.exe %A_ScriptDir%\google.html %A_ScriptDir%\google.pdf

Msgbox, Conversion Complete!
by Pardeep Tariyal
04 Aug 2018, 07:47
Forum: Ask For Help
Topic: Help to convert HTML to PDF
Replies: 4
Views: 286

Help to convert HTML to PDF

Can anyone has a script to convert HTM/HTML file to PDF.

I have found a tool "wkhtmltopdf" but no idea how to use with AHK. Please help me.
by Pardeep Tariyal
28 Jul 2018, 06:43
Forum: Ask For Help
Topic: Auto login to Autohotykey forum
Replies: 2
Views: 152

Re: Auto login to Autohotykey forum

I am getting below pasted error. I am sure someone has answer to this. Error: 0x80020006 - Unknown name. Specifically: Value Line# 110: Return 112: pwb := WBGet() 113: pwb.Visible := True 116: Pwb.document.getElementsByName("username")[0].value := "none" 117: Pwb.document.getElementsByName("password...
by Pardeep Tariyal
27 Jul 2018, 03:43
Forum: Ask For Help
Topic: Auto login to Autohotykey forum
Replies: 2
Views: 152

Auto login to Autohotykey forum

Anybody have a script to login at Authotkey forum. I have created one but unable to logged in. Please help me to do this. pwb := WBGet("AutoHotkey Community - User Control Panel - Login") pwb.Visible := True Pwb.document.getElementsByName("username")[0].value := "none" Pwb.document.getElementsByName...
by Pardeep Tariyal
24 Jul 2018, 11:52
Forum: Ask For Help
Topic: Help to click in login button
Replies: 2
Views: 134

Re: Help to click in login button

i am getting below mentioned error. Error: 0x80020006 - Unknown name. Specifically: Value Line# 110: Return 112: pwb := WBGet() 113: pwb.Visible := True 116: Pwb.document.getElementsByName("username")[0].value := "none" 117: Pwb.document.getElementsByName("password")[0].value := "none" 119: Loop,pwb...
by Pardeep Tariyal
24 Jul 2018, 11:01
Forum: Ask For Help
Topic: Help to click in login button
Replies: 2
Views: 134

Help to click in login button

Unable to click on login button. not sure what i am missing. pwb := WBGet("AutoHotkey Community - User Control Panel - Login") pwb.Visible := True Pwb.document.getElementsByName("username")[0].value := "none" Pwb.document.getElementsByName("password")[0].value := "none" Loop % pwb.document.getElemen...
by Pardeep Tariyal
18 Jul 2018, 10:01
Forum: Ask For Help
Topic: How to change pdf printer page size
Replies: 2
Views: 202

Re: How to change pdf printer page size

have read the blog but not found the solution.

Is there any way to change page size
by Pardeep Tariyal
14 Jul 2018, 01:06
Forum: Ask For Help
Topic: How to change pdf printer page size
Replies: 2
Views: 202

How to change pdf printer page size

I have created a script to print webpages which is working fine. I want to paper size with hotkey.

Is there any way to do this
by Pardeep Tariyal
10 Jul 2018, 11:53
Forum: Ask For Help
Topic: Click button on web page which has no element Id or Name
Replies: 8
Views: 542

Re: Click button on web page which has no element Id or Name

Here is html text of web page. Not sure how to click print button <div class="kn-info-bar"> <div class="kn-info kn-container"><div class="kn-crumbtrail"> <a href="#dataentry-home?" address="true">Data Entry Home</a> <span class="icon is-small is-transparent" style="margin: 0px 6px;"> <i class="fa fa...
by Pardeep Tariyal
08 Jul 2018, 02:49
Forum: Ask For Help
Topic: Click button on web page which has no element Id or Name
Replies: 8
Views: 542

Re: Click button on web page which has no element Id or Name

Here is my code: F1:: Pwb := ComObjCreate("InternetExplorer.Application") Pwb.Visible := False URL = website_url Pwb.Navigate(url) IELoad(pwb) parentNode := pwb.document.getElementsByClassName("kn-print")[0] parentNode.getElementsByTagName("a")[0].click() return I am getting this error Error: 0x8002...
by Pardeep Tariyal
30 Jun 2018, 03:25
Forum: Ask For Help
Topic: If Var in Matchlist "Text File"
Replies: 3
Views: 233

Re: If Var in Matchlist "Text File"

Would it works when matchlist is a text file.
Like one,two,three in a text file.

My text file has 22450 values. Like one,two,three and many more.

Go to advanced search