Convert from base64 to CSV
How can you convert base64 into a CSV?
The base64 value comes from an external system. We would like to convert it to a CSV file.
Is a dedicated action our only solution? (I submitted the Idea shared below)
Is there a known service, like ConvertAPI, that can accomplish the conversion of base64 to CSV?
Action for base64 converter
https://community.pushbot.com/discussion/732
Best Answer
-
In a field formula, you can apply:
value =
result = Buffer.from(fields['field-with-base64'], 'base64').toString();
and that will get the result CSV as another text field. From there you can save text as a file and you have a CSV. However, doing data processing like this will always be more risky than retrieving a csv file and saving directly as a file field, as you could hit a field limit if the CSV file is too large (in either base64 or utf8 encoded format).
6
Answers
-
I located an online tool that does not log data to servers. It is all done in the browser using JavaScript.
If recommended, we can proceed with using this online option.
0