Hi guys,
im pretty bad with Regexformulars. Im using sheet.best to get data for KBM. Anyone can tell me how i get the data formated from:
[{"Name":"Dennis Eckler","Message URL":"https://www.linkedin.com/in/ACoAADVmW58B6lHWiF06yLeGhRSadi8CnumZWMM","Response":"Response 1","Action":"Archivieren "},{"Name":"Matthias Hoffmann","Message URL":"https://www.linkedin.com/in/ACoAACE4bPIB6kFOuXXPKj_QHbs8poWBzTOYjrk","Response":"Response 2","Action":"null"},{"Name":"Ingo K\u00f6pp","Message URL":"https://www.linkedin.com/in/ACoAAB9I6xkBgunTvwA5QNwptMBA3pLgm4kEiKE","Response":"Response 3","Action":"null"},{"Name":"Christian Schmidt","Message URL":"https://www.linkedin.com/in/ACoAADZrEdQBUeNw3Y1ZCmYrFrjE9zG9H225yKQ","Response":"Response 4","Action":"null"},{"Name":"Ren\u00e9 S\u00fc\u00dfkind","Message URL":"https://www.linkedin.com/in/ACoAAD_OumoBud-xrG0MtgS1WVPyRpGYQRc6A9s","Response":"Response 5","Action":"null"},{"Name":"Julian Jarminowski","Message URL":"https://www.linkedin.com/in/ACoAACkcNncBsDtltg9GNe7kCzZyIzS1U36GLwQ","Response":"Response 6","Action":"null"}]
to:
Dennis Eckler,https://www.linkedin.com/in/ACoAADVmW58B6lHWiF06yLeGhRSadi8CnumZWMM,Response 1,Archivieren
Matthias Hoffmann,https://www.linkedin.com/in/ACoAACE4bPIB6kFOuXXPKj_QHbs8poWBzTOYjrk,Response 2,null
Ingo Köpp,https://www.linkedin.com/in/ACoAAB9I6xkBgunTvwA5QNwptMBA3pLgm4kEiKE,Response 3,null
Christian Schmidt,https://www.linkedin.com/in/ACoAADZrEdQBUeNw3Y1ZCmYrFrjE9zG9H225yKQ,Response 4,null
René Süßkind,https://www.linkedin.com/in/ACoAAD_OumoBud-xrG0MtgS1WVPyRpGYQRc6A9s,Response 5,null
Julian Jarminowski,https://www.linkedin.com/in/ACoAACkcNncBsDtltg9GNe7kCzZyIzS1U36GLwQ,Response 6,null
Basically to get the data in the form name, url, response, action