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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!