Home

   Home

   Download


Help

   FAQ

   Installation

   Message Board

   Importing Data File
   Into GoldMine
   Into Act


Other

   Testimonies

   Custom Programming

   PHP Version


Other Favorites

   Hire a clean comedian

   Bible Search Engine

   Bible in a Year

   Parallel Bible

   The Richer Life










 





[ Message Board Home ]    [ Post Reply ]    [ Log In ]    [ Sign Up ]



  Subject: <br> values or paragraphs messing up when importing csv into excel
  Posted: 08/31/2010 at 1:09:04 am
  By: fabio

When I import a bizmail csv file into excel the <br> values or paragraphs marks contained in the submitted fields are messing up the result excel table creating new records that should not exist. Is there any workaround to filter/avoid that <br> or paragraph marks are considered when submitting the form?

Thanks fabio



  Subject: Re: <br> values or paragraphs messing up when importing csv into excel
  Posted: 08/31/2010 at 11:53:16 pm
  By: Seth Knorr

in bizmail.cgi, Do a find and replace for:
$value2 =~ s/(\r)+/<br>/g;

Change to:
$value2 =~ s/(\r)+//g;

You can also add this line below it:
$value2 =~ s/<br>//g;

Regards,

Seth Knorr



Reply To This Topic

Subject
Message  
Username
Password
Due to unrelated post's, you must have an
account to post a message. To Sign Up click here.




Copyright 2000-2010 Seth M. Knorr,
BizMailForm.com Forms Processor, All Rights Reserved