Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Line Break problem
Top Forums Shell Programming and Scripting Line Break problem Post 302661981 by mad_man12 on Tuesday 26th of June 2012 03:31:40 AM
Old 06-26-2012
Line Break problem
Hi All,
Please can you advise/help on the below issue
i did a bcp out of a table, it is having problem of line break such that one line is getting broken in two lines for many records.

Code:
 
eg
Correct format 
Line 1: - 000f00000bfe2c2c    000218310300000000GBP   GBP 734654  10970.35    66505.459999999992  -55535.110000000001 -55535.110000000001 1   1   0002    
183103    00000000    GBP 100 -55535.110000000001 -55535.110000000001 10970.35    66505.459999999992  0   1

However after the bcp in the txt file in many records ( not all) it is appearing as
Line1: -   000f00000bfe2c2c    000218310300000000GBP   
Line 2:-   GBP 734654  10970.35    66505.459999999992  -55535.110000000001 -55535.110000000001 1   1   0002    183103    00000000    GBP 100 -55535.110000000001 
-55535.110000000001 10970.35    66505.459999999992  0   1

Now i know i can do a shift+J at the end of line 1, but since it has more than 1 lakh records the manual effort is too much
Please can advise if any automated script can be written to overcome it takin into account not all records in the file have the problem, some are appearing fine.
Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove Line Break

Dear all, Please advise what approach can remove all line break from a text file? e.g. Source file: A B C Target file: A, B, C Thanks, Rock (5 Replies)
Discussion started by: Rock
5 Replies

2. Shell Programming and Scripting

TO break a line

hi All, Have a doubt in ksh..Am not familiar with arrays but i have tried out a script.. plzzzzz correct me with the script My i/p File is: (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 192.168.2.2) (Port = 1525) ) ) (CONNECT_DATA = (SID = TESTDB1) ) ) ... (7 Replies)
Discussion started by: aajan
7 Replies

3. UNIX for Dummies Questions & Answers

Inserting line break where ';' is

I did some past data manipulations using awk so I could join lines in order to use grep. Now that I have newly searched data I need to insert a new line break to use further statistical packages. I have a data base that looks something like this: ... (3 Replies)
Discussion started by: kkohl78
3 Replies

4. Shell Programming and Scripting

Insert line break

Dear All, thanks in advance input file 410530AAANNNNNAAA410530JJJJJJYYYY410530PPPPPAAAAAA........... I want output like 410530AAANNNNNAAA 410530JJJJJJYYYY 410530PPPPPAAAAAA Thanks (10 Replies)
Discussion started by: The_Archer
10 Replies

5. Shell Programming and Scripting

BASH: Break line, read, break again, read again...

...when the lines use both a colon and commas to separate the parts you want read as information. The first version of this script used cut and other non-Bash-builtins, frequently, which made it nice and zippy with little more than average processor load in GNOME Terminal but, predictably, slow... (2 Replies)
Discussion started by: SilversleevesX
2 Replies

6. Shell Programming and Scripting

Add line break for each line in a file

I cannot seem to get this to work.. I have a file which has about 100 lines, and there is no end of line (line break \n) at the end of each line, and this is causing problem when i paste them into an application. the file looks like this this is a test that is a test balblblablblhblbha... (1 Reply)
Discussion started by: fedora
1 Replies

7. Shell Programming and Scripting

Line break on word

I have a file that contains the following: ^field LINE_1 data ^field LINE_2 data ^field LINE_3 data ^field LINE_4 data ^field LINE_5 data ... And im looking to do a line break at the end of the number before the text to make it look like this ^field LINE_1 ... (11 Replies)
Discussion started by: darbs121
11 Replies

8. Shell Programming and Scripting

Break single line in 4

How can i break a single line into 5 lines # joseluiz.silvano; Ramal4846; Sala4121; SetorCorregedoria host DF04488962 { hardware ethernet 00:16:41:68:57:0B; fixed-address 10.100.111.245; } INTO # joseluiz.silvano; Ramal4846; Sala4121; SetorCorregedoria host DF04488962 {... (5 Replies)
Discussion started by: danielldf
5 Replies

9. UNIX for Dummies Questions & Answers

VI Line Break?

So I'm in a Unix class and our assignment was to go into VI and write a script to make this file tree. At the end of it, I'd like it to echo "This is the file tree you've created" then a line break, then . But I'm not sure as to who to do it. Is there a way for when I run it (./filesystem), the... (4 Replies)
Discussion started by: bbowers
4 Replies

10. Shell Programming and Scripting

How to break the line to the one above?

Hello everyone! I'm trying to make the below file1 look like file2, can anyone help? Basically I just hit backspace on every line that starts with a number. Thanks! file1: THIS#IS-IT1 4 THIS#IS-IT2 3 THIS#IS-IT3 2 THIS#IS-IT4 1 Result > file2: (4 Replies)
Discussion started by: demmel
4 Replies

LEARN ABOUT DEBIAN

gbp-create-remote-repo

GBP-CREATE-REMOTE-REPO(1)				      git-buildpackage Manual					 GBP-CREATE-REMOTE-REPO(1)

NAME

       gbp-create-remote-repo - Create remote repositories

SYNOPSIS

       gbp-create-remote-repo  [  --verbose  ] [ --color=[auto|on|off] ] [ --remote-url-pattern=url-pattern ] [ --remote-name=name ] [ --template-
       dir=directory ] [ --remote-config=config ] [ --[no-]pristine-tar ] [ --debian-branch=branch_name  ]  [  --upstream-branch=branch_name  ]  [
       --[no-]track ]

DESCRIPTION

       gbp-create-remote-repo  creates	a  repository at a remote location via ssh and pushes the local repository into it. It then sets up remote
       branch tracking so you can use gbp-pull to update your repository from there.

       Before performing any action on the remote location it will print the remote URL and ask for confirmation.

       Note: By default the remote repositories are created in the collab-maint repository on git.debian.org.

OPTIONS

       --remote-url-pattern=pattern
	      Where to create the remote repository. The part %(pkg)s will be replaced by the package name.

       --remote-name=name
	      What name git will use when refering to that repository, e.g.  'origin'.

       --template-dir=directory
	      Template directory to pass to git init on the remote side. This can be used to customize the  remote  repository,  e.g.  to  set	up
	      hooks.

       --remote-config=config
	      Name of a config file section in gbp.conf that specifies the above paramters. See [XRef to GBP.MAN.GBP.CONF] manpage for details.

       --debian-branch=branch_name
	      The branch in the Git repository the Debian package is being developed on, default is master.

       --upstream-branch=branch_name
	      The branch in the Git repository the upstream sources are put onto. Default is upstream.

       --pristine-tar
	      Whether to push the pristine tar branch.

       --verbose

       -v     verbose execution

       --color=[auto|on|off]
	      Whether to use colored output.

       --[no-]track
	      Whether to set up branch tracking for the debian, upstream and pristine-tar branches.

CONFIGURATION FILES

       Several	gbp.conf  files  are  parsed  to  set defaults for the above commandline arguments. See the [XRef to GBP.MAN.GBP.CONF] manpage for
       details.

SEE ALSO

       git-buildpackage(1), gbp-pull(1), gbp.conf(5)

AUTHOR

       Guido Guenther <agx@sigxcpu.org>

								   01 June 2012 					 GBP-CREATE-REMOTE-REPO(1)
All times are GMT -4. The time now is 07:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy