Convert English to Regex in Google Sheets with GPT3

The script uses OpenAI's GPT3 machine learning model to convert standard English statements into valid Regex. AllPosts 24/02/2022,SEO ConvertEnglishtoRegexinGoogleSheetswithGPT3 Watchthis(four-minute)videotolearnhowtoconvertEnglishtoRegexusingGPT3.  DoyoustrugglewithRegex?  DownloadacopyofmyGoogleSheetandscripttoputanendtoyourtears. EnteranEnglishdescriptionofthefilterrequiredinanycellandreceivearesponseincorrectly-formattedRegex.   ThescriptusesOpenAI’sGPT3machinelearningmodeltoconvertstandardEnglishstatementsintovalidRegex.  Youdon’tneedtobeespeciallyprecisewithyourdescription.Justmakesureanyrationalhumancouldreasonablyunderstandit.      WhatisGPT3? GPT3isapre-trainedmachinelearninglanguagepredictionmodelcapableofclassifyingwordsandphrasesintopre-determinedcategories. WhilethismaysoundlikeitbelongstothedomainofAIexperts,GPT3iseasytouseandcanbeappliedviaasimpleAPIrequest.   FreeEnglish>RegexConverterinGoogleSheets  IhavecreatedascriptinGoogleSheetstohelpyouconvertstandardEnglishtoRegexstatements.DescribetheRegexstatementyouneed,enterthefunction=GETREGEX(XX)intoanycellandallowGPT3toworkitsmagic.RemembertoreplacetheXXwiththecellcontainingyourEnglishdescription.e.g.=GETREGEX(B2).  Pleasewatchthevideoabovetoseeitinactionanddownloadacopyofthescripthere.   HowcanIuseit? 1)ThefirststepistoregisterafreeaccountatOpenAI.com Uponregistration,youwillbegiven$18worthoffreeAPIcredits. Onceregistered,grabacopyofyoursecretAPIkeyandsaveitonyourdevice.   2)DownloadacopyofmyfreeGoogleSheetandscriptdesignedtomakethisprocessaseasyaspossiblewithouthavingtounderstandorwriteanycode. 3)EnteryourAPIKeyfromStep1incellA2oftheGooglesheet. 4)EnteradescriptionofyourrequiredfilterinEnglishtocellB2,e.g.Containsthewords“dog”or“cat” Thewordsyouuseinthispromptwillimpactthequalityoftheoutput,somakesurethatyouexplainyourrequirementsclearly. 5)Addthefunction=GETREGEX(B2)tocellC2 6)AddanyadditionalrowsasrequiredincolumnBandcopytheformuladowntoalladjacentrowsincolumnC. Youmaybeaskedtograntthescriptpermissiontorunifthisisyourfirstattempt. 7)Afterashortdelay,youshouldreceivevalidRegexstatementsbasedontheEnglishdescriptionyouprovided. 8)Oncetheresultsarereceived,clickonthe“SaveValues”linkinthemainmenu.ThiswillconvertyourformulastoplaintextvaluesandpreventtheAPIfrombeingcalledwheneveryoumodifyaroworrefreshthesheet. Notes: TakealookatthescriptbehindthisfunctionbyselectingExtensions>AppsScriptfromthemainmenu.  Pleasewatchthe(4mins)videoabovetoseethescriptinactionandreceivevisualandverbalinstructions. Pleaseletmeknowhowyougeton.   Addendum Version1ofthisscriptreleasedon24/02/2022madeuseofOpenAI’s‘Codex’engine.IwasunawareatthattimethattheCodexenginewasstillinprivatebeta.Asaresult,someusersmayhaveexperiencedanerror,“Enginenotfound”whileusingV1ofthisscript.Pleaseacceptmysincereapologies. On25/02/2022,IupdatedthescriptandalllinksinthisposttoVersion2tousetheDavincienginewhichisnotinprivatebeta.Whentested,IfoundtheresultsproducedbytheDavincienginetobenolessaccuratethanusingtheCodexengine. IfyouexperiencedanyissueswithV1ofthescript,pleasedownloadacopyofV2here.Thiswillhopefullyresolveanyissues. Alternatively,ifyouprefertouseV1ofthescript,youcanapplytojointheCodexbeta.WhenIdidso,Iwasgrantedpermissionalmostimmediately.YoumayfindthatyougetslightlybetterresponsesusesCodexalthoughIhavenotnoticedanydifferencewhentesting.         Share: Facebook Linkedin Twitter Google+ Relatedposts 25/11/2019 HowtogetoutofaYell.comcontract Readmore 09/06/2020 ParliamentaryCallforInvestigationintoYell.comMisselling Readmore 19/09/2016 Whatdoesyourwebsiterevealaboutyourbusiness? Readmore Thiswebsiteusescookiestoimproveyourexperience.Bycontinuingtousethissiteyouareagreeingtotheuseofcookies.Privacy&CookiesPolicy Close PrivacyOverview Thiswebsiteusescookiestoimproveyourexperiencewhileyounavigatethroughthewebsite.Outofthese,thecookiesthatarecategorizedasnecessaryarestoredonyourbrowserastheyareessentialfortheworkingofbasicfunctionalitiesofthewebsite.Wealsousethird-partycookiesthathelpusanalyzeandunderstandhowyouusethiswebsite.Thesecookieswillbestoredinyourbrowseronlywithyourconsent.Youalsohavetheoptiontoopt-outofthesecookies.Butoptingoutofsomeofthesecookiesmayaffectyourbrowsingexperience. Necessary Necessary AlwaysEnabled Necessarycookiesareabsolutelyessentialforthewebsitetofunctionproperly.Thiscategoryonlyincludescookiesthatensuresbasicfunctionalitiesandsecurityfeaturesofthewebsite.Thesecookiesdonotstoreanypersonalinformation. Non-necessary Non-necessary Anycookiesthatmaynotbeparticularlynecessaryforthewebsitetofunctionandisusedspecificallytocollectuserpersonaldataviaanalytics,ads,otherembeddedcontentsaretermedasnon-necessarycookies.Itismandatorytoprocureuserconsentpriortorunningthesecookiesonyourwebsite. SAVE&ACCEPT