How do I create a tab delimited text document?

Hi. I use Putty to ssh logs (back end calls) from a webpage. This brings back information as follows........ for example:
1.1.0   L       EN      US      200711160-0500     eusearch        0       b8482      f         r_CA_aolcom     TEST    webMinWO_fr_CA_aolcom   L1      growth -     Wide    matchingsites.jsp.M     10      websearch

Usually I used to copy this straight into a notepad and send it on for testing. However now to make things quicker it is desired that such a document can be parsed and tested that way. So basically I need to save this data in a tab delimited or parser friendly document. I don't know how to save data form a ssh putty session other then copy and pasting the data into a word doc. Any suggestions?
glapotsAsked:
Who is Participating?
 
ahoffmannConnect With a Mentor Commented:
simply feed the data to;
  | tr -s ' ' '\011'

(assuming that spaces are used wher you want to have tabs)
0
 
kylealanhaleCommented:
Or, you could use something like webalizer (http://www.mrunix.net/webalizer/) that will parse them for you.
0
 
glapotsAuthor Commented:
I suppose what I'm looking for to put it simple is to save the data from the putty session in the way it is logged
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Gabriel OrozcoSolution ArchitectCommented:
why you do not use awk?

there is awk for windows too ;)
http://gnuwin32.sourceforge.net/packages/gawk.htm

c:\>type puttylogfile.log | awk '{print $1,$2, $3, $4 $5, $6}'
or something like that
0
 
glapotsAuthor Commented:
ahoffmann:

simply feed the data to;
  | tr -s ' ' '\011'

(assuming that spaces are used wher you want to have tabs)

Thanks for the reply. Where does this save the data to?

0
 
ahoffmannCommented:
> Where does this save the data to?
on the screen, or the file you specified for that screen, or the file you redirect to when you call such a command ...
Is there a problem to redirect the output?
   your-command-producing-space-delimited-output|tr -s ' ' '\011'>save
0
 
glapotsAuthor Commented:
ahoffmann:

> Where does this save the data to?
on the screen, or the file you specified for that screen, or the file you redirect to when you call such a command ...
Is there a problem to redirect the output?
   your-command-producing-space-delimited-output|tr -s ' ' '\011'>save


But how do I retrieve the file with the data?
0
 
ahoffmannCommented:
depends on wher it is saved, if you use putty to capture and log the output it's on your local system, otherwise you have to copy the file (with redirected output) to your system
0
All Courses

From novice to tech pro — start learning today.