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 V7

pipe

PIPE(2) 							System Calls Manual							   PIPE(2)

NAME

       pipe - create an interprocess channel

SYNOPSIS

       pipe(fildes)
       int fildes[2];

DESCRIPTION

       The pipe system call creates an I/O mechanism called a pipe.  The file descriptors returned can be used in read and write operations.  When
       the pipe is written using the descriptor fildes[1] up to 4096 bytes of data are buffered before the writing process is suspended.   A  read
       using  the  descriptor  fildes[0] will pick up the data.  Writes with a count of 4096 bytes or less are atomic; no other process can inter-
       sperse data.

       It is assumed that after the pipe has been set up, two (or more) cooperating processes (created by subsequent fork calls)  will	pass  data
       through the pipe with read and write calls.

       The Shell has a syntax to set up a linear array of processes connected by pipes.

       Read calls on an empty pipe (no buffered data) with only one end (all write file descriptors closed) returns an end-of-file.

SEE ALSO

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

DIAGNOSTICS

       The  function value zero is returned if the pipe was created; -1 if too many files are already open.  A signal is generated if a write on a
       pipe with only one end is attempted.

BUGS

       Should more than 4096 bytes be necessary in any pipe among a loop of processes, deadlock will occur.

ASSEMBLER

       (pipe = 42.)
       sys pipe
       (read file descriptor in r0)
       (write file descriptor in r1)

																	   PIPE(2)