Question about Computers & Internet

Open Question

Which of the following is not a purpose of te apostrophe A. reveal a characters innermost thoughts and feelings. B. hint of upcoming events. C. emphasize theme D. create imagery and set mood

Posted by Anonymous on

Ad

2 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Ad
dbarchitect
  • 150 Answers

SOURCE: HOW TO STRIP DELIMITED CHARACTERS FROM SPREADSHEET

The short of it is this ...
Match the data in each location and store it the same way. As a number or as a string. I would say, looking at your data, that these are probably strings of numbers. Put the apostrophe in front of both pieces of data at both locations so they match. I tried a simple test in Excel and adding the apostrophe in front of all the uses of this data will match everything.

The long of it is this ...
Now, I don't know your technical expertise, but I'll try to put it simply. The hard part to understand in database and data storage, is that not all numbers are numbers.

For example, a phone number 8005551212 is not a number. It's a string of numbers. This is because every single position from the 8 to the 2 is a significant position. Another example is a a social security number. The arbitrary SSN of 002003421 is a string of numbers. The first two 0's will be stripped off in Excel if put in as a number, thus ALL number but be retained in their original significant position.

The apostrophe (added by the user) forces Excel interpret the cell data as a string, instead of number, preserving all the characters in their original form, and doesn't try and tinker with the formatting.

The other reason is that the data you've provided is WAY BIG for a number. Not a lot of systems in the world will do calculations against such big numbers. This is why I "guess" that they should be strings (adding the apostrophe to the front of the data in the cell).

How do you know if data should be stored as a string or as a number. The tall tale question is "will I be using these numbers in calculations." If you do, it's a number, if not, it's a string (add the apostrophe). A second question could be "do I need all positions to retain their original information" as a literal.

Please ask any questions.

Posted on Dec 18, 2007

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How do you pluralize the last name Reynolds?


Reynoldses. if you want the nitty-gritty, here is the reference: http://data.grammarbook.com/blog/apostrophes/apostrophes-and-proper-nouns/

Mar 27, 2015 | Computers & Internet

2 Answers

How to use apostrophes


Apostrophes are on the key to the left of the 'enter' key. Shift + this key will give you "

Nov 13, 2013 | Computers & Internet

2 Answers

What does "use only legal characters" mean? What are legal characters? (alphabetic,numeric and/or special)


Hey C KROL

Usually it means letters and numbers. Some signup processes don't allow characters like: # % ? _ @.



Good Luck

Jul 29, 2012 | FixYa Computers & Internet

1 Answer

How to use accents when writing in Spanish in a Dell Precision m4500 laptop?


On Windows XP
  1. Log On
  2. Click the Start button
  3. Click on Control Panel
  4. Click Regional and Language Options - a new window will pop up
  5. Click the Languages tab
  6. Click on the Details button
  7. Click the Add button - a new window will pop up
  8. Select United States-International (keyboard layout menu)
  9. Click OK
  10. Click Apply
  11. Read the instructions for "Using the U.S. - International Keyboard" below.
Note: You will now have a keyboard icon on the taskbar (usually on the right side). To switch between keyboard layouts click the keyboard icon on the task bar and choose which layout you want to use. Changing the keyboard layout will only affect the log on profile used. No other users will be affected.

Windows Vista
  1. Start-->Control Panel-->Clock, Language, Region-->Change Keyboards
  2. New Window: Click the Change Keyboards button
  3. New Window: Click the Add button
  4. Select United States-International keyboard
  5. Click OK
  6. From drop down menu (Default Input Language) select United States International
