Sponsored Content
Top Forums Shell Programming and Scripting Re align in one row using sed Post 302979714 by MadeInGermany on Thursday 18th of August 2016 06:44:36 AM
Old 08-18-2016
Quote:
Originally Posted by Akshay Hegde
In awk

Code:
[akshay@localhost tmp]$ cat f
"url1","abc","project url1"
2016-08-16
"url2,"microsoft","project url2"
2016-08-18

Code:
[akshay@localhost tmp]$ awk '{printf("%s%s%s",NF==1?OFS:"",$0,NF==1?RS:"")}' OFS=, f
"url1","abc","project url1",2016-08-16
"url2,"microsoft","project url2",2016-08-18

---------- Post updated at 09:58 AM ---------- Previous update was at 09:56 AM ----------

If you need quote then
Code:
[akshay@localhost tmp]$ awk 'NF==1{$0=q $0 q}{printf("%s%s%s",NF==1?OFS:"",$0,NF==1?RS:"")}' q='"' OFS=, f
"url1","abc","project url1","2016-08-16"
"url2,"microsoft","project url2","2016-08-18"

A bit simplified, extra quotes in red:
Code:
awk '{printf "%s",(NF==1)?(",\"" $0 "\"" RS):$0}' test.csv

A Unix/GNU sed solution:
Code:
sed '$!N; s/\n\([^,]*\)$/,"\1"/' test.csv

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to update a single row in a file with sed

Hi. I want to be able to update only one line in a file that matches a key using sed, but I can't seem to get this (the key is right at the beginning of each row) Here is what I have tried so far, but every row is being updated. I want the end result to be that the input file only has the single... (6 Replies)
Discussion started by: brendanf
6 Replies

2. Shell Programming and Scripting

How to assign value to a variable with row(using -n) returned by sed

Hi Friends, REQUIREMENT: Want to delete files from the current directory match with the same in the file test.txt set -x i=1 echo "i=$i" COUNT=`sed -n '$=' test.txt` echo "Count=$COUNT" while do "## Here is error##" FILETOREMOVE=`sed -n \'$i,1p\' test.txt` echo $FILETOREMOVE... (5 Replies)
Discussion started by: sourabhsharma
5 Replies

3. Shell Programming and Scripting

sed command to delete row

I want to use sed command to delete a matched row with a pattern. And I also want to delete previous and next row of that row. Which option can I use with sed ? (9 Replies)
Discussion started by: anhtt
9 Replies

4. Shell Programming and Scripting

Add row, awk, sed ?

I wrote script in bash which generates this report: phrase1;phrase2;phrase3;phrase4;phrase5;phrase6;phrase7;phrase8 phrase9;phrase2;phrase10;phrase4;phrase11;phrase12;phrase13;phrase14 phrase15;phrase16;phrase17;phrase18;phrase19;phrase20;phrase21;phrase22 ... I would like add name only... (3 Replies)
Discussion started by: patrykxes
3 Replies

5. Shell Programming and Scripting

help with sed to add delimiter and new field to each row

I have a file with millions of rows that I need to add a delimiter and a new field with a zero to the end of each row. (its too big to open and do a find and replace regex) I'm looking for the next line '\n' and need to replace it with a Unit Separator (hex \037) 0 \n. I've tried the... (2 Replies)
Discussion started by: kmac
2 Replies

6. Shell Programming and Scripting

SED: delete matching row and 4 next rows?

Hi, Tried to look for solution, and found something similar but could not adapt the solution for my needs.. I'm trying to match a pattern (in this case "ProcessType")in a logfile, then delete that line and the 4 following lines. The logfile looks as follows: ProcessType: PROCESS_A... (5 Replies)
Discussion started by: Juha
5 Replies

7. Shell Programming and Scripting

Replace last row of a column in bash/awk/sed

Hi, I've got a file with 3 columns which ends like this: ... 1234 345 1400 5287 733 1400 8472 874 1400 9317 726 1400 I want to replace the last row of the last column with the value 0. So my new file will end: ... 1234 345 1400 5287 733 1400 8472 874 1400 9317 726 ... (5 Replies)
Discussion started by: jhunter87
5 Replies

8. Shell Programming and Scripting

awk/sed to get unique row

