Transcript

hey my name is luke and this is the response to the scripting challenge to take out the pesky quotes um from google sheets actually just tried it and it seemed to be working for me but just yesterday it was doing the same thing so if i go here and then paste it it's not having the quotes but um it does happen so there might be a formatting way to take it out but let's go ahead and do it with terminal and the shortcut so essentially what we're going to do is we're going to take out the first character and take out the last we don't want to just take out all quotes because if you have quotes inside it'll take those out too now what i use is a terminal command to basically do some stuff to the clipboard so we'll put the contents on the clipboard take out the first then we'll reverse it take out the first again and then reverse it back and then put it back on the clipboard so what i did was just basically did some searching and like figured out how to cut a first character from a string so i just searched terminal remove first character so let's go ahead and do some stuff in terminal okay so i'm going to go ahead and do productivity shop and i'm gonna i'm gonna edit command c so i'm gonna do pb paste test.txt so it's gonna put the pasteboard on a text file and then we'll read the text file okay so it says productivity shop cool now what i'm going to do is i'm going to okay so i'm going to put it on the paste board again and then i'm going to pipe it which means it'll pass the contents of whatever is in front of the pipe to the next thing so i'm gonna do cut c one dash and then put that in file two dot txt then i'll cat file two okay so apparently there's a character in front of productivity shop so let's go ahead and take out two characters so i'm gonna do i'm gonna copy productivity shop i'm gonna do pb paste cut it two times and put it in file five txt cool so you see that the p was taken off so let's go ahead and try it with the google cheat stuff so i'm going to do command c pb paste and i'll put it in file six okay so it took off the first quote perfect okay so i'm gonna go ahead and copy it again copy the original and we're gonna do pb paste boom cut the first two characters boom reverse it and then we'll put that in file seven okay so now let's go ahead and open file seven i'm gonna copy it then i'm gonna go pb paste cut one and put it in file eight okay that didn't work so it needs to be two okay so let's try this i'm gonna start over i'm gonna copy it i term okay pb paste pipe cut two characters and then reverse it and then cut two characters and then reverse it back and then put it in file 10. perfect it took out the quotes okay so we're almost there now instead of putting it in a file we'll just put it back on the pasteboard okay so i'm going to go ahead and go to google sheets okay i'm gonna do pb paste cut two characters reverse it cut two characters reverse it and then put it back on i think it's like this so if i go to eyewriter it worked so you just need the pipe okay so but it also adds a line at the end and i have something for that okay so we'll do this i'm gonna go ahead and copy this so i don't have to keep typing it usually what i do is i go and add them and i'll try things out and keep a record of what i'm doing okay so this will be trim ending okay so i'm gonna go ahead and copy this actually copy this put it in terminal and then i'll copy this put it on the pasteboard and then run this code i'm going to go to iwriter and paste perfect the cursor is at the end now let's put it in an apple script so this will be our code for the apple script i'll call it pesky quotes okay so we'll do shell script and then put in our script totally wrong okay now with apple script you need some extra things for the quotes so you just put a slash in front of this and it'll run okay so what we'll do is we'll say hey do command c and then run the clipboard through our terminal command that we just made and then put it back on the baseboard okay all right so i'm gonna click here i'm gonna do i'll do some new text i use a little ipsum for like text stuff okay i'm gonna put the quotes all right so i'm gonna do command c i'm gonna run pesky quotes okay now it should paste this text without the quotes fingers crossed and i'll talk about soft wrap cool it worked now let's go ahead and save this we'll save pesky quotes and we'll tie it to a keyboard shortcut specifically for this it with better touch tool so i'm going to go to better touch tool you would want to put the script pesky quote somewhere where it can live forever in your file catalog check out my other video okay so i'm going to we'll just do it for google chrome okay so i'm going to do a new keyboard shortcut i'm going to do plus sign we'll do command let's see what is available in chrome we'll do control c instead of command c for copy we'll do control c for pesky quotes copy okay so i'll click here do control c and then assign first action to select a trigger go to the apple script and navigate to the applescript file okay go to the desktop choose pesky quotes save better touch tool restart better touch tool go to chrome okay so let's test it out i'm going to do command c and paste so it's the normal copy and paste there are the quotes now i'm going to do control c and paste boom no quotes wacom tablet welcome pen tablet drop i'm just kidding um but yeah um hope you learned something cool um i'll just provide the script at the end and do some chapters and stuff but anyway thanks so much for watching and sending in the challenge later another one bites the dust whew