Hi all,
I want to write a script to do the following job
I have a record like
day   ID    var    Month
1      11    x     March
2      11    y     April
3      11    y     March
4      11    y     April
5      11    y     March

1      22    y     April
2      22    x     march

3      33    x     March
4      33    y     March
5      33    y     March

I want to creat a new data in such away that if Id with a var "y" march then I exclude the entire record of that ID.

So the desired out put will be

1      22    y     April
2      22    x     march

So ID 11 and 33  are excluded because both contain "y" in march.

Your assitance is highly appreciated in advance

Recommended Answers

All 2 Replies

I'm not sure shell tools are the most straightforward to use for this purpose. Are you open to other processing tools? Scripting languages?

With something like Ruby or Python this would take 20-30 lines of code. Other things that are more suited to dealing directly with records such as R or sqlite may make the job a bit easier.

What are your constraints?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.