Help Csv file field with embedded apostrophe

[RobSue]

I have created a system that logs information every 5 minutes including gps coordinates. To make it easier to use I have tried to embed the gps coordinates inside a Google maps hyperlink but try as I have I just cannot create it in a way whereby the hyperlink appears in a single column of a spreadsheet because the hyperlink includes a comma that forces it into a new column when opened as a spreadsheet.

In many programs I have used it is possible to encapsulate a string that includes a comma inside double quotes in a csv file. Doing it that way makes it include a comma in a column. For e.g. the following line of text in a csv file will open as 3 columns when opened with Excel.
"Abc,123","jkl,567","xyz,456"

Is there a way to do this with Tasker? This is my line of Tasker code:
%DATE, %TIME, %TriggeredBy, http://maps.google.com/maps?q=%LOC,DEVICE, %BATT, %WifiDetails2 %WifiDetails4

 

[Thom]

I played with this for a while and could not find a solution to the problems posed.

I would do one of two things ...

• Use a .csv file and use two columns. When accessing the data concatenate the two columns and include the comma.
• Use a text file and create columns with tabs. Store the data as x,y in one of the columns.

... Thom

 

[RobSue]

Well after grappling with this on and off for many months I have finally found a solution. It was surprisingly simple and very powerful for my requirements and it is simply a case of not leaving spaces around the commas.

Below is the code I am now using and it works a treat. When I open the csv file (my phone defaults to using Google Sheets) the column in question is a hyperlink that I can click on and open to see the location.

"%DATE","%TIME","%TriggeredBy","http://maps.google.com/maps?q=%LOC","%DEVICE","%BATT","%WiFiDetails2","%WiFiDetails4"

Thanks for your efforts in helping me find a solution