Convert comma separated values to new child records

So i have a Table for Job cards and a second child table for parts used.  These 2 tables are connected with a Line items table: Job Card --<Line Items >--Parts I have a third party app tha...