256 Kilobytes

Scripting and Automation

Type All Category Scripting and AutomationInformation and discussion of scripting of various types. Tag All

Profile Photo - Some Guy
Profile Photo - Some Guy

I am not an expert when it comes to Pyth...

MoreI am not an expert when it comes to Python, but I like to think I have a good handle on it. My most recent problem has left me stumped, though. How do...
🗨 0
🐏 0
👁 351
Profile Photo - Some Guy
Profile Photo - Some Guy

I am not exactly an old hand when it com...

MoreI am not exactly an old hand when it comes to DataFrame, but I like to think I have been getting the hang of it. The message "Number of items to...
🗨 0
🐏 0
👁 569
Profile Photo - Some Guy

How to change series name in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

I have just recently started working in...

MoreI have just recently started working in Excel rather than Google Sheets, and I am running into all kinds of minor issues due to the new interface. How...
🗨 0
🐏 0
👁 406
Profile Photo - Some Guy

How to normalize data in Excel?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - Some Guy

I've recently started using Excel,...

MoreI've recently started using Excel, and while I think I have a pretty good grasp of the general program, I cannot for the life of me figure out ho...
🗨 0
🐏 0
👁 427
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplyFucking all of them. Such as Vim, Nano (if from the command line/terminal). Graphical text editors like Gedit, Sublime Text, and Notepad++... August R. Garcia,

Fucking all of them.

Sun, 09 Dec 2018 23:29:19 -08003 years ago1
🗨 1
🐏 0
👁 367
Profile Photo - August R. Garcia

[Google Sheets] How to use escape characters to add conditional formatting for "if cell contains a question mark"

Answers in Spreadsheets | By August R. Garcia

Published | Last Update

Profile Photo - August R. Garcia

Normally, to use conditional formatting...

MoreNormally, to use conditional formatting to highlight all cells that contain a particular character (or string), the following steps would be used:...
🗨 0
🐏 0
👁 443
Profile Photo - Some Guy

[Google Sheets] How to get the largest number in a range?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplySee the MAX function: https://support.google.com/docs/answer/3094013?hl=en August R. Garcia,

See the MAX function:

Tue, 04 Dec 2018 17:59:42 -08003 years ago1
🗨 1
🐏 0
👁 335
Profile Photo - Some Guy

How to exit Vim? Not sure how to save and quit Vim...

