[gtiporter]

I have a name and surname fields that merges into word forms

I now have forms asking for first and middle names. At the moment first and
middle names are together in the name field. 2 separate fields would resolve
the problem but with a few hundred documents would be disastrous to do.

im wondering if the name field can be filtered to look for a space and if
there is one (i.e John Andrew has a space because Andrew is the middle name)
it can insert everything up to the space for the first name and everything
after for the middle name.

Any help would be gratefully received