Thursday, September 29, 2016

Troubleshoot:Double Quotation marks Error

Double Quotation marks

I have html code in cell A1 (excel 2007) and when I copy it to dreamweaver, excel automatically adds quotation marks everywhere I have quotation mark -single and double- already.  Getting rid of the extra " is not going to work because I unfortunately
have to do this for over 500 rows.
I know this is cumbersome but this is what I have to work with now.  How do I get rid of the extra quotation marks?  Thanks.

Anwsers to the Problem Double Quotation marks

Download SmartPCFixer to Fix It (Free)

My guess is that you are going about this the wrong way.  From your description, the HTML code in A1 is a template that you customize with the contents of A2, etc.
So, leave the template in DW and do the customization in DW using the Excel data.  One way to do this is to include a customized version of template into each file you want using the javascript include statement and then customize the lat/long with an additional
call setting the lat/long before invoking whatever function(s) you actually want to invoke.  This is what I would do -- and have done in the past in similar circumstances.
shane, sorry to make it confusing.  Basically this is what i am doing, i have a bunch of coordinate (latitude and longitude)starting in cell A2.
What I am doing is copying A1 and all the coordinate data and pasting it in dreamweaver to create an html page. 
I have over 400 rows of coordinate data but the html stuff in A1 is the same for all.  Does that make sense? 
So when I paste this info to dreamweaver I get the double quotes.  Yes I suppose I can copy each row on an excel worksheet and save it as mht but that is too much work.  If you look at the 3rd to the last line in my last post, I want to end up in dreamweaver
with the following :wkt_f.externalProjection = new OpenLayers.Projection("EPSG:4326");.   Now the copy and replace "" will not work because if you look at the last line there is an extra(only one) quotation mark.  I hope that is a little clearer.

Tushar Mehta (Technology and Operations Consulting) (Excel and PowerPoint add-ins and tutorials)
Microsoft MVP Excel 2000-Present

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Another Safe way to Fix the Problem: Double Quotation marks:

How to Fix Double Quotation marks with SmartPCFixer?

1. Download Error Fixer. Install it on your system.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.

Related: Way to Update & Download SONY SVE14A2X1EH Wireless State Device driver,How to Update & Download SONY SVS1511X9RB Graphics Driver for D2 (Intel) v.9.17 -,Method to Download SONY VGN-CR290N Realtek High Definition Audio Driver v.,Download SONY VGN-FS710/W Utilities DLL Update v. driver,Method to Update & Download SONY VGN-NR460E/P Intel Graphics Media Accelerator Driver v.,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error,Solution to ashoutxt.dll Missing Error,Solution to cxcore096.dll Missing Error,Where can I Find dsauth.dll File,How to Fix msde.dll Not Found Error,Best Method to Fix psizewizres.dll Error
Read More: [Solved] Document Displays Differently on Other Computers,How to Fix Problem - Document created in Word on Mac won't allow me to save or \"save as\" on PC using Office 2007.?,How to Resolve - DNS server not responding error - what do I do to fix this??,How to Fix Problem - Documents won't print--HP Deskjet D4160?,Double e-mails [Solved],Data validation question. Maintaining and updating named ranges.,Desktop Gadget Gallery on Windows 7,delete empty rows,Deleting a page and also how can I copy an exact page lay out on a new page,Date Formula for 1st Sunday of each Month (3rd to 9th)

No comments:

Post a Comment