I am importing records from an Excel file and then running a script on this record set to add new records in my main table. For some reason Filemaker is not detected the space in between First and Last Name on some of the records.
On some of them WordCount (FullName) returns 2 which is correct but for others it only returns one and there is clearly a space in between these. I then ran PatternCount(FullName; " ") and sure enough it's not seeing the space on some of the records.
Is this a formatting issue or something else??