Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Suggestion to convert data in rows to data in columns Post 302509299 by kush on Wednesday 30th of March 2011 01:04:56 PM
Old 03-30-2011
Thank u for that quick fedback!! The input file presents itself
"name name' following by thousands figures then space then next "name name" following by figures (lets say one extra long row with spaces which separate "name name 0 2 0 1 2 2 1 .." blocks).
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert two column data into 8 columns

Apologies if this has been covered - I did search but couldn't find what I was looking for. I have a simple X-Y input file. I want to convert it from two columns into 8 columns - 4 pairs of X-Y data. So my input file looks like X1 Y1 X2 Y2 X3 Y3 X4 Y4 X5 Y5 etc And I want it to look... (8 Replies)
Discussion started by: NickC
8 Replies

2. Shell Programming and Scripting

Data in Rows to Columns

Hi, I am a beginner in bash&perl. I have data in form of:- A 1 B 2 C 3 D 4 E 5 I would like your help to find a simple way to change it to :- A B C D E 1 2 3 4 5 Any help would be highly appreciated. (8 Replies)
Discussion started by: umaars
8 Replies

3. Shell Programming and Scripting

Transpose columns to Rows : Big data

Hi, I did read a few posts on the subjects, tried out a few solutions, but did not solve my problem. https://www.unix.com/302121568-post11.html https://www.unix.com/shell-programming-scripting/137953-large-file-columns-into-rows-etc-4.html Please help. Problem very similar to the second link... (15 Replies)
Discussion started by: genehunter
15 Replies

4. UNIX for Dummies Questions & Answers

Convert Rows to Columns Specific Data

I have this data M36 AREA INFORMATION MDN = 0485009346 ESN = H'15fda0b0 TYPE = HLR RESULT = NOK REASON = UNRECOGNIZED MIN COMPLETED AREA INFORMATION MDN = 0498044402 ESN = H'15fdac11 TYPE... (2 Replies)
Discussion started by: krabu
2 Replies

5. Shell Programming and Scripting

Help for a Perl newcomer! Transposing data from columns to rows

I have to create a Perl script which will transpose the data output from my experiment, from columns to rows, in order for me to analyse the data. I am a complete Perl novice so any help would be greatly appreciated. The data as it stands looks like this: Subject Condition Fp1 ... (12 Replies)
Discussion started by: Sarah_W
12 Replies

6. Shell Programming and Scripting

Transpose Data from Columns to rows

Hello. very new to shell scripting and would like to know if anyone could help me. I have data thats being pulled into a txt file and currently have to manually transpose the data which is taking a long time to do. here is what the data looks like. Server1 -- Date -- Other -- value... (7 Replies)
Discussion started by: Mikes88
7 Replies

7. UNIX for Dummies Questions & Answers

Convert nxm Matrix into columns of data

Dear Unixers, I'm having some difficulty in converting an n x m data matrix into a dataset of 3 columns and nxm rows. As an example I want to convert this dataset 2 3 4 5 2 0.0 0.0 0.1 0.1 6 -0.3 2.0 0.0 0.3 7 -0.6 -1.1 0.5 0.3 9 -0.9 -4.1 -0.7 0.5 ... (2 Replies)
Discussion started by: tintin72
2 Replies

8. Shell Programming and Scripting

Convert Column data values to rows

Hi all , I have a file with the below content Header Section employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep Data section ... (1 Reply)
Discussion started by: Hypesslearner
1 Replies

9. Shell Programming and Scripting

Transpose comma delimited data in rows to columns

Hello, I have a bilingual database with the following structure a,b,c=d,e,f The right half is in a Left to right script and the second is in a Right to left script as the examples below show What I need is to separate out the database such that the first word on the left hand matches the first... (4 Replies)
Discussion started by: gimley
4 Replies

10. Shell Programming and Scripting

Extracting data from specific rows and columns from multiple csv files

I have a series of csv files in the following format eg file1 Experiment Name,XYZ_07/28/15, Specimen Name,Specimen_001, Tube Name, Control, Record Date,7/28/2015 14:50, $OP,XYZYZ, GUID,abc, Population,#Events,%Parent All Events,10500, P1,10071,95.9 Early Apoptosis,1113,11.1 Late... (6 Replies)
Discussion started by: pawannoel
6 Replies
df_vxfs(1M)															       df_vxfs(1M)

NAME
df_vxfs: df - report number of free disk blocks on a VxFS file system SYNOPSIS
[special|directory]... DESCRIPTION
prints the number of free blocks and free inodes in VxFS file systems or directories based on the counts kept in the super-blocks. VxFS dynamically allocates inodes from a pool of free blocks. The number of free inodes and blocks reported by is an estimate based on the number of free 8K or larger extents and the current ratio of allocated inodes to allocated blocks. (Extents smaller than 8K may not be usable for all types of allocation, so does not count free blocks in extents smaller than 8K.) Allocating additional blocks may therefore decrease the count of free inodes and vice versa. If the operand to is a special device name, the file system can be an unmounted or mounted file system (for example, If you specify a directoryname, displays information for the file system at that mount point. If neither special nor directory is specified, the free space on all of the mounted file systems is printed. Options recognizes the following options: Report only the number of kilobytes free. Report the number of files free. Report only an actual count of the blocks in the free list (free inodes are not reported). When this option is specified, reports on raw devices. Specify the file system type Report the entire statvfs(2) structure. Report the total number of inodes, the number of free inodes, number of used inodes and the percentage of inodes in use. Report the allocation in kilobytes. Report on local file systems only. Report the file system name. If invoked with no other options this option prints a list of mounted file system types. Print the number of free extents of each size. Free extents are always an integral power of two in length, ranging from a minimum of one block to the maximum extent size supported by the file system. Report the total allocated block figures and the number of free blocks. Report the percentage of blocks used, the number of blocks used and the number of blocks free. This option cannot be used with other options. Echo the completed command line, but performs no other action. The command line is generated by incorporating the user-specified options and other information derived from This option allows the user to verify the command line. There are a number of options that specify output formats, some combinations of which are incompatible. If an incompatible combination is specified, one of the options will override the other(s). Operands recognizes the following operands: directory Name of the mount point from which the VxFS file system is accessed. special Device name, which contains a mounted or unmounted VxFS file system. EXAMPLES
Report the number of free disk blocks for all mounted file systems: Report the number of free extents of each size, for all mounted VxFS file systems: Report the number of free files for all mounted VxFS file systems: Report the total allocated block figures and the number of free blocks, for all mounted file systems: Report the total allocated block figures and the number of free blocks, for the file system mounted as FILES
File-system devices. File-system devices. Static information about the file systems. mounted-file-system table. SEE ALSO
du(1), df(1M), fsck_vxfs(1M), statvfs(2), fs_vxfs(4), mnttab(4). STANDARDS CONFORMANCE
: SVID2, XPG2, XPG3 df_vxfs(1M)
All times are GMT -4. The time now is 11:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy