Search the Community

Hi everyone! I recently started working after college and we use a lot of excel. As I was searching for ways to improve efficiency I came across AutoIt, so I decided to learn. I've put in some hours of reading through the search function on the website and the AutoIt library for my issue, but I cannot seem to find my answer and I am having trouble understanding some stuff. What I am trying to do is get AutoIt to paste a string into several different boxes. I want the script to know that each '-' in the copied text it should press tab and skip past the '-' and paste/type the following numbers. Here's an example of the text I will copy and press a F5 (eventually set up a hotkey) to run the script: 0123-456-7891-01112131-000-1234-456 Here's my code so far: (Btw, I know the ending of the code doesn't make sense, I was editing it and what not, it's just that I don't know how to efficiently use the clipget() and stringsplit() functions. #RequireAdmin AutoItSetOption('MouseCoordMode',0) WinWait('Oracle Applications - XXXX Production') WinActivate('Oracle Applications - XXXX Production') MouseClick('primary', 38, 408, 2, 0) StringSplit(ClipGet(),"-") Send("{TAB}") Send(ClipGet()) I would like to paste it in the box in the attached picture. Even if there is not a way for autoit to skip past the '-' I can just copy the entire string without the '-' and I would like autoit to paste the first 4, then press tab, paste the next 3, press tab, etc etc. Any of those methods work. Thank you for taking the time to read through this and attempting to responding!