Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Carriage return or line feed issues
Top Forums Programming Carriage return or line feed issues Post 302366923 by Scott on Friday 30th of October 2009 07:57:13 PM
Old 10-30-2009
Hi.

It prints a carriage return where? Can you define your problem more specifically, and say why you think it happens in the group by clause?

Otherwise, plan B...

You've posted a lot of code and it would help if you could now post the DDL of the tables you've used:

i.e, the result of:
Code:
SELECT DBMS_METADATA.GET_DDL('TABLE', tabs.TABLE_NAME)
FROM USER_TABLES tabs
WHERE tabs.TABLE_NAME in ('period_hierarchy_id', '...', '...' );

so that I at least don't have to spend my weekend creating all this stuff! (ideally uploading an export (with or without data) would be perfect!)

Can you also say what values I should give to the && prompts that you are using?

And also anything else you think may be relevant!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

carriage return/line feeds

Hello, I have a file that has got carriage returns in it and I want to take them out. Anyone know how I can do this in a ksh? thanks (4 Replies)
Discussion started by: pitstop
4 Replies

2. Shell Programming and Scripting

Removing Carriage Return and or line feed from a file

Hello I'm trying to write a shell script which can remove a carriage return and/or line feed from a file, so the resulting file all ends up on one line. So, I begin with a file like this text in file!<CR> line two!<CR> line three!<CR> END!<CR> And I want to end up with a file... (1 Reply)
Discussion started by: tbone231
1 Replies

3. Shell Programming and Scripting

How to insert carriage return before line feed?

I am doing some edi where translations had to be run on unix. Generally when I run the translations on windows, the output file has both carriage returns and line feed where as when ran on unix will have only line feed. I need to insert carriage return before the line feed. Is there some tool... (2 Replies)
Discussion started by: huey ing
2 Replies

4. UNIX for Dummies Questions & Answers

To remove carriage return between the line

Hi, I have a situation where I need to remove the carriage return between the lines. For.eg. The input file: 1,ad,"adc sdfd",edf 2,asd,"def fde",asd The output file should be 1,ad,adc sdfd,edf 2,asd,def fde,asd Thanks Shash (5 Replies)
Discussion started by: shash
5 Replies

5. Shell Programming and Scripting

Need a carriage return at end of each line

Hi All, I am reading two files and writing out the file name and count of lines in each file to an output file. My script looks like this: echo "input_file1.out;`wc -l < input_file1.out | sed 's/^]*\(.*\)]*$/\1/'` " > comp_file1.out echo "input_file2.out;`wc -l < input_file2.out | sed... (2 Replies)
Discussion started by: Hangman2
2 Replies

6. Shell Programming and Scripting

Bash - multiple line carriage return

Hello! I have one strange question - let's say I have a long, multiple-line string displayed on the terminal using echo, and I would like to make a carriage return to the beginning of this string, no to the beginning of the last line - is something like that possible? I would like to be able to... (1 Reply)
Discussion started by: xqwzts
1 Replies

7. Shell Programming and Scripting

line carriage return characters

Hi, I would like to insert the line carriage retrun characters on each line. (2 Replies)
Discussion started by: koti_rama
2 Replies

8. Shell Programming and Scripting

Need Help to delete carriage return and new line in csv file

Hi All, I have a problem loading the data from a csv file As you see below in the Input ,For the Data starting with " there are 2 lines, which i want to make them into single without changing the format of that data. You can see the desired output below: While i try to open the csv file and... (4 Replies)
Discussion started by: mlavanya
4 Replies

9. Shell Programming and Scripting

Remove carriage return and append the next line

Hi All, My requirement is to remove the carriage return in from the lines which i am reading if the length is lesser than 1330 and append the next line with it. Below is the realistic example of file structure. Input file: Blah blah blah blah Blah blah blah blah Blah blah blah blah Blah... (16 Replies)
Discussion started by: mad man
16 Replies

10. UNIX for Beginners Questions & Answers

awk Command to add Carriage Return and Line Feed

Hello, Can someone please share a Simple AWK command to append Carriage Return & Line Feed to the end of the file, If the Carriage Return & Line Feed does not exist ! Thanks (16 Replies)
Discussion started by: rosebud123
16 Replies

LEARN ABOUT HPUX

fingerd

fingerd(1M)															       fingerd(1M)

NAME

       fingerd - remote user information server

SYNOPSIS

DESCRIPTION

       is  the	server	for  the  RFC 742 Name/Finger protocol.  It provides a network interface to which gives a status report of users currently
       logged in on the system or a detailed report about a specific user (see finger(1)).  The Internet daemon executes when it receives  a  ser-
       vice request at the port listed in the services data base for ``finger'' using ``tcp'' protocol; see inetd(1M) and services(4).

       To start from the configuration file must contain an entry as follows:

       Once  a remote host is connected, reads a single ``command line'' terminated by a carriage-return and line-feed.  It uses this command line
       as the arguments to an invocation of sends the output of to the remote host and closes the connection.

       If the command line is null (contains only a carriage-return and line-feed pair), returns a report that lists all users logged  in  on  the
       system at that moment.

       If  a  user  name  is specified on the command line (for example, user<CR><LF>), the response lists more extended information for only that
       particular user, whether logged in or not.  See finger(1) for the details of this extended information.

       If is run with the option, it allows remote user names on the command line (for example, user@host<CR><LF>).   Otherwise,  if  the  command
       line contains a remote user name, prints the error message and closes the connection.

AUTHOR

       was developed by the University of California, Berkeley and HP.

SEE ALSO

       finger(1), inetd(1M), services(4),
       RFC 742 for the Name/Finger protocol.

																       fingerd(1M)
All times are GMT -4. The time now is 11:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy