Unless there's a plug in that can eliminate this step, you'll need to save your Doc file as a text file in order to get something that FileMaker can import.
Import records can then import this text and each return separated row of text from the text (tab) file will become a record in the specified target table. The comma separated text can then be parsed into individual records containing the listed text:
Set Variable [$ItemList ; value: Substitute ( YourTable::InputField ; , "," ; ¶ ) ]
Go to Layout ["Items" (ItemTable) ]
Set Variable [$K ; value: $K + 1 ]
Exit Loop If [$K > ValueCount ( $ItemList ) ]
Set Field [ItemTable::Item ; Trim ( GetValue ( $ItemList ; $K ) ) ]
I'm going to assume you have some method for reading data from a Word doc or you would have been asking how to do that.
I generally use Substitute() to change all the "," to "¶". (The ¶ character is a carriage return.) This will turn your comma separated list into a value list and there are lot's of built in functions to deal with value lists.
Your next step would be create a loop using a counter.
Set Var $List = Substitute($List;",";"¶")
Set Var $Max = ValueCount ( $List )
Set Var $Count = 1
Set Field Item GetValue($List;$Count)
Set Var $Count = $Count + 1
Exit Loop if $Count > $Max
Hi Phil & Brian,
Many thanks for the help! It worked perfectly and i learnt alot from you guy's script. Would have took me days to figure that out.