Answers in Scripting and Automation | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyPress ESC to make sure you are in command mode (also known as normal mode) Type a colon to open start writing a command (which will show up at th... August R. Garcia,

Tue, 04 Dec 2018 17:56:31 -08003 years ago1
🗨 1
🐏 0
👁 338
Profile Photo - Hash Brown

The Google Introduction to Machine Learning

Forum in Machine Learning | By Hash Brown

Published | Last Update

Profile Photo - August R. Garcia

Last ReplyAnother guide on a similar topic is TensorFlow for Poets: https://codelabs.developers.google.com/codelabs/tensorflow-for-poets/#0 Which cov... August R. Garcia,

Another guide on a simila...

Mon, 03 Dec 2018 23:28:20 -08003 years ago1
🗨 1
🐏 0
👁 799
Profile Photo - Some Guy

Best way to import JSON to Google Sheets?

Answers in Spreadsheets | By Some Guy

Published | Last Update

Profile Photo - Hash Brown

Last ReplyAnother option would be to convert the JSON to CSV using an online tool like this: https://json-csv.com/ Hash Brown,

Another option would be t...

Mon, 03 Dec 2018 14:00:23 -08003 years ago1
🗨 2
🐏 0
👁 654
Profile Photo - Some Guy

Google Sheets Gantt Chart Template

Answers in Spreadsheets | By Some Guy

Published | Last Update

Profile Photo - Hash Brown

Last ReplySuper useful, thank you! Hash Brown,

Super useful, thank you!

Mon, 03 Dec 2018 13:54:58 -08003 years ago1
🗨 1
🐏 0
👁 482
Profile Photo - Some Guy

Scraping results from Google Search

Forum in Web Scraping, Data Analysis | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyIf you're going to do this in any real volume you're going to get IP blocked pretty quick, even on Google Sheets. If I were you I would loo... Hash Brown,

If you're going to do...

Mon, 03 Dec 2018 13:46:23 -08003 years ago1
🗨 1
🐏 0
👁 629
Profile Photo - Some Guy

What are Hamming and Levenshtein distance?

Answers in Scripting and Automation | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplySure, let me help you at a basic level. Both terms come from information theory, they are a string metric to evaluate two values and basically meas... Hash Brown,

Sure, let me help you at...

Mon, 03 Dec 2018 13:31:34 -08003 years ago1
🗨 1
🐏 0
👁 321
Profile Photo - Some Guy

Why is VLookup supposedly so useful in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published | Last Update

Profile Photo - Hash Brown

Last ReplyIt depends what you are trying to do in Google Sheets, if you don't need the function and never use it then I guess it's just another function... Hash Brown,

It depends what you are t...

Mon, 03 Dec 2018 13:05:04 -08003 years ago1
🗨 1
🐏 0
👁 432
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last ReplyThere is a function called scandir. <?php $directory = '/path/to/directory'; scandir($directory); ?> This will output your directory... Hash Brown,

There is a function calle...

Mon, 03 Dec 2018 12:54:16 -08003 years ago1
🗨 1
🐏 0
👁 398
Profile Photo - Some Guy

How to implement an algorithm to calculate Levenshtein distance in JavaScript?

Answers in Scripting and Automation | By Some Guy

Published | Last Update

Profile Photo - Hash Brown

Last ReplyHere you go: function levenshteinDistance (str1, str2) { if (!str1.length) return str2.length; if (!str2.length) return str1.length;... Hash Brown,

Here you go:

Mon, 03 Dec 2018 12:48:11 -08003 years ago1
🗨 1
🐏 0
👁 336
Profile Photo - Some Guy

Pls halp: Google Sheets' REPT function uses same random number for all repetitions.

Answers in Spreadsheets | By Some Guy

Published | Last Update

Profile Photo - August R. Garcia

Last ReplyAm fairly sure that this is not supported in Google Sheets. It might be possible to emulate behavior for your specific use case through a... August R. Garcia,

Am fairly sure that this...

Sun, 02 Dec 2018 12:25:48 -08003 years ago1
🗨 1
🐏 0
👁 476
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplyTo extract between brackets: =REGEXEXTRACT(B113, "[(.*?)]") Also, see this thread: https://www.256kilobytes.com/content/sh... August R. Garcia,

To extract between bracke...

Sun, 02 Dec 2018 03:49:46 -08003 years ago1
🗨 1
🐏 0
👁 451
Profile Photo - Some Guy

[Google Sheets] Extract text from parentheses?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplySee this thread: https://www.256kilobytes.com/content/show/230/google-sheets-how-to-extract-text-between-parentheses-or-brackets You also... August R. Garcia,

See this thread:

Sun, 02 Dec 2018 03:49:42 -08003 years ago1
🗨 1
🐏 0
👁 431
Profile Photo - Some Guy

How to create drop down list in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplySelect the range you want to add drop down menus to Right click --> Data Validation Set conditions/values August R. Garcia,

Sun, 02 Dec 2018 03:49:27 -08003 years ago1
🗨 1
🐏 0
👁 384
Profile Photo - Some Guy

How to generate a random IP address in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyThis formula works for a random IPv4 address:=RANDBETWEEN(1,255)&"."&RANDBETWEEN(1,255)&"."&RANDBETWEEN(1,255)&amp... August R. Garcia,

This formula works for a...

Sun, 02 Dec 2018 03:49:18 -08003 years ago1
🗨 1
🐏 0
👁 394
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplyTry this: =char(COLUMN(A1)+64) August R. Garcia,

Try this:

Sun, 02 Dec 2018 03:49:17 -08003 years ago1
🗨 1
🐏 0
👁 352
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplyMight be covered here: Google products use RE2 for regular expressions. Google Sheets supports RE2 except Unicode character class matching. Learn... August R. Garcia,

Might be covered here:

Sun, 02 Dec 2018 03:49:09 -08003 years ago1
🗨 1
🐏 0
👁 490
Profile Photo - Some Guy

Can you use Machine Learning to solve reCaptcha v2?

Forum in Machine Learning | By Some Guy

Published | Last Update

Profile Photo - August R. Garcia

Last ReplyYes, it's possible. And yes, most bots that can click pictures of cars will use machine learning in some way.Roughly six months, I wrote a reCapt... August R. Garcia,

Yes, it's possible....

Sun, 02 Dec 2018 03:48:50 -08003 years ago1
🗨 1
🐏 0
👁 836
Profile Photo - Some Guy

How to get word count of a cell using Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyCan be done with:=COUNTA(SPLIT(A2, " "))https://www.techjunkie.com/word-count-google-sheets/Seems to returns 1 on empty cells -- adjustment... August R. Garcia,

Can be done with:=COUNTA(...

Sun, 02 Dec 2018 03:48:43 -08003 years ago1
🗨 1
🐏 0
👁 453
Profile Photo - Some Guy

[Halp] Remove non-alphanumeric in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - August R. Garcia

Last Reply// Remove non-alphanumeric =REGEXREPLACE(lower(E2), "[^A-Za-z0-9]", "") // Replace non-alphanumeric with a space =REGEXREPLACE(lower(E2), "[^A-... August R. Garcia,

Sun, 02 Dec 2018 03:48:21 -08003 years ago1
🗨 1
🐏 0
👁 820
Profile Photo - Some Guy

Alternatives to Microsoft Access?

Forum in Spreadsheets | By Some Guy

Published | Last Update

Profile Photo - August R. Garcia

Last ReplyThere is Libreoffice Base: http://www.thefrugalcomputerguy.com/libreoffice-base/Overview.php https://www.libreoffice.org/discover/base/... August R. Garcia,

There is Libreoffice Base...

Sun, 02 Dec 2018 03:48:13 -08003 years ago1
🗨 1
🐏 0
👁 526
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplySomething like this should work:# "First Last" --> Email=REGEXREPLACE(lower(A1)&RANDBETWEEN(1,999), "([^A-Za-z0-9]+)", &quo... August R. Garcia,

Something like this shoul...

Sun, 02 Dec 2018 03:48:05 -08003 years ago1
🗨 1
🐏 0
👁 386
Profile Photo - Some Guy

[JavaScript/Google Apps Script] Remove newlines in a Script Editor function?

Answers in Spreadsheets | By Some Guy

Published | Last Update

Profile Photo - August R. Garcia

Last ReplyThe script editor is essentially the same as JavaScript. This line should work for most cases: t = t.replace(/ /gm,""); August R. Garcia,

The script editor is esse...

Sun, 02 Dec 2018 03:48:02 -08003 years ago1
🗨 1
🐏 0
👁 391
Profile Photo - Some Guy

How does concatenation work in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyCONCATENATE works with ranges. https://support.google.com/docs/answer/3094123There is also the JOIN function, which works with ranges and allows a spe... August R. Garcia,

CONCATENATE works with ra...

Sun, 02 Dec 2018 03:47:48 -08003 years ago1
🗨 1
🐏 0
👁 392