Using the U.S. - International Keyboard If you followed the above directions carefully, your keyboard will now react slightly differently than it did before. First of all, notice that if you strike the single apostrophe (') key, nothing happens. To type the single apostrophe now, you must strike the single apostrophe key and then strike the space bar. When you strike the spacebar, the apostrophe will appear.
The next thing to note is that the quotes (") key behaves the same way as the apostrophe key. You must first strike the quotes key and then strike the space bar in order to create the (") symbol. These two minor inconveniences are more than made up for by the ease with which you can now type the special characters.
To type the special characters, two keystrokes are required. To type the ?, you need only strike the apostrophe key and then the letter a. The other characters are just as easy:
  • ? = ' + a
  • ? = ' + e
  • ? = ' + i
  • ? = ' + o
  • ? = ' + u
  • ? = ~ + n
  • ? = " + u
To type the special punctuation characters, you need to hold down on the Alt key while you strike the appropriate punctuation mark. On some keyboards, only one of the two Alt keys will work for this.
  • ¡ = Alt (hold down) + !
  • ¿ = Alt (hold down) + ?
Using Cryptic Codes If, for some reason, you don't want to change your keyboard, you can always type in the troublesome cryptic codes. Using this arcane system, the following codes apply:
  • ? = Alt + 0225
  • ? = Alt + 0233
  • ? = Alt + 0237
  • ? = Alt + 0243
  • ? = Alt + 0250
  • ? = Alt + 0241
  • ? = Alt + 0252
  • ¡ = Alt + 0161
  • ¿ Alt + 0191
When using this utterly out-dated system, there are two important things to remember. First, when you type in the numbers, some keyboards require that you use the "numeric keypad" located to the side, rather than the numbers along the top. Second, on some keyboards, only one of the two Alt keys will work for this.

May 02, 2011 | Computers & Internet

1 Answer

An ellipsis following a menu item tell's you what?


Ellipsis (plural ellipses; from the Greek: ?λλειψις, élleipsis, "omission") is a mark or series of marks that usually indicate an intentional omission of a word in the original text. An ellipsis can also be used to indicate a pause in speech, an unfinished thought, or, at the end of a sentence, a trailing off into silence (aposiopesis) (apostrophe and ellipsis mixed).
In other words, part of the address has not been displayed because in the early days of computing, there was not enough space allocated to address lines. Now of course one can allocate 256 characters and they are not often used.
Hope that answers your question.

Oct 20, 2010 | Computers & Internet

1 Answer

I can't open SYLK file


are you trying to open a txt file or a comma-separated variable (CSV) file and i bet the chances of the file name having a capital "I: or "D" are good huh.
To open your file in Excel, open the file in a text editor, and then insert an apostrophe at the beginning of the first line of text.
How to Insert an Apostrophe
To add an apostrophe to the beginning of the first line of text in your file, follow these steps:
1. Open the text file in a text editor, such as Notepad. Click before the first character in the first line of text. Press the APOSTROPHE key on your keyboard (').
2. On the File menu, click Save. Quit the text editor. You can now open the file in Excel.
hope this helps , next time tells us the version of your excel and what operating system you are running.
Mel

Jun 11, 2010 | Microsoft Excel for PC

3 Answers

I am trying to install QuickBooks Pro 2007 on a new computer that has Windows Vista Business with SP1, and I had updated Windows, then installed QB but when I imported the company file, QB gave me a...


Why is this happening This issue can occur as a result of uninstalling the Google Desktop installed by Quickbooks on a computer running Microsoft Windows Vista. Launching QuickBooks after uninstalling Google will cause the error message.




Note: This issue is also known to occur with computers that have been upgraded from Windows XP to Windows Vista, where Google Desktop was uninstalled under Windows XP. Both cases would yield the same error message.
How to fix the problem This issue was resolved in the latest release for your version of QuickBooks.
Detailed Instructions Please update your program to the most current release.

just click on that link above then click on the 909ffb0.jpg(update) image on that page.




Oct 27, 2009 | Intuit QuickBooks Pro 2007 Full Version...

3 Answers

Cannot save my data


1.open a second instance of Spss
(do not open it by clicking on a saved file -it will not open the backend that is requierd to let you save)

2. Make a new blank data file

3. go back to your original non-saveable work -- highlight the top tabs (and all your work) right click and hit copy.

4. go to the new blank spss data - right click on the top tab and hit paste- viola your work is now in a saveable version of spss (save now!!!!)

This problem occurs when the program is opened via a saved spss file and it does not open the second part of the program that allows you to save (bad bug). it is in view mode and will let you enter many hours of data before you release you cant save. (My wife was crying when she didnt think she could save her project for Grad school she had been workin on for 19 hours) I got lucky and figured out this work around.. Hope this helps all future SPSS folks this was a workaround for up to spss 17 (dont know if it works for 18 or if they have fixed this glitch).

Search SCA Gulfwars on facebook and say hey on my wall if this helped Ya..... Good Luck

Apr 01, 2009 | SPSS 13.0 (30960UU)

2 Answers

HOW TO STRIP DELIMITED CHARACTERS FROM SPREADSHEET


The short of it is this ...
Match the data in each location and store it the same way. As a number or as a string. I would say, looking at your data, that these are probably strings of numbers. Put the apostrophe in front of both pieces of data at both locations so they match. I tried a simple test in Excel and adding the apostrophe in front of all the uses of this data will match everything.

The long of it is this ...
Now, I don't know your technical expertise, but I'll try to put it simply. The hard part to understand in database and data storage, is that not all numbers are numbers.

For example, a phone number 8005551212 is not a number. It's a string of numbers. This is because every single position from the 8 to the 2 is a significant position. Another example is a a social security number. The arbitrary SSN of 002003421 is a string of numbers. The first two 0's will be stripped off in Excel if put in as a number, thus ALL number but be retained in their original significant position.

The apostrophe (added by the user) forces Excel interpret the cell data as a string, instead of number, preserving all the characters in their original form, and doesn't try and tinker with the formatting.

The other reason is that the data you've provided is WAY BIG for a number. Not a lot of systems in the world will do calculations against such big numbers. This is why I "guess" that they should be strings (adding the apostrophe to the front of the data in the cell).

How do you know if data should be stored as a string or as a number. The tall tale question is "will I be using these numbers in calculations." If you do, it's a number, if not, it's a string (add the apostrophe). A second question could be "do I need all positions to retain their original information" as a literal.

Please ask any questions.

Dec 18, 2007 | Microsoft EXCEL 2004 for Mac

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

661 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...