Hello ALL, I have very huge file almost 25G size contents of the file are "|" delimited columns on each row eg: 1396745|1078529|KDS|2011-04-21 00:00:00.0|1100|30|2|2011-04-20 22:35:24.0|2011-04-20 22:35:24.0|0|2011-04-21 00:00:00.0|1100|2222434|2011-04-21 11:00:00.0|0|0|2011-06-29... (10 Replies)
Discussion started by: posner
10 Replies

9. Shell Programming and Scripting

Insert row without deleting previous data using sed

Hello, I want to add a new row to a file to insert data without deleting the previous data there. Example: file a b c d Output a b newtext c (6 Replies)
Discussion started by: joseamck
6 Replies

10. Shell Programming and Scripting

sed not see last row

Hi Everyone! I have a problem my script. I'm useing sed to find the separate character in my text sed 's/"*"//g' ./myfile.txt My problem: When the last row is doesn't has enter in the end of line, the sed is not work. So if i have a 30 rows text i will see 29 rows separators. Please help... (9 Replies)
Discussion started by: snayper
9 Replies
TRAYER(1)						      General Commands Manual							 TRAYER(1)

NAME
trayer - a lightweight GTK2-based systray for UNIX desktop SYNOPSIS
trayer -h trayer -v trayer [--edge left|right|top|bottom|none] [--align left|right|center] [--margin <size>] [--widthtype request|pixel|percent ] [--width <size>] [--heighttype <pixel>] [--height <size>] [--SetDockType true|false] [--SetPartialStrut true|false] [--transparent true|false] [--alpha <value>] [--tint <color>] [--distance <length>] [--distancefrom left|right|top|bottom|none] [--expand true|false] [--padding <size>] DESCRIPTION
trayer is a small program designed to provide system tray similar to these in GNOME / KDE desktop environments for window managers which does not support that function. It is similar to other applications such as peksystray and docker. System tray is a place, where many applications put their icons, so they are always visible. Such icons may present status of an applica- tion and allow user to control the program. trayer's code was extracted from fbpanel application, you can find more about it on its homepage: http://fbpanel.sourceforge.net/. OPTIONS
This programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included below. --help -h Show summary of options and exit. --version -v Show version of program and exit. --edge left|right|top|bottom|none Specifies a screen edge to use. --align left|center|right Specifies an align of the icons. --margin <size> Specifies length of margin (in pixels) --widthtype request|pixel|percent Specifies method of calculating trayer's window width: request Follow application icons' size, so trayer may shrink or expand dynamically. pixel Set a fixed size, given with --width option in pixels. percent Set a fixed size, given with --width option in percentage of a length of screen edge. --width <size> Width of trayer's window. Ignored when --widthtype is set to request. --heighttype request|pixel|percent Specifies method of calculating trayer's window height: request Follow application icons' size, so trayer may shrink or expand dynamically. pixel Set a fixed size, given with --height option in pixels. percent Set a fixed size, given with --height option in percentage of a length of screen edge. --height <size> Height of trayer's window. Ignored when --heighttype is set to request. --SetDockType true|false Identify panel window type as dock. --SetPartialStrut true|false Reserve panel space so that it will not be covered by maximized windows. --transparent true|false Use transparency. --alpha <value> Percentage of transparency (0 - nontransparent, 255 - fully transparent) --tint <color> Color used to tint transparent background. Color is given as a 24-bit C hexadecimal integer, for example: 0xff0000 is red, 0xff8800 is orange and 0x00ff00 is green. --distance <length> Specifies distance between trayer's window and screen edge (in pixels) --distancefrom <edge> Specifies which edge to calculate distance from, see above. --expand true|false Specifies whether trayer may accommodate extra space when there is too much icons. --padding <size> Extra space between icons and trayer window's border. --monitor NUM|STRING Define the monitor on which you like trayer to appear, number of zero to number of monitors minus one, or the string "primary" are valid. The default value is 0. SEE ALSO
fbpanel(1) AUTHORS
Anatoly Asviyan <aanatoly@users.sf.net> - fbpanel Rafal Bisingier <ravbc@man.poznan.pl> Maciej Delmanowski <harnir@users.berlios.de> Grzegorz Nieweglowski <hoppke@dobremiasto.net> Thomas Rydzynski This manual page was written by Tomasz Melcer <liori@interia.pl>. FVWM-Crystal Feb 14, 2005 TRAYER(1)
All times are GMT -4. The time now is 08:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy