Hidden character errors

[SpyderPB6]

Hello All,

I am trying to format a data sheet for uploading to Bing/Google but I am getting some errors on the test upload.

Specifically my biggest issue is that the test is indicated item descriptions and name being enclose in parenthesis. When I check the line these errors are occurring on, I can actually see the parenthesis.

Here's a specific example:


Product title values should not be enclosed by quotations.

Line 2 Error: "20"" Halo Acrylic Crystal Ceiling Fixture | EEI-820"

What I actually see in the cell: 20" Halo Acrylic Crystal Ceiling Fixture by East End Imports | EEI-820

So my best guess there is some hidden formatting perhaps?

Any input would be appreciated.

Thanks,
Mike.

[Pauleyb]

What you see in the cell on the spreadsheet may be different than the actual cell contents (i.e. what you see in the formula bar).

If you type:
20" acrylic
in a cell, it would look fine.

If you type:
=20" acrylic
in a cell, you would get an error, which can be fixed by typing:
="20"" acrylic"

It appears the upload filter does not like to have quotations around strings. I assume your spreadsheet actually has something like ="20"" acrylic" which is causing the error.

Possible fix #1: type in 20" acrylic without the = or the quotes
Possible fix #2: remove the double quotes completely by saying: 20in. acrylic

[SpyderPB6]

Hello and thanks for the reply.

I understand most of what you stated, but what I don't is that even in the formula bar, it shows only one " after 20, no other parenthesis appear.

Now I should also point out, this is a text file that I believe is tab separated. Opening it up in Notepad++ I can clearly see the parenthesis, but when dropped into excel, none appear.

That of course, may be all there is to it, though other suggestions are welcomed.


Thanks,
Mike

[Pauleyb]

So, it looks like your spreadsheet is not sending it the quoted string, then it must be the uploader. Is there a common element on the rejected strings? For example, do they all have the " being used? Are there some with that common element not being rejected? If it is always ", suggest you try my second solution.