Hi,
I'm just wondering, when making a CSV file - what are the general standards for newlines (\n)? Obviously they need to be replaced with something, as CSV's are read on a per-line basis - so any newlines would be treated as new lines of data.
At the moment, I'm just replacing it with a simple regex:
...but I know the %N% option isn't much good, as the chances are it won't work with anything trying to import the CSV =)
Cheers
Andy (mod)
andy@ultranerds.co.uk
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
I'm just wondering, when making a CSV file - what are the general standards for newlines (\n)? Obviously they need to be replaced with something, as CSV's are read on a per-line basis - so any newlines would be treated as new lines of data.
At the moment, I'm just replacing it with a simple regex:
Code:
$field =~ s/\n/%N%/g;...but I know the %N% option isn't much good, as the chances are it won't work with anything trying to import the CSV =)
Cheers
Andy (mod)
andy@ultranerds.co.uk
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates