256 Kilobytes

Scripting and Automation Answers

Type AnswersAsk and answer questions, if that is something that you want to do. Category Scripting and AutomationInformation and discussion of scripting of various types. Tag All

Profile Photo - Some Guy

How to tab in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 1 month agoWed, 06 Feb 2019 15:02:45 -0800

Profile Photo - roxblade

Last Reply I believe you mean another sheet, right? On the bottom of the screen, you will find a bar that houses your sheet on the left. Further left and, in fac... roxblade,

I believe you mean anothe...

Thu, 21 Mar 2019 01:07:37 -0700 4 days ago
🗨
1
🐏
0
👁
39
Profile Photo - Twostntle
Profile Photo - entrokamoI

Last Reply ls isn't actually a built-in for Windows. It's a command meant to be used on Unix machines such as those running MacOS or Linux. If you want to achiev... entrokamoI,

ls isn't actually a built...

Wed, 20 Mar 2019 17:33:24 -0700 4 days ago
🗨
1
🐏
0
👁
5
Profile Photo - NelsAmmo

Best PowerShell scripting tutorials?

Answers in Shell Scripting | By NelsAmmo

Published 5 days agoTue, 19 Mar 2019 15:12:54 -0700

Profile Photo - Japanese

Last Reply Since this was developed by Microsoft in 2003, it makes sense to start with Microsoft tutorials. Microsoft Virtual Academy (MVA) has many tutorials on... Japanese,

Since this was developed...

Wed, 20 Mar 2019 14:25:13 -0700 4 days ago
🗨
1
🐏
0
👁
4
Profile Photo - sewlaw

What Bash scripting keyword terminates a case statement?

Answers in Shell Scripting | By sewlaw

Published 6 days agoTue, 19 Mar 2019 02:09:14 -0700

Profile Photo - Edgelady43069

Last Reply The Base scripting keyword that terminates a case statement is esac to end a case statement. Which is actually case spelled backwards. Edgelady43069,

The Base scripting keywor...

Wed, 20 Mar 2019 06:10:44 -0700 4 days ago
🗨
1
🐏
0
👁
4
Profile Photo - pls_stop_this

How do you know whether a PowerShell tutorial is good or not?

Answers in Shell Scripting | By pls_stop_this

Published 5 days agoTue, 19 Mar 2019 15:07:00 -0700

Profile Photo - Zhaybib

Last Reply Many people who are interested in learning PowerShell, will seek out a tutorial on the internet to help. Not all tutorials are created equal, but I wo... Zhaybib,

Many people who are inter...

Wed, 20 Mar 2019 05:10:56 -0700 4 days ago
🗨
1
🐏
0
👁
3
Profile Photo - SMVVR2

Best way to rename part of filename in multiple files?

Answers in Scripting and Automation | By SMVVR2

Published 5 days agoTue, 19 Mar 2019 07:05:20 -0700

Profile Photo - Edgelady43069

Last Reply This is the easiest and quickest way: 1. Open File Explorer. 2. Browse to the folder that includes all the files you want to rename. 3. Select the fir... Edgelady43069,

This is the easiest and q...

Wed, 20 Mar 2019 02:02:20 -0700 5 days ago
🗨
1
🐏
0
👁
5
Profile Photo - Some Guy

How to fix input lag on PC?

Answers in Machine Learning | By Some Guy

Published 1 month agoWed, 06 Feb 2019 16:08:31 -0800

Profile Photo - roxblade

Last Reply  > The obvious factor is to use game mode.  > HDMI-CEC must be disabled.  > Ambient screen dimming or any power saving setti... roxblade,

 > The obvious fa...

Thu, 28 Feb 2019 13:10:21 -0800 3 weeks ago
🗨
1
🐏
0
👁
64
Profile Photo - Some Guy

How to alphabetize content in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 3 months agoSun, 02 Dec 2018 03:42:37 -0800

Profile Photo - roxblade

Last Reply  > Open a spreadsheet in Google Docs.  > Select the group of cells that are to be sorted.  > Select Data and then > Sort... roxblade,

 > Open a spreads...

Wed, 27 Feb 2019 15:49:29 -0800 3 weeks ago
🗨
1
🐏
0
👁
46
Profile Photo - Some Guy

[Google Sheets] Conditional formatting based on row value?

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:11:34 -0800

Profile Photo - roxblade

Last Reply Highlight the data range you want to conditionally format. Choose Format from the top menu > Select Conditional Formatting from the D... roxblade,

