โ03-03-2020 07:23 AM
Hey Everyone,
Iโm currently receiving data from an API and inserting the data into a MySQL database. Hereโs an example of one of the columns that are coming over:
[โ5bb1614c4fd80200018e33c4โ,โ5ca500003aaf6000014dbc98โ,โ5b5f558add2f28000151e88dโ]
Is there a way to remove the brackets and " so that itโll only be the records and the comma separating each value?
โ03-05-2020 01:06 AM
Hi,
You can try Array.toString() function if its an array type or use string.replaceAll() function to achieve this.
โ03-09-2020 12:40 AM
It is hard to tell by what has been posted here, but, perhaps you need a JSON Splitter. At the right JSON path, you should get the unique GUID values required downstream. Feel free to ping me if you need any assistance. Thanks.
โ03-15-2020 02:10 AM
Use array.join(โ,โ) or array.toString() to achieve what you asked for. Join will allow you to change the delimiter. Keep in mind This returns one string value