<!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 dir=ltr align=left><SPAN class=248083520-24022009><FONT face=Arial
color=#0000ff size=2>I'm not sure... some kind of a non-disclosure agreement
between our company and the vendor. They told me this from THE BEGINNING. (Side
note: Anybody know Latin?) ;-) That never made sense to me... does that
mean I can't list the application on my resume?</FONT></SPAN></DIV>
<DIV><SPAN class=248083520-24022009><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=248083520-24022009><FONT face=Arial color=#0000ff
size=2>CSV's... delimited and fixed-width. I was going to try my hand at writing
a process or two in a bash script. I was just wondering if anyone ever saw a GUI
or even ncurses front end for this. </FONT></SPAN></DIV>
<DIV><SPAN class=248083520-24022009><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=248083520-24022009><FONT face=Arial color=#0000ff size=2>Some
of the parameters for the functions in the applcation are the same as
the command switches, max buffer for sorts, temporary directory to use,
etc. </FONT></SPAN></DIV>
<DIV><SPAN class=248083520-24022009><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2></FONT><FONT
face=Arial color=#0000ff size=2></FONT><BR></DIV>
<DIV></DIV>Peter,
<DIV><BR></DIV>
<DIV>Whose stopping you from mentioning it? Employer or vendor?</DIV>
<DIV><BR></DIV>
<DIV>Also what are you ETLing from? CSV, EDI, XML, etc.</DIV>
<DIV><BR></DIV>
<DIV>At a basic level though, you can write shell scripts pipe all those
commands to get your data in a format that can be bulkloaded into your
database..</DIV>
<DIV><BR></DIV>
<DIV><BR><BR>
<DIV class=gmail_quote>On Tue, Feb 24, 2009 at 3:21 PM, Peter Capazzi <SPAN
dir=ltr><<A
href="mailto:Peter.Capazzi@tranzactis.com">Peter.Capazzi@tranzactis.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<DIV><SPAN><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><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN><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><FONT face=Arial size=2>sort - sorting datasets on a
field</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial size=2>join - merging data
sets</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial size=2>cut - field
selections/exclusions</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial size=2>cat - for input files</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial size=2>sed - To modify fields</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial size=2>grep - To filter</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial size=2>awk - To modify fields and partition
datasets. </FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial
size=2></FONT></SPAN> </DIV></DIV><BR>_______________________________________________<BR>Lilug
mailing list<BR><A href="mailto:Lilug@lilug.org">Lilug@lilug.org</A><BR><A
href="http://lists.lilug.org/listinfo.cgi/lilug-lilug.org"
target=_blank>http://lists.lilug.org/listinfo.cgi/lilug-lilug.org</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>