Wed, 27 Feb 2019 15:43:19 -0800 3 weeks ago
🗨
1
🐏
0
👁
40
Profile Photo - Some Guy

How to freeze a row in Excel?

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:11:54 -0800

Profile Photo - roxblade

Last Reply 1. Open Excel > Open the Spreadsheet you want to edit. 2. Select the row below the rows that you want to freeze. Example: To Freeze Row 1, Selec... roxblade,

1. Open Excel > Open t...

Wed, 27 Feb 2019 15:42:44 -0800 3 weeks ago
🗨
1
🐏
0
👁
42
Profile Photo - Some Guy

How to merge cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:13:24 -0800

Profile Photo - roxblade

Last Reply 1. Open Google Sheets. 2. Open the file. 3. Select the cells you want to merge. 4. Click on the merge option on the above toolbar. The merge... roxblade,

1. Open Google Sheets.<br...

Wed, 27 Feb 2019 15:42:16 -0800 3 weeks ago
🗨
1
🐏
0
👁
42
Profile Photo - Some Guy

How to wrap text in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:13:34 -0800

Profile Photo - roxblade

Last Reply 1. Select the cells to be wrapped. 2. On the Menu, click on Format. 3. On the Menu > Click on Text Wrapping > Select Wrap. 4. The proce... roxblade,

1. Select the cells to be...

Wed, 27 Feb 2019 15:41:49 -0800 3 weeks ago
🗨
1
🐏
0
👁
46
Profile Photo - Some Guy

How to lock a row in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:13:44 -0800

Profile Photo - roxblade

Last Reply 1. Open Google Sheets. 2. Go to the View Menu. 3. Point your mouse to Freeze Rows. 4. You will be able to see the Frozen Rows. roxblade,

1. Open Google Sheets.<br...

Wed, 27 Feb 2019 15:41:27 -0800 3 weeks ago
🗨
1
🐏
0
👁
37
Profile Photo - Some Guy

Fix for "Excel there was a problem sending the command to the program?"

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:14:14 -0800

Profile Photo - roxblade

Last Reply This error might have happened due to Dynamic Data Exchange feature in Microsoft Office. The simple solution is to disable it. 1. Open Excel &gt... roxblade,

This error might have hap...

Wed, 27 Feb 2019 15:41:06 -0800 3 weeks ago
🗨
1
🐏
0
👁
55
Profile Photo - Some Guy

How to make a drop down list in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:14:24 -0800

Profile Photo - roxblade

Last Reply  Open Google Sheets. Select the cells for creating the drop-down menu. Data > Data Validation. There will be an optio... roxblade,

 Open Google Sheets....

Wed, 27 Feb 2019 15:40:30 -0800 3 weeks ago
🗨
1
🐏
0
👁
49
Profile Photo - Some Guy

How to sort in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:13:54 -0800

Profile Photo - roxblade

Last Reply 1. Open Google Sheets. 2. Select the number of rows/columns / cells. Click on the top left corner to sort the entire sheet. 3. Click on Data &gt... roxblade,

1. Open Google Sheets.<br...

Wed, 27 Feb 2019 15:39:16 -0800 3 weeks ago
🗨
1
🐏
0
👁
43
Profile Photo - Some Guy

How to add columns in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:14:04 -0800

Profile Photo - roxblade

Last Reply 1. Open Spreadsheet in Google Sheets. 2. Select the number of rows or columns you want to add. ( Mac Command + click, Windows Ctrl + Click). 3.... roxblade,

1. Open Spreadsheet in Go...

Wed, 27 Feb 2019 15:37:52 -0800 3 weeks ago
🗨
1
🐏
0
👁
52
Profile Photo - Some Guy

How to zoom out in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:14:34 -0800

Profile Photo - roxblade

Last Reply 1. Open Google Sheets. 2. Click on 100% on the toolbar and you will see values from 50-200 appear. 3. Select 50/75 if you want to zoom out. roxblade,

1. Open Google Sheets.<br...

Wed, 27 Feb 2019 15:35:43 -0800 3 weeks ago
🗨
1
🐏
0
👁
49
Profile Photo - Some Guy

How to rename a file in Linux?

Answers in Shell Scripting | By Some Guy

Published 2 months agoSun, 13 Jan 2019 04:14:44 -0800

Profile Photo - roxblade

