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.
Solutions 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)
www.tushar-mehta.com (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.
Recommended Method to Repair the Problem: Double Quotation marks:
How to Fix Double Quotation marks with SmartPCFixer?
1. Download Error Fixer. Install it on your computer.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.
Related: Startup Error Failed to connect to a Windows service System Event Notification Service sic Task Scheduler not always closing down program text wrap not working in Word Upgraded my computer from Windows Vista to Windows 7 Now my Lexmark Z515 printer will not work Can someone please help me The drivers for USB 2 0 arent showing up and dont seem to be usable I have ServicePack s 1 thru 3 The drivers used to show and work but not any more Is there a way I can get them back so my 2 0 items will work properly Symbols are not displayed in PDF when word is converted to pdf using Save As PDF Microsoft Addin The Security Center has not recorded an antivirus product when tried to generate System Health Report When conducting a search on Google or Bin search results are not visible I get a blank white page Ulead Photo Express 5 SE does not work with Win7 USB 2 0 devices plugged into USB 3 0 do NOT appear in Safely Remove HW VBA Excel find matching list files and copy to another folder What can I do to eliminate the not responding message I constantly get Web Proxy Not Responding USB Microsoft Mouse Not working upon boot whatsapp not connecting What should I do if my CD Drive reads some CDs but not others,Issues With Downloads And Installations Since Fresh Install Of Windows 7 64bit,Windows 8 - Browsers Font Rendering Issue! Blocky Fonts Text,Why Some Of Links Are Not Functioning In Web Pages (IE8)?,Internet Stops Working,Nesting Functions???,IMesh Is Not Working Only Minimizes,I Can't Uninstall ITunes And SupportSolutionsFramework.msi,I Have 3 Columns Out Of Many Columns Of Data Each With Hundreds Of Rows, I Need To Identify The Lowest Number In Each Row For These Three Columns Only And Reference The Column Title For That Particular Number.,Divide Information Into Two Columns,My Asus T100 Transformer Wont Turn On
Read More: Solution to Error: After IE 9 download - I cannot access a favorite web site,How to Resolve - Havving trouble opening a certain SD card on my computer.?,How to Resolve - IE 8 is not opening .php files anymore. While all other browsers do.?,How to Fix - tried to download uniblue and came up with a warning of security risk is there a problem??,How to Resolve - printing a worksheet?,Alps pointing device stops working and resumes.,Attempting to use Conditional Formating with a variable,internet options not opening on IE 10,cannot open my emails. they are there but will not open,Microsoft Works 9 does not keep History items.
0 comments:
Post a Comment