Forum Discussion

BarryStarck's avatar
BarryStarck
New Contributor II
3 years ago

Filter and Edit a JSON with a touch of data manipulation

Hi, I need to amend some data for a specific table flowing through one of my pipelines This specific json contains multiple values for example: L_TYPE “A” L_TYPE “A” L_TYPE “A” L_TYPE “B”...
alchemiz's avatar
alchemiz
Contributor III
3 years ago
Copy LinkReport

Hi Sir Barry,

Good day, I would suggest to use match for string comparison the return will be an array of string then you can dedups the array to get the unique

sl.ensureArray(“L_TYPE “A”\r\nL_TYPE “A”\r\nL_TYPE “A”\r\nL_TYPE “B”\r\nL_TYPE “B”\r\nL_TYPE “B”\r\nL_TYPE “C”\r\nL_TYPE “C”\r\nL_TYPE “C”\r\nL_TYPE “D”\r\nL_TYPE “D”\r\nL_TYPE “D””.match(/L_TYPE “C”/gm)).filter((a,b,c)=> c.indexOf(a) == b).join()