Question about Computers & Internet

1 Answer

I need to fix FIXYA... Keep's telling me not to use "illegal characters"... What the heck is an illegal character ?!

Posted by on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 752 Answers

An illegal character is one that it doesn't recognize, for example the symbol for the currency used UK, often referred as GBP (obviously it won't allow me to use the actual symbol here !). These symbols may depend on what language your are working in (it may not tolerate Asian or Cyrillic scripts or characters with accents or stress markings), or any non-alphanumeric symbol ($ " ? ' @ / \ for example, seem to be ok though)

12.May.2014

Posted on May 12, 2014

  • Jee-Pee May 12, 2014

    The "dot" was the problem
    I can do no ponctuation at all LOL

  • etrc_new May 12, 2014

    I don't know what the problem is, "." (dot) works for me, look at my first answer. There is full stop in it. I 'm sorry I can't help.

×

Ad

6 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

  • 24 Answers

SOURCE: need the 25 character product key for Microsoft office 2008 mac

I don't know why people keep asking for product keys. If someone gives you the product key on a Microsoft product that's already activated, it won't work on yours. If theirs hasn't been activated yet, they won't be able to activate it once you do. Giving you their product key would be just like giving you the software they paid for.

~~Cheryl

Posted on Dec 30, 2008

fotomohamed
  • 321 Answers

SOURCE: i need 25 character key for microsoft visio 2007

check out other sites

Posted on Jun 18, 2009

Mike258
  • 1498 Answers

SOURCE: 25 characters

Hello Pirates and future defendants,

I can understand not wanting to pour more money into Microsoft.
I can understand times are tough.
I can even understand not wanting to jump through the hoops of 'Activation'
What all of you need to understand is soliciting, provisioning, swapping, obtaining or using Product Codes that you didn't purchase is software piracy. That's giving them and using them for those on the short bus.

Here is an alternative and it has the advantage of being legal.

Try OpenOffice.

It has the whole Office Suite you would expect. You can open your old files and..........IT'S FREE.

Avoid the turmoil, the shutdowns, the bad Karma and possible prosecution.

Now wasn't that simple

Thank you very much, I'll be here all week,
Mike

Posted on Aug 18, 2009

SOURCE: I need the 25 character product key for microsoft project 2007

hi

this product key you have to get from microfost site only it's not free you have to buy a licence

Posted on Jun 22, 2010

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...
Computers & Internet Logo

Related Topics:

91 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...