RonF

I am trying to import a csv file and parse it into an fmp table on fmp go 19. The import and parsing are working well on a pc. On my ipad, I am able to import the csv file, but the parsing is creating a blank record for every record parsed. I suspect it is due to the effort to replace the ipad line feed character with a character return. My code is # Replace windows CRLF If [ PatternCount ( Import CSV::Text ; Char ( 13 ) & Char ( 10 ) ) ] Set Field [ Import CSV::Text; Substitute ( Import CSV::Text ; Char ( 13 ) & Char ( 10 ) ; "¶" ) ] End If #Replace iOS Unix (LF) If [ PatternCount ( GetAsText ( Import CSV::Text ) ; Char ( 10 ) )] Set Field [ Import CSV::Text; Substitute ( Import CSV::Text ; Char ( 10 ) ; "¶" ) ] End If Also, what is the ipad based file path format, how many slashes following file:, I have seen several different formats based on which version of FM go. Thanks Ron

I have a series of filemaker 14 records containing email addresses and secondary email addresses (where present). I use the 'EmailRecipients (email address) and EmailccRecipients (secondary email address)' to set the recipient values. This works when both addresses are present, but when the record only has a primary address, the secondary address from the prior record is carried over. I have tried to use the EmailRecipients with only the primary address and not reference the cc value, but the email still has the prior cc value in it. How do I clear the value that is being carried over so that records with only a primary address do not have a cc attached to the email. Thanks Ron