Changing Exported Data Field Separators

  • I’m using FS Contact Form with the DB Extension and the export function is working perfectly. However, I’m Having some trouble with the importing of the exported file. It appears that a CHR(10) exists after the header line, but there’s another field separator before this. Looks like a small vertical rectangular box???

    The exported file needs to have the data lines end in CHR(13) + CHR(10) which are a carriage return + line feed.

    What changes can I make for the file to export as described.
    Regards
    Gary

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    vertical rectangular box: I’m not sure what that is. Must be a special character. If you exported one of the “BOM” options, then the BOM characters are inserted by that is at the very start of the file. So I don’t know that is.

    For carriage return line feed:

    1. If you are on a unix box, you could run “unix2dos” on the file.
    2. On Windows, the easiest thing might be to get a text editor that will do the conversion for your. See if yours has some option for it. I use the free Notepad++. If you open a file with that, go to Edit menu -> EOL Conversion -> Windows Format and save
    Thread Starter SBIMarketing

    (@sbimarketing)

    Michael,

    Thanks for your suggestion. I have uploaded a small screen shot of the rectangular box so you can see for yourself what I mean.

    https://www.woodshield.com.au/screenshot

    If I understand your comment about the “BOM” options, I should change to Plain CSV which has no BOM?

    Cheers
    Gary

    Plugin Author Michael Simpson

    (@msimpson)

    Yes, try Plain CSV. It has no BOM.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Changing Exported Data Field Separators’ is closed to new replies.