Search found 17 matches

by CGooley
Mon Jul 08, 2019 6:25 pm
Forum: Technical / Scripting
Topic: Return Value Given Code
Replies: 3
Views: 2635

Re: Return Value Given Code

Thank you for your help! I figured this out today: not sure if your solution is a more robust option. I will look and see! CSVFileToArray>filepath.csv,csvData If>csvData_count>0 Let>row=0 Repeat>field1 Let>row=row+1 Let>field1=csvData_%row%_0 Let>field2=csvData_%row%_1 Until>field1=identifier_2 Endi...
by CGooley
Mon Jul 08, 2019 1:41 pm
Forum: Technical / Scripting
Topic: Return Value Given Code
Replies: 3
Views: 2635

Return Value Given Code

Hello Everyone, I am wondering about the best way to return a value given another paired value in a list of paired values. For example: companycode=A00123 In an excel file, I have: Col 1. Col 2. Code Company Name A00123 Acme Industries B00213 Fake Company B00323 Onewordcompany ...and I would like to...
by CGooley
Fri Jul 05, 2019 5:10 pm
Forum: Technical / Scripting
Topic: Rename File Trouble
Replies: 10
Views: 5249

Re: Rename File Trouble

Hi JRL, I think I have to go this route, as even the VB script encounters a renaming issue, due to the way OCR is capturing. In the validation script you provided, Is there some reason why my message output would be vSTrN/Code? I couldn't find any errors. Let me know what you think? Thanks again for...
by CGooley
Fri Jul 05, 2019 11:48 am
Forum: Technical / Scripting
Topic: Rename File Trouble
Replies: 10
Views: 5249

Re: Rename File Trouble

Thank you!
by CGooley
Wed Jul 03, 2019 7:31 pm
Forum: Technical / Scripting
Topic: Functionality Like Python Dictionary
Replies: 3
Views: 2754

Re: Functionality Like Python Dictionary

Thank You!

I will take a look at this and play around.

Thanks again for helping this beginner.
by CGooley
Wed Jul 03, 2019 6:50 pm
Forum: Technical / Scripting
Topic: Rename File Trouble
Replies: 10
Views: 5249

Re: Rename File Trouble

Thanks! As an update, I found it has something to do with OCR area, and that I can clean the string by sending it to the clipboard, pasting into a search bar, and then copying that and getting the string off the clipboard. There has to be an easy way to do this? I assume there's some format function...
by CGooley
Wed Jul 03, 2019 4:17 pm
Forum: Technical / Scripting
Topic: Rename File Trouble
Replies: 10
Views: 5249

Re: Rename File Trouble

Any ideas? GetTextInRect>left,top,right,bottom,result_variable does not work, and i'm using adobe.
by CGooley
Wed Jul 03, 2019 4:16 pm
Forum: Technical / Scripting
Topic: Rename File Trouble
Replies: 10
Views: 5249

Re: Rename File Trouble

Nope, it has to do with OCRArea, and the value stored in this variable. For some reason, the rename file function will not pass the values of these variables.
by CGooley
Wed Jul 03, 2019 3:47 pm
Forum: Technical / Scripting
Topic: Rename File Trouble
Replies: 10
Views: 5249

Re: Rename File Trouble

I think it may have something to do with a dollar sign in amount?
by CGooley
Wed Jul 03, 2019 2:57 pm
Forum: Technical / Scripting
Topic: Rename File Trouble
Replies: 10
Views: 5249

Rename File Trouble

Hi, Having trouble using rename file, for some reason this code below does not appear to work. (The file is still named the same) Any help you may be able to offer is greatly appreciated. Results from code at bottom: CF Result = True, CF Result Code= 123, message>file =S:\Accounting\Confidential\@Sc...
by CGooley
Mon Jul 01, 2019 4:51 pm
Forum: Technical / Scripting
Topic: Functionality Like Python Dictionary
Replies: 3
Views: 2754

Functionality Like Python Dictionary

Hi,

I'm wondering if there is a functionality like a dictionary (https://www.w3schools.com/python/python ... naries.asp), where I can associate a list of values with their definitions.

I'm currently using if statements to achieve this, but perhaps there is a better way? Thanks!
by CGooley
Fri Jun 28, 2019 7:13 pm
Forum: Technical / Scripting
Topic: Writing Variable to Textbox in External Program
Replies: 1
Views: 1769

Writing Variable to Textbox in External Program

Separate>filename, ,identifier PutClipBoard>identifier_2 Hello, I have a filename that I have separated, but I cannot figure out how to pass the variables containing the separated parts to an external textbox. I tried; Send>identifier_2 and also attempted copying the variable to the clipboard and pa...
by CGooley
Fri Jun 28, 2019 6:06 pm
Forum: Technical / Scripting
Topic: Return partial variables within string
Replies: 5
Views: 3561

Re: Return partial variables within string

If ndate was separated by spaces instead of "/", how would I handle that?

i.e. ndate=11 22 33

Thanks!
by CGooley
Wed Jun 26, 2019 6:23 pm
Forum: Technical / Scripting
Topic: Hyphen as A String in a Variable??
Replies: 2
Views: 1969

Re: Hyphen as A String in a Variable??

This ended up working, thank you!
by CGooley
Wed Jun 26, 2019 6:19 pm
Forum: Technical / Scripting
Topic: Copy last three characters of a variable to a new variable
Replies: 5
Views: 3349

Re: Copy last three characters of a variable to a new variable

Here is how I am currently trying to do this: GetClipBoard>filename Let>filenamelength={length(%filename%)} Let>count=filenamelength-3 Let>at={Pos(" ",%filename%)} Let>branch={copy(%filename%,count,%at%-1)} message>branch Branch should return the last 3 characters, but only does this if I specify ma...
Sign up to our newsletter for free automation tips, tricks & discounts