> I would like to build a PIPE to grab different fields as needed. I can > 'un-CSV' the data but that takes quite a bit of time and processing > considering the amount of data. > > Blue-sky would be to have FS/Fieldsep work something like SPEC FS CSV F12 > 1 ... but I know that is not likely.
It sort of does, like in spec fs , f12 1 but the challenge is fields that have a comma in (which is why you have strings in the first place). The following will give you one field per record. | split , | joincont not trailing /"/ /,/ Combine that with "juxtapose count" to make each field prefixed by its original field number. Then you can select the fields by their number in the first 10 positions. If you happen to know some special character that does not exist in the data, you could "joincont" with something else, rebuild the records, and use "fs ," where you want and "xlate" the comma back. Being able to parse XML has been on my list for some time, suppose CSV would be a good one to add. Rob --- Rob van der Heij z/VM Development, CMS Pipelines
