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...

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...

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...

Thank you!

Thank You!

I will take a look at this and play around.

Thanks again for helping this beginner.

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...

Any ideas? GetTextInRect>left,top,right,bottom,result_variable does not work, and i'm using adobe.

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.

I think it may have something to do with a dollar sign in amount?

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...

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!

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...

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

i.e. ndate=11 22 33

Thanks!

This ended up working, thank you!

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...