using icetool sort records whose position is not fixed
Posted: Fri Sep 11, 2015 6:03 pm
I need to select records that match my parm,
For eg:
My parm will be "abc" or "#abc#"
My input file is
#123#abc#myfirstday#
#12345#abc#myfirstday#
#12#abc#myfirstday#
#12346789#xyz#myfirstday#
#1231234564#xyz#myfirstday#
#12367#abc#myfirstday#
#1233#xyz#myfirstday#
From this I want only those records which contain #abc#.
My problem is as the position of # is not fixed and the # is occuring more than once how do I select only the required records?
For eg:
My parm will be "abc" or "#abc#"
My input file is
#123#abc#myfirstday#
#12345#abc#myfirstday#
#12#abc#myfirstday#
#12346789#xyz#myfirstday#
#1231234564#xyz#myfirstday#
#12367#abc#myfirstday#
#1233#xyz#myfirstday#
From this I want only those records which contain #abc#.
My problem is as the position of # is not fixed and the # is occuring more than once how do I select only the required records?