Hi @Treyson Marks? , thank you for your question! Happy to have you here! =]
To cope with this Json, I'd instead suggest splitting only by the first comma, like this:
And then continue parsing the array and the objects within via Trifacta's interactive suggestions:
And continue from there.
However, if you'd prefer to parse the file via separation of the internal objects, as initially suggested, you have 2 ways to achieve this.
1 . split by delimiter
The field "ignore matches between" can only accept 1 character. That's why it's not working for you.
Instead, you can either put
- an opening curly brackets at the "end the split before"
- a closing curly brackets at the "start to split after"
You will need to decide how many splits you want; In our case - it's 5 splits to create 6 columns.
- remember to remove the opening and closing square brackets that were initially a part of the outer array
2 . split between delimitersThat way, you don't need to specify the original delimiter, just the closing and opening curly brackets.
I hope this makes sense; Please feel free to ask any additional questions.
Thanks,
Amit.