Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Problem while concating PIPE symbol with a file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Problem while concating PIPE symbol with a file
# 1  
Old 03-09-2009
Data Problem while concating PIPE symbol with a file
Hi Gurus,

I had a problem writing a pipe file.

Previously i used this code to generate a tab seperated file

ABCEF := ABCEF || 'to_char('|| abc_tab(col_num).col_name || ') chr(9) || ';


Now i want the o/p as pipe seperated file.I changed the line as below

ABCEF := ABCEF || 'to_char('|| abc_tab(col_num).col_name || ') chr(124) || ';

But it throwing an error not able to concate '|"

can u plz help me out how to put pipe as a delimiter to get the o/p


Regards,
San
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to replace the first and last character which is pipe symbol in all files within a folder?

with in my files i have the data like this, starting with a pipe and ending the line with a pipe. all i want is to replace the first and last pipe , remove those trying to use following sed command, but it is only showing on the screen the entire data of the file as if it removed, but when i... (4 Replies)
Discussion started by: cplusplus1
4 Replies

2. Shell Programming and Scripting

Remove pipe(|) symbol in except the ones which are enclosed in double quotes

I have file with are delimited by pipe(|) symbol, I wanted those to be removed except the ones which are enclosed in double quotes. If your quote file is: |Life is |Beautiful"|"Indeed life |is beautiful too|"|"But unix is fun| is not"|" It should return: Life is Beautiful"|"Indeed life is... (9 Replies)
Discussion started by: Sathyapts
9 Replies

3. Shell Programming and Scripting

Remove pipe(|) symbol ina file, except the ones which are enclosed in double quotes

I have file with are delimited by pipe(|) symbol, I wanted those to be removed except the ones which are enclosed in double quotes. If your quote file is: |Life is |Beautiful"|"Indeed life |is beautiful too|"|"But unix is fun| is not"|" It should return: Life is Beautiful"|"Indeed life is... (1 Reply)
Discussion started by: Sathyapts
1 Replies

4. Shell Programming and Scripting

Broken pipe symbol replaced with <A6><A6>

hi, i am copying an xml file from windows to linux server using filezilla&winscp. xml file contains ¦¦ symbols, after copying xml file to server ¦¦ is replaced with <A6><A6>. tried with copying xml files from windows in ascii&binary but no luck. please suggest. thanks (1 Reply)
Discussion started by: Satyak
1 Replies

5. Shell Programming and Scripting

Remove whitespace after pipe symbol but not inside words

I have a file that looks like this: 102| #2 X 1/4-INCH| 30188| EA| FTW| A| NOT SERIAL TRACKING| NOT LOT TRACKING| TRUE| #2 X 1/4-INCH 102| #2 X 1/4-INCH| 30188| EA| VPS| A| NOT SERIAL TRACKING| NOT LOT TRACKING| TRUE| #2 X 1/4-INCH 102| #6 X 1/2"| ... (2 Replies)
Discussion started by: djehresmann
2 Replies

6. Shell Programming and Scripting

How to allign output data in UNIX that is separated with a pipe "|" symbol ?

Experts , In the given output of the log file, the 2nd field that is separated by "|" pipe is not aligned well due to the uneven data length, I would like it to align the 2nd column with 37 length (that is disturbed in the output) including the pipe . The two pepe "|" would be in a aligned way... (2 Replies)
Discussion started by: rveri
2 Replies

7. Shell Programming and Scripting

Replace trailing whitespaces with pipe symbol using perl

I want to replace the whitespace with Pipe symbol to do a multiple pattern matching for the whole text "mysqld failed start" and same as for other text messages Below are the messages stored in a file seperate by whitespace mysqld failed start nfsd mount failed rpcbind failed to start for... (6 Replies)
Discussion started by: kar_333
6 Replies

8. Shell Programming and Scripting

How to cut a line with the delimeter "pipe symbol"

