Forum Discussion

GeoffreyHarmuth's avatar
GeoffreyHarmuth
Qrew Captain
7 years ago

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...
Forms
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
The parts would be extracted out like

Trim(Part([my comma separated field],1,","))

then the 2nd part would be

Trim(Part([my comma separated field],2,","))

and the numerical quantities would be

tonumber(Trim(Part([my commas separated numerical field],1,",")))