Re: parsing a CSV column

[Bdietz400 <bdietz400@xxxxxxxxx>]

I recall that Scott had a cab parser. 
I used for this exact issue


--
Bryan Dietz

> On Aug 7, 2015, at 1:00 PM, rob@xxxxxxxxx wrote:
>
> Lets say I run a command the automatically populates a db2 column with
> lparname1,1,status
> lparname2,2,status
> lparname3,3,status
> No danger of a comma being imbedded other than as shown.  IOW no risk of 
> "lpar,1,name",1,status.
> I know I can parse this out with SQL with a bunch of LOCATE's and whatnot. 
> But, if there's some cool function that I'm missing I'd rather examine 
> that.
> My workaround may be to pipe this out to a stream file instead of a DB2 
> file and use CPYFRMIMPF.  And if "I'm" looking at CPYFRMIMPF you know 
> that's desperation.
>
> No CSVPARSE(fromstring, ColumnNbr) is there?
>
>
> Rob Berendt
> -- 
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>          Garrett, IN 46738
> Ship to:  Dock 108
>          6928N 400E
>          Kendallville, IN 46755
> http://www.dekko.com
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.