Sponsored Content
Full Discussion: awk question row into column
Top Forums UNIX for Dummies Questions & Answers awk question row into column Post 302454243 by calitiggr on Friday 17th of September 2010 12:28:52 PM
Old 09-17-2010
I was just lazy with the post...I resolved my issue, although I still don't know what was the root cause.

I think my issue what that I saved the file in csv format in excel. Once I reopened/resaved the file in text edit and ran the script it was ok.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get value of last row and 6 column from awk

I want to get value of last row and 6 column from awk. Below is the format of my file. And RED one is my desired value. Actaully this stats usally update after every 1 hour so i want that every time i run the script i get the latest value. Ending time - 01:00:58 HOURLY CALL ATTEMPTS... (4 Replies)
Discussion started by: wakhan
4 Replies

2. Shell Programming and Scripting

Row to column converter using Awk or grep?

Hello, Can someone please help me on this.:confused: I have a file which has more than 1 million lines (XML file). What I need is: Search for "abcd" in the input file > output the result into a output.txt (colloum1) Search for "efghi" in the input file > output the result in to... (3 Replies)
Discussion started by: Needhelp2
3 Replies

3. UNIX for Dummies Questions & Answers

Adding a column with the row number using awk

Is there anyway to use awk to add a first column to my data that automatically goes from 1 to n , where n is the numbers of my rows?:confused: (4 Replies)
Discussion started by: cosmologist
4 Replies

4. Shell Programming and Scripting

awk: Transpose csv row to column.

Hello, am I new to awk, and I am tryint to: INPUT FILE: "73423555","73423556","73423557","73423558","73423559" OUTPUT FILE: 73423555 73423556 73423557 73423558 73423559 My useless code so far: #!/bin/awk -F ',' BEGIN { i=0; } (8 Replies)
Discussion started by: drbiloukos
8 Replies

5. UNIX for Dummies Questions & Answers

awk: convert column to row in a specific way

Hi all! I have this kind of output: a1|b1|c1|d1|e1 a2|b2|c2 a3|b3|c3|d3 I would like to transpose columns d and e (when they exist) in column c, and under the row where they come from. Then copying the beginning of the row. In order to obtain: a1|b1|c1 a1|b1|d1 a1|b1|e1 a2|b2|c2... (1 Reply)
Discussion started by: lucasvs
1 Replies

6. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

7. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies

8. Shell Programming and Scripting

Transpose column to row - awk

Hi there, I have a small csv file example below: source,cu_001,cu_001_volume,cu_001_mass,cu_002,cu_002_volume,cu_002_mass,cu_003,cu_003_volume,cu_003_mass ja116,1.33,3024000,9374400,1.54,3026200,9375123,1.98,3028000,9385512 I want to transpose columns to rows starting at the second... (3 Replies)
Discussion started by: theflamingmoe
3 Replies

9. Shell Programming and Scripting

awk script row to column

Hi.. I have data : Report testing1 20180419 08:00 Report testing2 20180419 07:35 Report testing 20180419 08:01 Source = data1 Report testing4 20180419 08:05 Source = data1 Report testing5 20180419 08:10 Source = data2 Report testing6 20180419 08:01 Report testing7 20180419 08:19... (4 Replies)
Discussion started by: buncit8
4 Replies

10. UNIX for Beginners Questions & Answers

Script to do column to row in awk

Hi , Can anyone help me suggesting - how to do the below trick with awk Input 120 130 140 210 310 410 645 729 800 Output 120 130 140 (6 Replies)
Discussion started by: Indra2011
6 Replies
GHI(1)							      General Commands Manual							    GHI(1)

NAME
ghi - command-line interface to the GitHub Issues API SYNOPSIS
ghi command [arguments] [options] DESCRIPTION
This manual page documents briefly the ghi command. ghi is a command-line interface to the GitHub Issues API. It can be used to access all of GitHub's documented Issues API (v2) functionality from the command line: open, close and manipulate issues. If no command is given, the default action is list. If a number is given instead, the default action is show. COMMANDS
list [ -s open|closed|all ] Show open, closed or all issues (choose with -s, see below). Default is open. show number Show issue number. This command can be invoked also as ghi <number>. open [ number ], o [ number ] Create a new issue, and launch $EDITOR. If number is given, reopens that issue. open -m message, o -m message Create a new issue with message content (optionally, use for new lines; first line will be the issue title). close number, c number Closes issue number. edit number, e number Edit issue number with $EDITOR. label add|remove label number Add or remove label to/from issue number. You can use al or rl instead of, respectively, label add and label remove. search term, s term Search for term. comment number, m number Create a comment for issue number (with $EDITOR). OPTIONS
-h, --help Show summary of options. -v, --verbose Show issue details (only for show, list and search commands). Default is false. -V, --version Show program's version number and exit. -s STATE, --state=STATE Specify state (only for list and search (except "all") commands). Choices are: open (o), closed (c), all (a). Default is open. -r REPO, --repo=REPO, --repository=REPO Specify a repository. The format: "user/repo" or just "repo" (latter will get the user from the global git config). -w, --web, --webbrowser Show issue(s) GitHub page in web browser (only for list and show commands). Default is false. AUTHOR
github-cli was written by Sander Smits <jhmsmits@gmail.com>. This manual page was written by David Paleino <dapal@debian.org>, for the Debian project (and may be used by others). April 13, 2010 GHI(1)
All times are GMT -4. The time now is 08:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy