I am trying to use the funtion FTPeek_UploadFileFromField.

The contents I have in the field looks like this:

AGCD

Sale1|Mr bob brown|1254878956234|

Sale2|Mrs Sarah Graham|23434543

2 Total

When I use that function it wont upload the .txt file with the return keys that appear in the field, agcd should be on one line, sale1 is on another line and sale2 is on the third line.

The result I receive is:

AGCD Sale1|Mr bob brown|1254878956234| Sale2|Mrs Sarah Graham|23434543

Is there a way for me to export to .txt file and upload the contents of the field to a .txt file to look exactly like what it appears in the text field with all return keys?

I found a solution by creating a new table with one field, each record represents a new line in the original field, then doing a .txt export of the found set and doing an ftpeek upload from the exported file instead of from the field.