Blog

Before using Scenario Manager, Microsoft recommends that you assign ____________ to all the input and results cells that you intend to use in your scenarios. They will automatically appear in Scenario Manager’s dialog boxes and reports.

Give a sed command to, when given a file, replace all occurrences of dog, regardless of whether the first letter is uppercase or not, with cat. The rest of it, “og”, must be lowercase in order for it to be replaced.

What category or type of function is the CHOOSE function?

In a file named Data each line has the format (where the names are only letters and the age is a number: lastName:firstName:age   Write a line in bash that would replace the : with a comma in our file, but redirect the output to a new file called DifferentSeparator.  

Give me a single grep line that would match all lines that starts with any number of digits and ends with any number of lowercase letters. For example, a file called “34626aabcd”

Write a sed command that will add a tab to the beginning of every line. 

What is the difference between the “man” command and the “help” command?

Write a script that takes in a single argument, which is a string of words separated separated by colons. For example, a possible input would be “The:cat:and:the:hat”. Your script should tokenize that string and search your current directory for any file with any of those names. For example, given the string above, your code would look for strings named exactly “The” or “cat” or “and”, etc and sum up the total that match.

In a file named Data each line has the format (where the names are only letters and the age is a number: lastName:firstName:age   Write a line in bash that would replace the age field with ANON but leave the rest alone.

Suppose in your home directory, you have two folders, named proj1 and proj2. In proj1 you have the subfolder proj3 which contains a file called out.data.  In proj2 you have a subdirectory called proj4 with the file out.txt in it. Assuming you are in the proj4 directory, give me a command to copy out.data to your current location.