Pablo Redondo
- Total activity 35
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 17
Comments
Recent activity by Pablo Redondo-
Try this: REPLACEALL(#text;"[^a-zA-Z0-9\" \"]";"")
-
I might need more info to know what the problem could be. From your question seems that you are trying to add a concat formula within a joined sheet. There are couple of sheets where you cannot add...
-
I don't believe there is specifically a UI for this, however you can create an import job from your Datameer Metadata and run the following query to get all jobs with owner and schedule. The schedu...
-
Sure, so what you have now is a list object. Basically all your elements in a list. The next step is to extract each element into its own column. That is where the LISTELEMENT function comes in han...
-
Official comment if you need to parse it through the spreadsheet I would use tokenizelist and then use listelement to extract each value from the list. FYI, noticed that the character "|" will need a backward slash...
-
Where you want the final results downloaded to? I wonder if rather than figuring out how to automatically call the REST API after a worbook is completed you are better off creating an export job in...
-
No worries!.. One more note, if the file is very large (e.g. GB) then I recommend to utilize the TOKENIZE() function in a different sheet referencing the field with the text. The reason being that ...
-
If its completely unstructured text (no real delimiters), then I would recommend to either use the "HTML File Type" format or use the regex format. The HTML format will import a large string of you...
-
Hi Steve, You can use the REST API to achieve this task. I put together a quick python script that should achieve what you are looking for. It might need some minor tweaks but should work. Not sure...
-
You can convert a list to JSON, which is also a string. The function is toJSON(). Then you can apply string fuctions (replace, tokenize, etc)