Splitting record into multiple rows.
Posted: Sat Aug 22, 2015 2:27 am
Hello - I have an input file with the following format:
First column (one or more member Ids) are from 1 to 100 bytes.
Second column (effective date) is from 101 to 110 bytes.
My output needs to look like this:
Any suggestions on how to achieve this using Sort or Icetool? Thanks in advance.
First column (one or more member Ids) are from 1 to 100 bytes.
Second column (effective date) is from 101 to 110 bytes.
1-------------------100 101------110
16925178 2014-01-10
"6260947, 7996116" 2015-12-31
2268370 2014-07-01
"384121, 5597844" 2010-08-23
16925178 2014-01-10
"6260947, 7996116" 2015-12-31
2268370 2014-07-01
"384121, 5597844" 2010-08-23
My output needs to look like this:
16925178 2014-01-10
6260947 2015-12-31
7996116 2015-12-31
2268370 2014-07-01
384121 2010-08-23
5597844 2010-08-23
6260947 2015-12-31
7996116 2015-12-31
2268370 2014-07-01
384121 2010-08-23
5597844 2010-08-23
Any suggestions on how to achieve this using Sort or Icetool? Thanks in advance.