Thats what I was asking. How many fields are there in your file and what field number is this particular field that needs to be pivoted and how is the entire record delimited. That code will be different.
The code goes into the filter command of the sequential file stage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
We have just one record with one field. However the one field will contain comma delimited values. If the one input field contains 10 comma seperated values, then we should end up with 10 records with one field on each reacord. But we will never know how many delimited values are in the one input field, could be one to many.
Marley777 wrote:We have just one record with one field. However the one field will contain comma delimited values.
OK... this has been bugging me.
What is the difference between a file where each record contains "one field" and that field contains comma delimited data and a plain old regular comma delimited file? None that I can see. Unless, I suppose, they are delivering it with quotes around the "one field".
And while you may not know how many fields there may be, there is definitely a limit to how many you can squeeze into 255 characters.
-craig
"You can never have too many knives" -- Logan Nine Fingers
You are missing the point specific to this discussion - there is only one field. People initially made the assumption it was something like you posted, but alas 'twas much simpler and hence my question.
Nice Hitchhiker's reference, btw.
-craig
"You can never have too many knives" -- Logan Nine Fingers