I want to Remove "\n\r" from the Column as its creating Problem in Excel Export

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mahesh83
    New Member
    • Feb 2007
    • 25
    #1

    I want to Remove "\n\r" from the Column as its creating Problem in Excel Export

    Hi my code is
    [PHP] <?
    $header = "Company Name". "\t"."Inqui ry Date". "\t"."Conta ct Person".
    "\t"."Email ID". "\t"."Addre ss". "\t"."City" . "\t"."State"."\ n";

    $data = "";
    while($row_inqu iry = mysql_fetch_ass oc($result_inqu iry))
    {
    ?>
    <tr>
    <td class="normaltd "><?=$row_inqui ry['company_name']?>
    <? $data = $data ."\t\t". $row_inquiry['company_name']. "\t";
    ?></td>
    <td class="normaltd "><?=$row_inqui ry['inquiry_date']?>
    <? $data = $data . $row_inquiry['inquiry_date']. "\t";
    ?></td>
    <td class="normaltd "><?=$row_inqui ry['contact_person ']?>
    <? $data = $data . $row_inquiry['contact_person ']. "\t";
    ?></td>
    <td class="normaltd "><a href="mailto:<? =$row_inquiry['email_id']?>"><?=$row_inq uiry['email_id']?>
    <? $data = $data . $row_inquiry['email_id']. "\t";
    ?></a></td>
    <td class="normaltd "><?=$row_inqui ry['address']?>
    <? $data = $data . $row_inquiry['address']. "\t";
    ?></td>
    <td class="normaltd "><?=$row_inqui ry['city']?>
    <? $data = $data . $row_inquiry['city']. "\t";
    ?></td>
    <td class="normaltd "><?=$row_inqui ry['state']?>
    <? $data = $data . $row_inquiry['state']. "\n"; ?></td>
    <td class="normaltd ">
    <a href="javascrip t:showdetails(< ?=$row_inquiry['inquiry_id']?>)" class="linktext ">show</a>
    </td>
    </tr>
    <?
    }
    ?>
    [/PHP]

    Here in address " <? $data = $data . $row_inquiry['address']." in this column i am getting space or new from the database for the address but i want to remove that "\r\n" so that it wont take newline Will Exporting in Excel Sheet
    Tags: None
    • gauravgmbhr
      New Member
      • Feb 2007
      • 107
      #2
      Originally posted by Mahesh83
      Hi my code is
      [PHP] <?
      $header = "Company Name". "\t"."Inqui ry Date". "\t"."Conta ct Person".
      "\t"."Email ID". "\t"."Addre ss". "\t"."City" . "\t"."State"."\ n";

      $data = "";
      while($row_inqu iry = mysql_fetch_ass oc($result_inqu iry))
      {
      ?>
      <tr>
      <td class="normaltd "><?=$row_inqui ry['company_name']?>
      <? $data = $data ."\t\t". $row_inquiry['company_name']. "\t";
      ?></td>
      <td class="normaltd "><?=$row_inqui ry['inquiry_date']?>
      <? $data = $data . $row_inquiry['inquiry_date']. "\t";
      ?></td>
      <td class="normaltd "><?=$row_inqui ry['contact_person ']?>
      <? $data = $data . $row_inquiry['contact_person ']. "\t";
      ?></td>
      <td class="normaltd "><a href="mailto:<? =$row_inquiry['email_id']?>"><?=$row_inq uiry['email_id']?>
      <? $data = $data . $row_inquiry['email_id']. "\t";
      ?></a></td>
      <td class="normaltd "><?=$row_inqui ry['address']?>
      <? $data = $data . $row_inquiry['address']. "\t";
      ?></td>
      <td class="normaltd "><?=$row_inqui ry['city']?>
      <? $data = $data . $row_inquiry['city']. "\t";
      ?></td>
      <td class="normaltd "><?=$row_inqui ry['state']?>
      <? $data = $data . $row_inquiry['state']. "\n"; ?></td>
      <td class="normaltd ">
      <a href="javascrip t:showdetails(< ?=$row_inquiry['inquiry_id']?>)" class="linktext ">show</a>
      </td>
      </tr>
      <?
      }
      ?>
      [/PHP]

      Here in address " <? $data = $data . $row_inquiry['address']." in this column i am getting space or new from the database for the address but i want to remove that "\r\n" so that it wont take newline Will Exporting in Excel Sheet

      read this for help
      str_replace
      and replace "\n\r" with a "\t" or ""

        Comment

        • Mahesh83
          New Member
          • Feb 2007
          • 25
          #3
          Thanx a Lot...
          I placed that code as
          [PHP]</tr>
          <?
          $header = "Company Name". "\t"."Inqui ry Date". "\t"."Conta ct Person".
          "\t"."Email ID". "\t"."Addre ss". "\t"."City" . "\t"."State"."\ n";




          $data = "";

          while($row_inqu iry = mysql_fetch_ass oc($result_inqu iry))
          {
          ?>
          <tr>
          <td class="normaltd "><?=$row_inqui ry['company_name']?>
          <? $data = $data ."\t\t". $row_inquiry['company_name']. "\t";
          ?></td>
          <td class="normaltd "><?=$row_inqui ry['inquiry_date']?>
          <? $data = $data . $row_inquiry['inquiry_date']. "\t";
          ?></td>
          <td class="normaltd "><?=$row_inqui ry['contact_person ']?>
          <? $data = $data . $row_inquiry['contact_person ']. "\t";
          ?></td>
          <td class="normaltd "><a href="mailto:<? =$row_inquiry['email_id']?>"><?=$row_inq uiry['email_id']?>
          <? $data = $data . $row_inquiry['email_id']. "\t";
          ?></a></td>
          <td class="normaltd "><?=$row_inqui ry['address']?>
          <? $string = $row_inquiry['address'];
          $output=str_rep lace(array("\r" , "\n"), " ", $string);
          ?>
          <? $data = $data .$output. "\t";
          ?></td>
          <td class="normaltd "><?=$row_inqui ry['city']?>
          <? $data = $data . $row_inquiry['city']. "\t";
          ?></td>
          <td class="normaltd "><?=$row_inqui ry['state']?>
          <? $data = $data . $row_inquiry['state']. "\n"; ?></td>
          <td class="normaltd ">
          <a href="javascrip t:showdetails(< ?=$row_inquiry['inquiry_id']?>)" class="linktext ">show</a>
          </td>
          </tr>
          <?
          }
          ?>
          </table>[/PHP]
          Thanks

          Cheers
          Mahesh

            Comment

            • gauravgmbhr
              New Member
              • Feb 2007
              • 107
              #4
              Originally posted by Mahesh83
              Thanx a Lot...
              I placed that code as
              [PHP]</tr>
              <?
              $header = "Company Name". "\t"."Inqui ry Date". "\t"."Conta ct Person".
              "\t"."Email ID". "\t"."Addre ss". "\t"."City" . "\t"."State"."\ n";




              $data = "";

              while($row_inqu iry = mysql_fetch_ass oc($result_inqu iry))
              {
              ?>
              <tr>
              <td class="normaltd "><?=$row_inqui ry['company_name']?>
              <? $data = $data ."\t\t". $row_inquiry['company_name']. "\t";
              ?></td>
              <td class="normaltd "><?=$row_inqui ry['inquiry_date']?>
              <? $data = $data . $row_inquiry['inquiry_date']. "\t";
              ?></td>
              <td class="normaltd "><?=$row_inqui ry['contact_person ']?>
              <? $data = $data . $row_inquiry['contact_person ']. "\t";
              ?></td>
              <td class="normaltd "><a href="mailto:<? =$row_inquiry['email_id']?>"><?=$row_inq uiry['email_id']?>
              <? $data = $data . $row_inquiry['email_id']. "\t";
              ?></a></td>
              <td class="normaltd "><?=$row_inqui ry['address']?>
              <? $string = $row_inquiry['address'];
              $output=str_rep lace(array("\r" , "\n"), " ", $string);
              ?>
              <? $data = $data .$output. "\t";
              ?></td>
              <td class="normaltd "><?=$row_inqui ry['city']?>
              <? $data = $data . $row_inquiry['city']. "\t";
              ?></td>
              <td class="normaltd "><?=$row_inqui ry['state']?>
              <? $data = $data . $row_inquiry['state']. "\n"; ?></td>
              <td class="normaltd ">
              <a href="javascrip t:showdetails(< ?=$row_inquiry['inquiry_id']?>)" class="linktext ">show</a>
              </td>
              </tr>
              <?
              }
              ?>
              </table>[/PHP]
              Thanks

              Cheers
              Mahesh
              U R Welcome

                Comment

                Previous template Next
                Working...