CSV creation

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • =?Utf-8?B?bXVzb3NkZXY=?=
    #1

    CSV creation

    Hi

    I've written some code to generate a CSV file from a database table.
    However, some colums are getting broken up into 2 fields, or truncated - I
    think cos they have comma in, and of course commas are used as field
    seperators.

    How can I ensure that my fields stay in tact?!

    Thanks
    Tags: None
    • Cowboy \(Gregory A. Beamer\)
      #2
      Re: CSV creation

      The norm is to surround text fields with quotes, so they do not break on
      commas inside the field.

      --
      Gregory A. Beamer
      MVP, MCP: +I, SE, SD, DBA

      Subscribe to my blog
      WordPress.com
      http://gregorybeamer.spaces.live.com/lists/feed.rss
      276


      or just read it:
      Stop Making Sense
      http://gregorybeamer.spaces.live.com/
      Just another WordPress.com site


      *************** *************** **************
      | Think outside the box! |
      *************** *************** **************
      "musosdev" <musoswire@comm unity.nospamwro te in message
      news:70D73624-F6E4-480F-B0A1-47AEC2C437CB@mi crosoft.com...
      Hi
      >
      I've written some code to generate a CSV file from a database table.
      However, some colums are getting broken up into 2 fields, or truncated - I
      think cos they have comma in, and of course commas are used as field
      seperators.
      >
      How can I ensure that my fields stay in tact?!
      >
      Thanks

        Comment

        • =?Utf-8?B?bXVzb3NkZXY=?=
          #3
          Re: CSV creation

          Thank you both - problem solved!

          "Cowboy (Gregory A. Beamer)" wrote:
          The norm is to surround text fields with quotes, so they do not break on
          commas inside the field.
          >
          --
          Gregory A. Beamer
          MVP, MCP: +I, SE, SD, DBA
          >
          Subscribe to my blog
          WordPress.com
          http://gregorybeamer.spaces.live.com/lists/feed.rss
          276

          >
          or just read it:
          Stop Making Sense
          http://gregorybeamer.spaces.live.com/
          Just another WordPress.com site

          >
          *************** *************** **************
          | Think outside the box! |
          *************** *************** **************
          "musosdev" <musoswire@comm unity.nospamwro te in message
          news:70D73624-F6E4-480F-B0A1-47AEC2C437CB@mi crosoft.com...
          Hi

          I've written some code to generate a CSV file from a database table.
          However, some colums are getting broken up into 2 fields, or truncated - I
          think cos they have comma in, and of course commas are used as field
          seperators.

          How can I ensure that my fields stay in tact?!

          Thanks
          >
          >

            Comment

            Previous template Next
            Working...