Hi !
I have long string I need to split it with defined delimitor
and output multiple rows to seq file.
How to do it ?
Row splitting
Moderators: chulett, rschirm, roy
Snassimr,
there are several very different ways to do this that depend upon your data. Does the string already contain the delimiters or do you want to break it up into chunks of length n; is the string of fixed length?
Have you looked into using the row splitter stage and why do you feel you can't use it?
there are several very different ways to do this that depend upon your data. Does the string already contain the delimiters or do you want to break it up into chunks of length n; is the string of fixed length?
Have you looked into using the row splitter stage and why do you feel you can't use it?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Could you give us a sample input row and output row?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Write a Transform with a derivation "EReplace(In.Column,'\\\',CHAR(010))" to replace all occurrences of '\\\' with a single LF. Write this to a sequential file or pipe with no formatting - no quotes or separators and use the UNIX style line termination. Then read the file and it will be in the format you desire.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>