I have a spreadsheet in Excel 2010 into which I enter data each day. The
sheet is set up to use CONCATENATE to wrap the data with html tags and
uses CONCATENATE again to bring them all together. I then right click
the final CONCATENATE cell, copy the results and then paste them into
the rest of the html on my raw web page. This works without any issues.
However, I now need to include some PHP in the middle of all this and
this is producing some odd results that I cannot remove. The copied
output has a " added at the start and the same added at the end and,
within the code, every " is doubled so that something like <p
class="subtitle" becomes <p class=""subtitle"".
The PHP is held in one cell with ALT-Enter used to put each statement on
a separate line within the cell. The actual PHP looks like:
<?php
$json_string = file_get_contents('http://website_address.json');
$parsed_json = json_decode($json_string);
$weathernow = $parsed_json-{'current_observation'}-{'weather'};
// $time = $parsed_json-{'current_observation'}-{'observation_time'};
$icon = $parsed_json-{'current_observation'}-{'icon_url'};
$text1 = "The current weather here is<span class=lowercase
$weathernow</span <img class=middle src=";
$text2 = "";
echo $text1,$icon,$text2;
?
Could anyone offer a way to stop the addition of the " characters and
their duplication?
--
F
www.vulcantothesky.org - keep the last remaining Vulcan flying