Arrangeing Swap text data in format
Hi,
Please guide me if there is any option of converting text from the
following format using regexp etc,
1,a,b,c,d,e,f,d
2,aa,bb,cc,dd,ee,ff
1,6a,6b,6c,6d,6e,6c
2,7a,7b,7c,7d,7e,7f
to be group into 1'ns together and 2's together as follows.
1,a,b,c,d,e,f,d
1,6a,6b,6c,6d,6e,6c
2,aa,bb,cc,dd,ee,ff
2,7a,7b,7c,7d,7e,7f
Please help
Sharada.B