This could be a repeat post because my last attempt on posting sent me to a blank page.

Reply •Thanks • 2018/01/27 20:30:48 0 0

When I submitted my original post, I got a message that 9+8 does not equal 17 and I ended up on a blank page not knowing if my post was submitted or not..

Original title "Open spreadsheet and text file, copy and paste data from text file to spreadsheet?

Original questions "Almost 4 years ago I asked about this and it was not possible because BotChief could not open spreadsheets or copy anything to the clipboard. Has that changed? I have hundreds of text files with approximately 165 lines each and need to automate the copy, paste and save functions.
1. I need to open a spreadsheet and a text file, select and copy the data in the text file and paste it into the spreadsheet.
2. Select and copy the results in the spreadsheet to another text file and save the results."

Aprilcaicai

2018/01/29 16:45:47

Yes. This function is already here.

But please make sure the file format for Spreadsheet is CSV but not xlsx.

Use the Read File command first, then pull the data from CSV file to a Table Variable. Then use the Read File command to save the data from Table Variable to Txt file.

caliray

2018/01/31 18:28:33

Thank you.

Aprilcaicai

2018/02/01 09:59:55

My pleasure.

Please feel free to contact me if you need any more help.

caliray

2018/02/03 20:24:50

I admit that in my previous attempts to understand how Botchief Editor is used I had real problems understanding how to set up a properly structured script. Do you know of anyone who might do this for a reasonable price? I suspect the learning curve for me to get a properly structured script set up and working is far greater than having someone do it for me.