Sponsored Content
Top Forums Shell Programming and Scripting Convert single column into multiple rows Post 302895078 by linuxpenguin on Friday 28th of March 2014 12:07:39 PM
Old 03-28-2014
Would this work

Code:
sort  a.txt | awk -F'=' 'BEGIN {l=null} {if($1 != l ) {l=$1; printf("\n%s ",$1)} else { printf("%s ",$2)}}'

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to convert a single column into several rows and columns?

I have a program which gives me the output as a single column with hundreds of rows like: 213 314 324 324 123 I want to be able to create a new file from this file which allows me to set the number of rows and columns in the new file, i.e. for this example, if I specify 3 rows and 2... (5 Replies)
Discussion started by: ashton_smith
5 Replies

2. Shell Programming and Scripting

Converting Single Column into Multiple rows

i have single column which is starting with same string(many number of rows) i have to convert each into a single row.how can i do that? laknar std mes 23 55 laknar isd phone no address amount 99 I have to convert above like below. laknar|std|mes|23|55 laknar|isd|phone... (3 Replies)
Discussion started by: laknar
3 Replies

3. UNIX for Advanced & Expert Users

convert rows to single row

Hi I want to convert multiple rows ro single row ,I have tried with below one but I am not getting what I am expecting.Please any idea a.txt conn1=stg conn2=dev path=\xxx\a1.txt fre=a conn1=stg conn2=dev path=\xxx\a2.txt freq=a awk '/a/{ORS=" "}{print}END{print "\n"}'... (5 Replies)
Discussion started by: akil
5 Replies

4. Shell Programming and Scripting

Single column into multiple rows

Hi all, I need to convert this file having just one column into two column file current file: a 15 b 21 c 34 d 48 e 10 wanted: a 15 b 21 c 34 (15 Replies)
Discussion started by: prachiagra
15 Replies

5. Shell Programming and Scripting

Split single rows to multiple rows ..

Hi pls help me out to short out this problem rm PAB113_011.out rm: PAB113_011.out: override protection 644 (yes/no)? n If i give y it remove the file. But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
Discussion started by: sri_aue
7 Replies

6. Shell Programming and Scripting

How to merge multiple rows into single row if first column matches ?

Hi, Can anyone suggest quick way to get desired output? Sample input file content: A 12 9 A -0.3 2.3 B 1.0 -4 C 34 1000 C -111 900 C 99 0.09 Output required: A 12 9 -0.3 2.3 B 1.0 -4 C 34 1000 -111 900 99 0.09 Thanks (3 Replies)
Discussion started by: cbm_000
3 Replies

7. UNIX for Dummies Questions & Answers

[SOLVED] splitting a single column(with spaces) into multiple rows

Hi All, My requisite is to split a single column of phonemes seperated by spaces into multiple rows. my input file is: a dh u th a qn ch A v U r k my o/p should be like: adhu a dh u (3 Replies)
Discussion started by: girlofgenuine
3 Replies

8. Shell Programming and Scripting

Transpose multiple rows (with a mix of space and enter) to a single column

How to change the uploaded weekly file data to the following format? New Well_Id,Old Well_Id,District,Thana,Date,Data,R.L,WellType,Lati.,Longi. BAG001,PT006,BARGUNA,AMTALI,1/2/1978,1.81,2.29,Piezometer,220825,901430 BAG001,PT006,BARGUNA,AMTALI,1/9/1978,1.87,2.29,Piezometer,220825,901430... (3 Replies)
Discussion started by: sara.nowreen
3 Replies

9. Shell Programming and Scripting

Converting Single Column into Multiple rows, but with strings to specific tab column

Dear fellows, I need your help. I'm trying to write a script to convert a single column into multiple rows. But it need to recognize the beginning of the string and set it to its specific Column number. Each Line (loop) begins with digit (RANGE). At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies

10. Shell Programming and Scripting

Converting Single Column into Multiple rows

Hi .. anyone can you help me ? i need to convert text below into multiple columns interface; GigabitEthernet0/0/0/0 description; TRUNK_PE-D2-JT2-VPN_Gi0/0/0/0_TO_ME4-A-JKT-JT_4/1/1_1G mtu 9212 negotiation auto interface; GigabitEthernet0/0/0/0.11 description; tes encapsulation;... (1 Reply)
Discussion started by: mad3linux
1 Replies
scandir(3C)															       scandir(3C)

NAME
scandir(), alphasort() - scan a directory SYNOPSIS
DESCRIPTION
reads the directory dirname and builds an array of pointers to directory entries using (see malloc(3C)). It returns the number of entries in the array and a pointer to the array through namelist. The select parameter is a pointer to a user-supplied subroutine which is called by to select which entries are to be included in the array. The select routine is passed a pointer to a directory entry and should return a non-zero value if the directory entry is to be included in the array. If select is null, then all the directory entries will be included. The compar parameter is a pointer to a user-supplied subroutine which is passed to qsort(3C) to sort the completed array. If this pointer is null, the array is not sorted. is a routine which can be used for the compar parameter to sort the array alphabetically. EXTERNAL INFLUENCES
Locale The category determines the collation ordering used by The category determines the interpretation of bytes in the file name portion of directory entries as single- and/or multi-byte characters by the function. Results are undefined if the locales specified by the and categories use different code sets. International Code Set Support Single- and multi-byte character code sets are supported for RETURN VALUE
If successful, returns the number of directory entries selected, and through the namelist parameter returns a pointer to the array. returns -1, if the directory cannot be opened for reading or cannot allocate enough memory to hold all the data structures. APPLICATION USAGE
uses to allocate memory for the array associated with the namelist pointer. If the return value of is greater than or equal to zero(0), memory allocated for the namelist pointer needs to be freed by the application using (see malloc(3C)) by first freeing each pointer in the array followed by the array itself. EXAMPLES
The example program below scans the directory. It does not exclude any entries since select is NULL. The contents of are sorted by It prints out how many entries are in and the sorted entries of the directory. The memory used by is returned using #include <sys/types.h> #include <stdio.h> #include <dirent.h> extern int scandir(); extern int alphasort(); main() { int num_entries, i; struct dirent **namelist, **list; if ((num_entries = scandir("/tmp", &namelist, NULL, alphasort)) < 0) { fprintf(stderr, "Unexpected error "); exit(1); } printf("Number of entries is %d ", num_entries); if (num_entries) { printf("Entries are:"); for (i=0, list=namelist; i<num_entries; i++) { printf(" %s", (*list)->d_name); free(*list); list++; } } free(namelist); printf(" "); exit(0); } WARNINGS
For 32-bit applications, the d_ino field of the struct returned by or may overflow for filesystems that use 64-bit values. In this case the most-significant bytes will be truncated without generating an error and d_ino values may not be unique. SEE ALSO
directory(3C), malloc(3C), qsort(3C), string(3C), dirent(5), thread_safety(5). scandir(3C)
All times are GMT -4. The time now is 01:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy