1
Completed

AutoSheets Get Data, change output list separator of rows/columns like Joiner

I use AutoSheets Get Data to pickup a range of cells to transform the rows in a variable array for a project.
The problem is that the default row separator is a comma and some cells in the middle of the range have a comma inside. Some are numbers (ex. 1.080,75) and some cells may have a comma in the middle of the text.
The Joiner option is great to set a custom separator, but if could have another "Joiner" option to set the other separator, that would be amazing for fine tuning the data.

Example:

Follow

1 reply

Votes Newest Oldest

Hi. That separator is not needed because those items are already separated :)

For example, if you access %output(1) you'll get the first one only. It's just a normal Tasker array.

More here: https://tasker.joaoapps.com/userguide/en/variables.html#arrays

Comment
A

Hi João, thanks for the reply.
My problem is that I would like to have all the data stored together in a simple variable, without using arrays, and store the asdata() for later comparison with partial data from other spreadsheets. I'll reuse the asdata() many times, so I believe that I could to save a lot of time by skipping the connect and download steps by storing it in a local variable.
I'll have to compare some sheet parts, some parts have hundreds rows or much more, so I would like to avoid using For with %asdata(%for) to create this single variable with the custom separator. I know that for the comparison of two variables, the separator symbol doesn't matter, but sometimes I need to change some rows and that's when I need the separator to be different from my data, to have the same control that we already have in AutoSheets Update Cells.
I also have to search and replace a pattern from texts from columns sometimes based in the results. I believe that would faster to do it if I have all rows in a single variable instead of doing Search and replace inside every For.
As I said before, I avoid to use AutoSheets actions because of the internet connection. This local variable solution is the best way I've found to generate faster result by making less calls and the custom separator is crucial for this local handle of data. I also use this one data variable to update cells, for again less connection actions. That's why AutoSheets Update Cells (Row separator) works so fine for me, as some of my data have a comma inside it.
I know that this custom separator won't be useful for every case, but it will definitely help make Tasker even more powerful and our lives easier.
Anyway, thanks again for replying to my suggestion.

To create a single variable with all the values joined you can simply use %asdata(+|||) to join with ||| for example :)

Long press the %asdata() variable in the Tasker variable select list for more options.

Hope this helps!

Reply