Sponsored Content
Full Discussion: How to remove empty line.?
Top Forums Shell Programming and Scripting How to remove empty line.? Post 302975741 by ken6503 on Friday 17th of June 2016 03:47:53 PM
Old 06-17-2016
How to remove empty line.?

Hi gurus,

I have a script which works fine.

How to pass string into sql query?


Code:
while read p
do
        [ -z "$para" ] && para="'${p}'" || para="${para},'${p}'"
done < file

Moderator's Comments:
Mod Comment Please use code tags as required by forum rules!


a few days ago, there was issue pop up. in the file, there is empty line at end of the file which causes the list became 'a', 'b', 'c', ''.
I know I can remove the line with sed or other command. but just wondering if it is possible to add condition if p is '' then don't concanated.

thanks in advance.

Last edited by RudiC; 06-18-2016 at 05:28 AM.. Reason: Added code tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

remove empty directory

Hi, I need to delete an empty directory in a temp directory except "dir5" (keep everything that is not empty). Plese advise. Here is an example of my directory. /dir/temp/ dir1 - delete if this is empty dir2 - delete if this is empty dir3 - delete if this is empty dir4 - delete if this... (7 Replies)
Discussion started by: sirrtuan
7 Replies

2. UNIX for Dummies Questions & Answers

Remove only Empty Directories

I know this one was answered before in forum below - https://www.unix.com/unix-dummies-questions-answers/58210-removing-empty-folders-using-find-command.html But that one is closed & I have a question so here it goes. I want to delete all 2006 files. Now if along with the files, if the... (2 Replies)
Discussion started by: kedar.mehta
2 Replies

3. Shell Programming and Scripting

using vi -c to remove empty lines

Hello: I searched here for "vi -c" but found no hits. How can I use vi -c to remove ALL empty lines, regardless of how many? I tried <code> vi -c ":g/^$/d | wq" filename </code> but I have to run it several times. This is NOT homework. :) Thanks for your time. (3 Replies)
Discussion started by: Habitual
3 Replies

4. Shell Programming and Scripting

Fill the empty line by adding line before blank line

FIle A "A" 2 aa 34 3 ac 5 cd "B" 3 hu 67 4 fg 5 gy output shud be A"" 2 aa 34 "A" 3 ac 34 "A" 5 cd 34 "B" 3 hu 67 "B" 4 fg 67 "B" 5 gy 67 (6 Replies)
Discussion started by: cdfd123
6 Replies

5. Shell Programming and Scripting

Remove empty line and the next one

Hi all, I'm trying to remove when this condition is met: an empty and the next one I'm using this command: sed '/^$/N; s/&//' file Which searches for an empty line, N attaches it to the next line, and substituing the combination with nothing.... but it is not working. What I'm missing... (1 Reply)
Discussion started by: meuser
1 Replies

6. UNIX for Dummies Questions & Answers

remove empty field

Hi all ! I'm sure it is a basic question but I didn't find any threads that fit my need. How to remove empty fields with awk? Or in other words, how to shift all the fields after an empty field on the left? input: 1|2||3|4|5||6 wanted: 1|2|3|4|5|6 I tried: awk '{for(i=1; i<=NF;... (7 Replies)
Discussion started by: lucasvs
7 Replies

7. Shell Programming and Scripting

Remove empty records

Hello: Is there a simple way to remove empty records of FASTA format file? A FASTA format consists of two parts: header and sequence (for non-biologist, Wiki for details of course!). The header always start with ">" for the name of the sequence. The header must be in this ONLY single line.... (9 Replies)
Discussion started by: yifangt
9 Replies

8. Shell Programming and Scripting

Remove CR only on empty lines

Dear community, I have two output files that contains some CR # cat first.out 1234567890 598679857648566 9 1234567234 365837465873465 4 2342343243 289374982374894 4 # cat second.out 2342342342 ... (2 Replies)
Discussion started by: Lord Spectre
2 Replies

9. Shell Programming and Scripting

Need a program that read a file line by line and prints out lines 1, 2 & 3 after an empty line...

Hello, I need a program that read a file line by line and prints out lines 1, 2 & 3 after an empty line... An example of entries in the file would be: SRVXPAPI001 ERRO JUN24 07:28:34 1775 REASON= 0000, PROCID= #E506 #1065: TPCIPPR, INDEX= 003F ... (8 Replies)
Discussion started by: Ferocci
8 Replies

10. UNIX for Dummies Questions & Answers

Using awk to remove duplicate line if field is empty

Hi all, I've got a file that has 12 fields. I've merged 2 files and there will be some duplicates in the following: FILE: 1. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, 100 2. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, (EMPTY) 3. CDC, 54321, TEST3,... (4 Replies)
Discussion started by: tugar
4 Replies
cvm-mysql(8)						      System Manager's Manual						      cvm-mysql(8)

NAME
cvm-mysql - MySQL module SYNOPSIS
cvm-mysql CREDENTIALS
Pass phrase DESCRIPTION
This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3). CONFIGURATION VARIABLES
CVM_MYSQL_DEFAULT_FILE The full path of the defaults file to read if the following variable is set. If not set, the file $HOME/.my.cnf will be read (the MySQL default). CVM_MYSQL_DEFAULT_GROUP If set, the module will read connection default options from the named group in the defaults file as above CVM_MYSQL_HOST The hostname or IP of the MySQL server. If not set, a connection to the local host is assumed. CVM_MYSQL_USER The MySQL login ID to connect as. If not set, the invoking user is assumed. CVM_MYSQL_PASS The password for the above user. CVM_MYSQL_DB The database name, must be set. CVM_MYSQL_PORT The port number for the TCP/IP connection (only used if the server is not local). CVM_MYSQL_POSTQ (optional) The SQL query to execute after the credentials have been validated, see cvm-sql(7). CVM_MYSQL_PWCMP (optional) The password comparison module to use. CVM_MYSQL_SOCKET The path to the socket that should be used for connections to a local server. CVM_MYSQL_QUERY (optional) The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7). SEE ALSO
cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test- client(8) http://untroubled.org/pwcmp/pwcmp.html http://untroubled.org/cvm/cvm.html cvm-mysql(8)
All times are GMT -4. The time now is 05:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy