I am new to ACF so any insight from the community would be very much appreciated.
As an overview, I have a CMS into which I parse editorial data. One field of which is the editorial author(s) which are initially returned as one text string, with the authors separated by a comma.
Import table (1 record) –
[Primary_Key:AA123] [G.Jones, P.Smith, A.Brown]
These are then extracted via a calculation to form separate records in a database join table, each record featuring the corresponding editorial data primary key. In many instances there are more than one but no more than eight.