Without seeing the output you want, it's difficult to tell, but you could try changing spaces into tabs:
Code:
# Quick example
$ tr ' ' '\t' <<EOF
> 20140327 BU 9A 3
> 20140327 SPACE 9A 3
> 20140327 BU 9F 33
> 20140327 SPACE 9F 33
> 20140327 BU 9L 17
> 20140327 SPACE 9L 18
> EOF
20140327 BU 9A 3
20140327 SPACE 9A 3
20140327 BU 9F 33
20140327 SPACE 9F 33
20140327 BU 9L 17
20140327 SPACE 9L 18
# How you'd probably use it
$ tr ' ' '\t' < inputfile > outputfile
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
Hi! Everyone
I am new to the shell scripting basically.I have been asked to create a shell script that connect to a oracle database to read data from a particular schema then spool it into a csv file then email to customer.
Can anybody let me know how to go about that.
I have create... (14 Replies)
Hi All,
Please help me in writing data to a file in one row.
In database there is a column which contains large data which does not fit in the file in one row. The column contains list of paths. I want to write these paths to a file in one row.
Please find the code below writes :
... (2 Replies)
Hi everyone!!
I need help regarding this.
How can we load data from DB2 Database tables into a Comma Separated File?
I also have another Question? Using Shell scripting, Is it easy to read Data from a table or from a text file?
It is very urgent for me. Please help me out guys.
... (1 Reply)
Hi
I'm using and Oracle 10g Database.
I want to write a script to retrieve data from the database and store it toa file.
I'm using simple sql statements such as
Select * from celltable
I don't know how to specify the database name etc.
I have this but it doesn't work
... (1 Reply)
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
LEARN ABOUT MOJAVE
tcp_table
TCP_TABLE(5) File Formats Manual TCP_TABLE(5)NAME
tcp_table - Postfix client/server table lookup protocol
SYNOPSIS
postmap -q "string" tcp:host:port
postmap -q - tcp:host:port <inputfile
DESCRIPTION
The Postfix mail system uses optional tables for address rewriting or mail routing. These tables are usually in dbm or db format. Alterna-
tively, table lookups can be directed to a TCP server.
To find out what types of lookup tables your Postfix system supports use the "postconf -m" command.
To test lookup tables, use the "postmap -q" command as described in the SYNOPSIS above.
PROTOCOL DESCRIPTION
The TCP map class implements a very simple protocol: the client sends a request, and the server sends one reply. Requests and replies are
sent as one line of ASCII text, terminated by the ASCII newline character. Request and reply parameters (see below) are separated by white-
space.
Send and receive operations must complete in 100 seconds.
REQUEST FORMAT
Each request specifies a command, a lookup key, and possibly a lookup result.
get SPACE key NEWLINE
Look up data under the specified key.
put SPACE key SPACE value NEWLINE
This request is currently not implemented.
REPLY FORMAT
Each reply specifies a status code and text. Replies must be no longer than 4096 characters including the newline terminator.
500 SPACE text NEWLINE
In case of a lookup request, the requested data does not exist. In case of an update request, the request was rejected. The text
describes the nature of the problem.
400 SPACE text NEWLINE
This indicates an error condition. The text describes the nature of the problem. The client should retry the request later.
200 SPACE text NEWLINE
The request was successful. In the case of a lookup request, the text contains an encoded version of the requested data.
ENCODING
In request and reply parameters, the character %, each non-printing character, and each whitespace character must be replaced by %XX, where
XX is the corresponding ASCII hexadecimal character value. The hexadecimal codes can be specified in any case (upper, lower, mixed).
The Postfix client always encodes a request. The server may omit the encoding as long as the reply is guaranteed to not contain the % or
NEWLINE character.
SECURITY
Do not use TCP lookup tables for security critical purposes. The client-server connection is not protected and the server is not authenti-
cated.
BUGS
Only the lookup method is currently implemented.
The client does not hang up when the connection is idle for a long time.
SEE ALSO postmap(1), Postfix lookup table manager
regexp_table(5), format of regular expression tables
pcre_table(5), format of PCRE tables
cidr_table(5), format of CIDR tables
README FILES
Use "postconf readme_directory" or "postconf html_directory" to locate this information.
DATABASE_README, Postfix lookup table overview
LICENSE
The Secure Mailer license must be distributed with this software.
AUTHOR(S)
Wietse Venema
IBM T.J. Watson Research
P.O. Box 704
Yorktown Heights, NY 10598, USA
Wietse Venema
Google, Inc.
111 8th Avenue
New York, NY 10011, USA
TCP_TABLE(5)