<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-CA" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoPlainText">Hi Francis,<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">There's many ways to achieve this but here's one that seems to get the job done.<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"><img width="812" height="386" style="width:8.4583in;height:4.0208in" id="Picture_x0020_1" src="cid:image002.png@01D8FF1A.4A7984A0"><o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Cheers,<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Tony Machado<o:p></o:p></p>
<p class="MsoPlainText">(he; him | il;lui)<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Deputy Director – Data and Client Services, Measurement Canada<o:p></o:p></p>
<p class="MsoPlainText">Innovation, Science and Economic Development Canada / Government of Canada<o:p></o:p></p>
<p class="MsoPlainText">tony.machado@canada.ca / Tel: 613-290-7204 / TTY: 1-866-694-8389<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"><span lang="FR-CA">Directeur adjoint - Données et services à la clientèle, Mesures Canada<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="FR-CA">Innovation, Sciences et Développement économique Canada / Gouvernement du Canada<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="FR-CA">tony.machado@canada.ca / Tél. : 613-290-7204 / ATS : 1-866-694-8389<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="FR-CA"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="FR-CA"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="FR-CA"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US" style="mso-fareast-language:EN-CA">-----Original Message-----<br>
From: R-UG-Ottawa <r-ug-ottawa-bounces@r-project.org> On Behalf Of Francis Djamba<br>
Sent: November 22, 2022 7:48 AM<br>
To: CRAN-submissions@R-project.org; r-ug-ottawa@r-project.org<br>
Subject: Re: [OGRUG] Requeste of Assistance</span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Dears Colleagues;<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">I thank this message fund you well.<o:p></o:p></p>
<p class="MsoPlainText">I would like to request your assistance to have an R script that will allow me to import data via a web link below and transpose the imported data and finally save the transposed data to a csv or xlsx file on my hard drive.<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">the Link: <a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Funstats.un.org%2Fsdgapi%2Fv1%2Fsdg%2FSeries%2FData%3FseriesCode%3DSL_DOM_TSPD&data=05%7C01%7Ctony.machado%40ised-isde.gc.ca%7C05b91dc2cf894f81eeeb08dacc87e2ba%7Cb72ac62f06d54cd5824eee92319a4676%7C0%7C0%7C638047653395171033%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=0hZESaPUc8CXoLFPjUuWKQlFhd0DE0Fg%2Bv1py%2FjyW6I%3D&reserved=0"><span style="color:windowtext;text-decoration:none">https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Funstats.un.org%2Fsdgapi%2Fv1%2Fsdg%2FSeries%2FData%3FseriesCode%3DSL_DOM_TSPD&data=05%7C01%7Ctony.machado%40ised-isde.gc.ca%7C05b91dc2cf894f81eeeb08dacc87e2ba%7Cb72ac62f06d54cd5824eee92319a4676%7C0%7C0%7C638047653395171033%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=0hZESaPUc8CXoLFPjUuWKQlFhd0DE0Fg%2Bv1py%2FjyW6I%3D&reserved=0</span></a><o:p></o:p></p>
<p class="MsoPlainText">Thank you for your help.<o:p></o:p></p>
<p class="MsoPlainText">Francis D. <o:p></o:p></p>
<p class="MsoPlainText"> [[alternative HTML version deleted]]<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">_______________________________________________<o:p></o:p></p>
<p class="MsoPlainText">R-UG-Ottawa mailing list<o:p></o:p></p>
<p class="MsoPlainText"><a href="mailto:R-UG-Ottawa@r-project.org"><span style="color:windowtext;text-decoration:none">R-UG-Ottawa@r-project.org</span></a><o:p></o:p></p>
<p class="MsoPlainText"><a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstat.ethz.ch%2Fmailman%2Flistinfo%2Fr-ug-ottawa&data=05%7C01%7Ctony.machado%40ised-isde.gc.ca%7C05b91dc2cf894f81eeeb08dacc87e2ba%7Cb72ac62f06d54cd5824eee92319a4676%7C0%7C0%7C638047653395171033%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=FKGEvrnGcTEOHUBe77e4BQRmBEX33XAS0F%2BzUs02T8I%3D&reserved=0"><span style="color:windowtext;text-decoration:none">https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstat.ethz.ch%2Fmailman%2Flistinfo%2Fr-ug-ottawa&data=05%7C01%7Ctony.machado%40ised-isde.gc.ca%7C05b91dc2cf894f81eeeb08dacc87e2ba%7Cb72ac62f06d54cd5824eee92319a4676%7C0%7C0%7C638047653395171033%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=FKGEvrnGcTEOHUBe77e4BQRmBEX33XAS0F%2BzUs02T8I%3D&reserved=0</span></a><o:p></o:p></p>
</div>
</body>
</html>