in reply to Re: Split lines in file to columns
in thread Split lines in file to columns

Thanks hippo that worked

If value for $colB = XYZ and $colD contains substring = Region , I need to replace the $colB from XYX to N/A

Now I am going to try this out , was stuck at that part. So gave the reason why I am looking for this solution for earlier part

In Section Seekers of Perl Wisdom