Last Reply An easy way to rename files in Linux is through the mv command, short form for the move. It is used to move files from one place to another but can al... roxblade,

An easy way to rename fil...

Wed, 27 Feb 2019 15:35:22 -0800 3 weeks ago
🗨
1
🐏
0
👁
38
Profile Photo - Some Guy
Profile Photo - roxblade

Last Reply Pickle protocol can be simply referred to as the file format. The higher the protocol is, the more recent version of python is what you need to read t... roxblade,

Pickle protocol can be si...

Wed, 27 Feb 2019 13:31:12 -0800 3 weeks ago
🗨
1
🐏
0
👁
106
Profile Photo - Some Guy
Profile Photo - Default

Last Reply This error TypeError: document.getelementbyid(...) is null would seem to indicate that there is no such element with an ID passed to getElementById()... jacobhalls,

This error TypeError: doc...

Sun, 24 Feb 2019 21:30:19 -0800 1 month ago
🗨
1
🐏
0
👁
71
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last Reply Hello, You're trying to decode a JSON string by the sound of it. The most common errors for these sorts of things are: The JSON string is not... Hash Brown,

Hello,

Thu, 21 Feb 2019 14:37:41 -0800 1 month ago
🗨
1
🐏
0
👁
66
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last Reply >Can you find me a forum entry on a coding site that deals with fixing this exact type error? k. These errors are ususally created when you c... Hash Brown,

>Can you find me a for...

Wed, 20 Feb 2019 06:09:44 -0800 1 month ago
🗨
1
🐏
0
👁
177
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last Reply Python 3 docs say: "Construct an iterator from those elements of iterable for which function returns true." Source: https://docs.python... Hash Brown,

Python 3 docs say:

Wed, 20 Feb 2019 04:39:57 -0800 1 month ago
🗨
1
🐏
0
👁
62
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last Reply Hey, So NaN values (not a number) are normally used when values are likely to be so large they don't fit into a standard double. for example if... Hash Brown,

Hey,

Wed, 20 Feb 2019 04:20:31 -0800 1 month ago
🗨
1
🐏
0
👁
269
Profile Photo - Some Guy
Profile Photo - Hash Brown

Last Reply Hello dude, len() gets the length of a string. The data passed to it has to be a string, that's just how it works. So if you're trying to pass a... Hash Brown,

Hello dude,

Wed, 20 Feb 2019 03:40:58 -0800 1 month ago
🗨
1
🐏
0
👁
71
Profile Photo - Some Guy

Solve "Typeerror: unhashable type: 'list'"?

Answers in Scripting and Automation | By Some Guy

Published 3 months agoSun, 16 Dec 2018 09:34:42 -0800

Profile Photo - Default

Last Reply The hash() is a built-in python method, used to return a unique number . This can be applied to any user-defined object which won’t get changed... aldrinjohn,

The hash() is a built-in...

Mon, 11 Feb 2019 02:35:23 -0800 1 month ago
🗨
1
🐏
0
👁
85
Profile Photo - Some Guy

How can I bulk rename files from the Linux terminal?

Answers in Shell Scripting | By Some Guy

Published 1 month agoSun, 10 Feb 2019 23:12:04 -0800 | Last update 1 month agoSun, 10 Feb 2019 23:19:39 -0800

Profile Photo - August R. Garcia

Last Reply Try the rename command. Syntax: Basic syntax: rename (option) 's/oldname/newname/' file1.txt file2.txt Test a rename regex on all file... August R. Garcia,

Try the rename command. S...

Sun, 10 Feb 2019 23:19:24 -0800 1 month ago
🗨
1
🐏
0
👁
61
Profile Photo - Some Guy
Profile Photo - roxblade

Last Reply You're trying to change a part of a string. That isn't supported by many object-oriented programming languages. Unicode objects like * are used to cha... roxblade,

You're trying to change a...

Thu, 07 Feb 2019 02:52:20 -0800 1 month ago
🗨
1
🐏
0
👁
49
Profile Photo - Some Guy

[Python] How can I fix "TypeError: a float is required?"

Answers in Scripting and Automation | By Some Guy

Published 2 months agoSun, 13 Jan 2019 05:43:50 -0800

Profile Photo - roxblade

Last Reply This error usually throws up when you think you're adding a float element to the argument but you're not.This problem most commonly arises from the us... roxblade,

This error usually throws...

Thu, 07 Feb 2019 02:45:42 -0800 1 month ago
🗨
1
🐏
0
👁
52