Hi I am unable to cut a line with the delimeter as a pipe symbol "|" COuld you please help me ? below is the code i am using right now ************ for i in `cat xyz` do source=`echo $i | cut -f 1 -d |` echo $source done ********* Error i am recieving while exceuting the above... (7 Replies)
Discussion started by: Tasha_T
7 Replies

9. Shell Programming and Scripting

remove verticalbar or pipe symbol

hi guys i have 6000 rows column the text in the column has the symbol vertical bar |. i tried some of the commands to remove it but none of the commands are reconzng this symbol. would u plz help to remove this symbol from the text with any kind of unix command u r help would be appreciated ... (9 Replies)
Discussion started by: bogu0001
9 Replies

10. UNIX for Dummies Questions & Answers

Problem working with Pipe Delimited Text file

Hello all: I have a following textfile data with name inst1.txt HDR|ABCD|10-13-2008 to 10-19-2008.txt|10-19-2008|XYZ DTL|H|5464-1|0|02-02-2008|02-03-2008||||F||||||||| DTL|D|5464-1|1|02-02-2008|02-03-2008|1||JJJ DTL|D|5464-1|2|02-02-2008|02-03-2008|1||JJJ... (9 Replies)
Discussion started by: ravi0435
9 Replies
Login or Register to Ask a Question

LEARN ABOUT FREEBSD

pipe

PIPE(2) 						      BSD System Calls Manual							   PIPE(2)

NAME

     pipe, pipe2 -- create descriptor pair for interprocess communication

LIBRARY

     Standard C Library (libc, -lc)

SYNOPSIS

     #include <unistd.h>

     int
     pipe(int fildes[2]);

     int
     pipe2(int fildes[2], int flags);

DESCRIPTION

     The pipe() system call creates a pipe, which is an object allowing bidirectional data flow, and allocates a pair of file descriptors.

     The pipe2() system call allows control over the attributes of the file descriptors via the flags argument.  Values for flags are constructed
     by a bitwise-inclusive OR of flags from the following list, defined in <fcntl.h>:

     O_CLOEXEC	 Set the close-on-exec flag for the new file descriptors.

     O_NONBLOCK  Set the non-blocking flag for the ends of the pipe.

     If the flags argument is 0, the behavior is identical to a call to pipe().

     By convention, the first descriptor is normally used as the read end of the pipe, and the second is normally the write end, so that data
     written to fildes[1] appears on (i.e., can be read from) fildes[0].  This allows the output of one program to be sent to another program: the
     source's standard output is set up to be the write end of the pipe, and the sink's standard input is set up to be the read end of the pipe.
     The pipe itself persists until all its associated descriptors are closed.

     A pipe that has had an end closed is considered widowed.  Writing on such a pipe causes the writing process to receive a SIGPIPE signal.
     Widowing a pipe is the only way to deliver end-of-file to a reader: after the reader consumes any buffered data, reading a widowed pipe
     returns a zero count.

     The bidirectional nature of this implementation of pipes is not portable to older systems, so it is recommended to use the convention for
     using the endpoints in the traditional manner when using a pipe in one direction.

RETURN VALUES

     The pipe() function returns the value 0 if successful; otherwise the value -1 is returned and the global variable errno is set to indicate
     the error.

ERRORS

     The pipe() and pipe2() system calls will fail if:

     [EMFILE]		Too many descriptors are active.

     [ENFILE]		The system file table is full.

     [ENOMEM]		Not enough kernel memory to establish a pipe.

     The pipe2() system call will also fail if:

     [EINVAL]		The flags argument is invalid.

SEE ALSO

     sh(1), fork(2), read(2), socketpair(2), write(2)

HISTORY

     The pipe() function appeared in Version 3 AT&T UNIX.

     Bidirectional pipes were first used on AT&T System V Release 4 UNIX.

     The pipe2() function appeared in FreeBSD 10.0.

BSD
								    May 1, 2013 							       BSD