I had a similar need this week. So thanks for asking Vincent. My data was in the format of 0000004239,0000110392,"Vincent, James S.",1-614-249-5547 Only those fields that have a comma within are surrounded by double quotes. I wish it would have been like Rich had suggested - it would have been a lot easier. Yeah, I was hoping for an eloquent PIPE stage to do this. I had to drop to REXX and brute force my way through. I'll lurk, hoping for a PIPE stage or a suggestion to appear. Steve
-----Original Message----- From: CMSTSO Pipelines Discussion List [mailto:[email protected]] On Behalf Of Rich Smrcina Sent: Thursday, August 20, 2015 10:55 AM To: [email protected] Subject: Re: CSV data specs Do a split at ," then join them back together. On Thu, Aug 20, 2015 at 9:53 AM, James Vincent <[email protected]> wrote: > Mike, if it were only that simple. The CSV data (the content of any of the > fields) could contain a comma. For instance: > > "0000004239","0000110392","Vincent, James S.","1-614-249-5547" > > Using "," as the fieldsep wouldn't work. > > > -- *James Vincent* > -- Rich Smrcina
