Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted (edited)

Hi,

 

Yes, I'm a bit of a noob, so please go easy.

 

I've been mucking around with this & don't quite understand. Was under the impression Tab was the default separator. When I attempt to export a CSV file, there is no tabs & columns are not separated. It appears they're separated by commas, but I don't know how to change to Tab, what am I doing wrong? Thanks in advance

 

 

// **** Field Separator ****

// change this if you can't use the default of tabs

// Tab is the default, comma and semicolon are commonly supported by various progs

// Remember, if your descriptions contain this character, you will confuse EP!

// if EP_EXCEL_SAFE_OUTPUT if false (below) you must make EP_PRESERVE_TABS_CR_LF false also.

$ep_separator = "\t"; // tab is default

//$ep_separator = ','; // comma

//$ep_separator = ';'; // semi-colon

//$ep_separator = '~'; // tilde

//$ep_separator = '*'; // splat

 

// define ('EP_SEPARATOR', );

 

 

// *** Excel safe output ***

// this setting will supersede the previous $ep_separator setting and create a file

// that excel will import without spanning cells from embedded commas or tabs in your products.

// if EP_EXCEL_SAFE_OUTPUT if false (below) you must make EP_PRESERVE_TABS_CR_LF false also.

define ('EP_EXCEL_SAFE_OUTPUT', true); // default is: true

 

if (EP_EXCEL_SAFE_OUTPUT == true) {

if ($language == 'english') {

$ep_separator = ','; // comma

} elseif ($language == 'german') {

$ep_separator = ';'; // semi-colon

} else {

$ep_separator = ','; // comma // default for all others.

}

}

Edited by rTYPE

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...