Sponsored Content
Full Discussion: Transpose the Row and column
Top Forums UNIX for Beginners Questions & Answers Transpose the Row and column Post 303042214 by Neo on Thursday 19th of December 2019 02:04:41 AM
Old 12-19-2019
Quote:
Originally Posted by ricbha
please help by providing the scripting for this.
We will be happy to help you when you show your own work and try, in earnest, to write your own code to solve your technical problems.

Please show your work to solve this problem and any error messages you might have encountered.

Hint: Try searching the site with your keywords for other answers to this basic question.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Row to column transpose

Can we transpose rows to columns? Fields within row are separated by a comma. (10 Replies)
Discussion started by: videsh77
10 Replies

2. Shell Programming and Scripting

Transpose column to row

Hi i have a file which has values seperated by "," as shown below and I want to transpose for every doc_id in one row. Input: DOC_ID,KEYWORD 105,REGISTROS 105,GEOLOGIA 105,NUCLEOS 105,EXPEDIENTE 105,PROGRAMAS 10025,EXPEDIENTE 10025,LOCALIZACIONES 10025,OFICIOS 10025,PROGRAMAS... (4 Replies)
Discussion started by: juelillo
4 Replies

3. Shell Programming and Scripting

Row to column transpose between same pattern.

Hi All, I have been trying to transpose rows to column in an large file (about 15000 lines) between matching pattern. Searched all posts in this forum, but not able find the solution to my problem. Any help appreciated.!! Input /*------XXXXXX-------*/ owner: XXXX location: XXXX... (3 Replies)
Discussion started by: RobP
3 Replies

4. UNIX for Dummies Questions & Answers

Row to column transpose

Hi there, Below is sample three rows which i need transpose into multiple rows. By keeping first 2 fields static and split them into multiple rows depend following date field. Each into seperate rows. Sample code: ... (6 Replies)
Discussion started by: ganeshd
6 Replies

5. Shell Programming and Scripting

Column to row Transpose

Hi Folks, Iam a kinda newbie to unix shell scripting, the scenario is i have a text file containing the following info Charlie chicago 15 Charlie newyork 26 jonny chicago 14 jonny newyork 15 joe chicago 15 joe newyork 18output should be Name chicago ... (3 Replies)
Discussion started by: tech_frk
3 Replies

6. 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

7. Shell Programming and Scripting

To transpose row into column

Hi All, In shell, I have below data coming from some some text file as below: . 351706 5861.8 0.026 0.012 12.584 0.026 0.012 12.582 0.000 0.000 0.000 Now i need the above data to be transposed as below 351706... (16 Replies)
Discussion started by: Anamica
16 Replies

8. Shell Programming and Scripting

Transpose row to column

I'm using the testawk.awk from the following thread https://www.unix.com/shell-programming-and-scripting/18897-row-column-transpose.htmlI'm getting the following output fieldname1 data1 fieldname2 data2 fieldname3 data3 How can I get like this instead 1 fieldname1 data1 2 fieldname2 data2... (1 Reply)
Discussion started by: makkan
1 Replies

9. Shell Programming and Scripting

Transpose from row to column using timestamp in first column

Gents, Transpose from row to column, taking in consideration the first column, which contends the date. Input file 72918,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009 72918,2356,2357,2358,2359,2360,2361,2362,2363,2364 72918,0,0,0,0,0,0,0,0,0... (12 Replies)
Discussion started by: jiam912
12 Replies

10. Shell Programming and Scripting

How transpose column in a row?

Hello guys, First of all happy holidays and happy new year. I'm new in bioinformatic and also it is my first time that I write in this forum. Therefore, sorry if I make some mistakes. I'm writing to ask your help to fix a problem: I have a file like this: gene1 GO:0016491|GO:0055114... (8 Replies)
Discussion started by: Salvatore_espos
8 Replies
show(1) 						      General Commands Manual							   show(1)

NAME
show - show (list) messages (only available within the message handling system, mh) SYNOPSIS
show [+folder] [msgs] [-draft] [-[no]header] [-help] [-showproc program] [-noshowproc] [options to showproc] OPTIONS
Displays the draft message, or the current message in your +drafts folder, if you have one set up. You cannot give a msgs argument when you use this option. Displays a one-line header before the message. The header consists of the name of the folder and the message number. This is the default behavior. It can be suppressed with the -noheader option. Prints a list of the valid options to this command. Specifies an alternative program to list messages. The default is to use the program defined by the showproc: entry in the file. You can give options to the showproc program at the command line. These are passed directly to showproc by show. (If you specify an option that has a numerical value, leave no space between the argument and the value. See RESTRICTIONS for more information.) If the -noshowproc option is specified, /bin/cat is used instead of showproc. The MH command mhl can be used as a showproc to show messages in a more uniform format. See mhl(1) for more details. If you are going to use the same showproc all the time, it is advisable to specify it in your file. See mh_profile(4) for more details. The defaults for this command are as follows: +folder defaults to the current folder msgs defaults to the current message -header DESCRIPTION
Use show to display the contents of the current message. You can specify alternative messages or folders by using the +folder or msgs argu- ments. If a folder is given, it becomes the current folder. The last message shown becomes the current message. You can specify a number of messages or a range of messages using the msgs argument. If you specify more than one message, show prompts for a <RETURN> prior to listing each message. Typically, the messages are listed exactly as they are, with no reformatting. A program named by the showproc component in the file is invoked to do the listing, and any options not recognized by show are passed along to that program. The default program is more(1). By default, the show command use the more program to list each message, a page at a time. When the end of the page is reached, it waits for a <RETURN> or a space. If you press <RETURN>, show prints the next line. If you press the space bar, it prints the next screen of data. At the end of the message, show automatically returns you to the system prompt. Press q to quit before the end of the message. If the profile entry Unseen-Sequence: is present and non-empty, then show will remove each of the messages shown from the sequences named by the profile entry. RESTRICTIONS
The -header option does not work when msgs expands to more than one message. If the showproc is mhl, then this problem can be circumvented by referencing the messagename field in the mhl format file. The command show updates your mail environment before showing the message. Hence show may mark messages as seen before you actually see them. However, this is generally not a problem, unless you are using the unseen messages mechanism, and you interrupt show while it is showing unseen messages. If you use the showproc switch to specify an alternative viewer, leave no space between the options specified with the viewer and their values. For example, if you want to use the more command to scroll through messages 6 through 10 in your inbox folder, and you want to pause every five lines, you would enter the following command, where there is no space between the option n and the value 5: % show +inbox 6-10 -showproc more -n5 If there is space between the option n and the value 5, the command interprets 5 as a message number to view. If your showprocviewer is mhl, then show uses a built-in mhl: it does not actually run the mhl program. Hence, if you define your own show- proc, do not call it mhl since show will not run it. If more(1) is your showproc (which is the default), then avoid running show in the background with only its standard output piped to another process. You should re-direct the diagnostic output of show as well For example, in the following incorrect example, show will go into a tty input state: % show | print & For users of csh, the correct command is: % show |& print & For users of sh, the correct command is: % show 2>&1 | print & PROFILE COMPONENTS
Path: To determine the user's Mail directory Unseen-Sequence: To name sequences denoting unseen messages showproc: Program to show messages EXAMPLES
In the first example, show displays the contents of message 36 in the current folder: % show 36 In the next example, the pr(1) program is used to list the current message: % show -showproc pr FILES
The user profile. SEE ALSO
more(1), mhl(1), next(1), pick(1), prev(1), scan(1) show(1)
All times are GMT -4. The time now is 03:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy