<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.3790.3123" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=903200920-24022009><FONT face=Arial size=2>At our work place we
use a software that has a pretty heavy price tag. I'm actually not supposed
to mention it by name. Anyway, the more I work with and the more I learn about
linux I see some similarities between commands in linux and the functions in
this application. </FONT></SPAN></DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial size=2>I was wondering if
there was a "poor man"s ETL engine that is simply a front end to commands like
these:</FONT></SPAN></DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial size=2>sort - sorting
datasets on a field</FONT></SPAN></DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial size=2>join - merging data
sets</FONT></SPAN></DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial size=2>cut - field
selections/exclusions</FONT></SPAN></DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial size=2>cat - for input
files</FONT></SPAN></DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial size=2>sed - To modify
fields</FONT></SPAN></DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial size=2>grep - To
filter</FONT></SPAN></DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial size=2>awk - To modify
fields and partition datasets. </FONT></SPAN></DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=903200920-24022009><FONT face=Arial
size=2></FONT></SPAN> </DIV></BODY></HTML>