Solved

How do I create a tab delimited text document?

Posted on 2007-11-16
8
372 Views
Last Modified: 2013-12-26
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?
0
Comment
Question by:glapots
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 3

Expert Comment

by:kylealanhale
ID: 20299521
Or, you could use something like webalizer (http://www.mrunix.net/webalizer/) that will parse them for you.
0
 

Author Comment

by:glapots
ID: 20299649
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
 
LVL 19

Expert Comment

by:Gabriel Orozco
ID: 20300845
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 51

Accepted Solution

by:
ahoffmann earned 500 total points
ID: 20303839
simply feed the data to;
  | tr -s ' ' '\011'

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

Author Comment

by:glapots
ID: 20309609
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
 
LVL 51

Expert Comment

by:ahoffmann
ID: 20310691
> 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
 

Author Comment

by:glapots
ID: 20318654
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
 
LVL 51

Expert Comment

by:ahoffmann
ID: 20319015
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

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
unix example issues 18 114
how can I get a RHEL kickstart file to attach a specific red hat network subscription ? 9 109
centos linux 65 235
Changing password for HP switch 5 111
Secure Shell (SSH) is a network protocol for secure data communication, mainly used to administer remote Unix / Linux servers via command line. But it also allows the user to open a secure tunnel between a client and a server where he can send any k…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Viewers will learn how to properly install and use Secure Shell (SSH) to work on projects or homework remotely. Download Secure Shell: Follow basic installation instructions: Open Secure Shell and use "Quick Connect" to enter credentials includi…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question