Big list of data extract? How?

[tekz999]

Lets say I have a list like this:

apple
banana
cat
dog

I want to extract all lines with "a", so result is like this:
apple
banana
cat

Any idea how? Thanks!

 

[Luc]

Do you have linux server?

if so, very easy...

cat INPUTFILE | grep -i "a" > OUTPUTFILE

will output to OUTFILE all lines that contain "a"

 

[tekz999]

Please windows, preferably an addon in DRT or a fast make php script

 

[Luc]

sorry man, for big lists PHP will fail due to execution timeout, or memory usage.

if you need processing now, you can send list, i can process and send back. PM me for email address.

 

[JohnnJohnn is verified member.]

Just ftp the file to your linux webserver and run the command.

 

[tekz999]

Thanks luc! But I really need to do this myself

I remember I can put a list of words within an area in the php file, then input the letter/word I am looking for in another area, then it will run, and auto-save it as a new file, then I simply login to FTP and download the newest file.

 

[Luc]

well. if you have file on server, you can run this command from php...

<?php

exec('cat INPUTFILE | grep -i "a" > OUTPUTFILE');

?>

there are a million ways to do it, but i am too lazy to write the php code, it's best to execute from server. good luck!

 

[tekz999]

It worked @.@
Thanks for the great help Luc!

How do I make it run and capitalize the first letter after a "space"?

e.g.
apple orange

becomes:
apple Orange

Thanks!

 

[Luc]

in the php file, the exec should have this..

exec('cat INFILE | grep -i "a" | sed "s/ [a-zA-z]/\U&/gi" > OUTFILE');

 

[tekz999]

Perfect again @.@