Carriage return (Enter) in text boxes gives extra line in CSV file

[golfer]

Two of the fields in my form are multi line text entry boxes. The user often will enter more than one line of text, each line being ended by pressing the carriage return key (Enter). This seems to give an extra line in the CSV file that is sent through.

Is there a way of substituting the CR with another character [maybe / or ;] to show where the user has entered the CR?

Thanks...............Ken

[russellr]

Hi,

FormMail supports quoting of data in CSV files. In this case, it will quote the field value and preserve the newlines.

However, the setting called "LIMITED_IMPORT" allows for software like Excel, which doesn't understand quoting in CSV files, and therefore strips the new lines.

Set LIMITED_IMPORT to false and you'll get your newlines preserved.

[golfer]

Hi Russell

I'm not sure I understand this.

LIMITED_IMPORT was set to true and the carriage returns appeared in the csv file attached to my email.

I set it to false and there was no difference, the CRs were still there.

I double checked this twice and the results were the same.

Ken

[golfer]

Hi again,

I've just looked at the .txt file with the data in on my server. With the setting at true, the CR's dont appear in the file. WIth it set to false, they do appear in the file. However in the .txt file passed through with the email, the CRs appear both times.

Ken

[russellr]

Hi,

That's correct. LIMITED_IMPORT only affects CSV files.

As I understand your question, this is now working the way you want.

BTW, the mail_options feature "KeepLines" controls whether new lines are preserved in field values for use in email.