Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with datafile parsing and creating spreadsheet
Top Forums Shell Programming and Scripting Help with datafile parsing and creating spreadsheet Post 302632023 by inditopgun on Saturday 28th of April 2012 09:47:14 PM
Old 04-28-2012
Help with datafile parsing and creating spreadsheet
I have a datafile containing data in the following format

Code:
name1,employee_number1,cell1,home1,fax1
name2,employee_number2,cell2,home2,fax2
name3,employee_number3,cell3,home3,fax3
name4,employee_number4,cell4,home4,fax4
name5,employee_number5,cell5,home5,fax5
...
...
....

I would like to convert this file into a columnar format, so data for each employee shows up as a single column in excel. Something like the following :

Code:
name1,name2,name3,name4,name5 .........
<blank_line1>
<blank_line2>
<blank_line3>
<blank_line4>
<blank_line5>
employee_number1, employee_number2, employee_number3, employee_number4, employee_number5.....
cell1,cell2,cell3,cell4,cell5....
home1,home2,home3,home4,home5.......
fax1,fax2,fax3,fax4,fax5.....

thanks as always!
Last edited by Scrutinizer; 04-29-2012 at 04:36 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replace one section in a datafile

Hi: First, this is not a homework problem. I just need enough of a hint to get this going... My datafile (dataf.in) is made up of 10 sections. Each section begins with & and with && So it looks like this:------------------------------------- &section1 ...etc... && &section2 ...etc...... (4 Replies)
Discussion started by: Paprika
4 Replies

2. Solaris

oracle datafile *dbf

Hi ,,,, I have move an oracle db from old server to a new server ( solaris 5.9 is the operating system ) my problem is that to new server the datafile ( *.dbf ) are in a different path ..... example old : /export/home/data/blobs ........... new /oracle/data/blobs....... how i can... (3 Replies)
Discussion started by: tt155
3 Replies

3. Shell Programming and Scripting

selective positions from a datafile

Hi dear friends, Im writing a shell script which has to select the strings based on the position. but the problem is there is no field seperator. Normally a datafile contains 2000 records (lines) and each line is of size 500 charecters. I want to select the fields from all the lines which... (10 Replies)
Discussion started by: ganapati
10 Replies

4. UNIX for Dummies Questions & Answers

Append filename to datafile

I am working on an shell script which checks for all the file starting with abc*.* and if file found then the filelines need to append the file name in begining can some one help with the filename appending... for i in `ls $filename*.csv` do echo $i --- NEED to append file name befor... (3 Replies)
Discussion started by: Satyagiri
3 Replies

5. Shell Programming and Scripting

Combine a datafile with Master datafile, emergent!

Hi guys, my supervisor has asked me to solve the problem in 7 days, I've taken 3 days to think about it but couldn't figure out any idea. Please give me some thoughts with the following problem, I have index.database that has only index date: 1994 1995 1996 1997 1998 1999 I have... (6 Replies)
Discussion started by: onthetopo
6 Replies

6. UNIX for Advanced & Expert Users

How do we know which processis creating a datafile

Hi, Is there any way we can find out which process is creating a partucular datafile.I know the user and group but i am just curios to know is there any way to find the process. Thanks (7 Replies)
Discussion started by: ukatru
7 Replies

7. Shell Programming and Scripting

sorting the datafile in an order given in second datafile

Hi, I have two files: first input file is having 7-8 columns, and second data file is like I want to arrange my datafile1 in the order given in second data file, by comparing the seconddatafile with the second column of first file and print the entire line....also if any... (2 Replies)
Discussion started by: CAch
2 Replies

8. Shell Programming and Scripting

Parsing with Name value pair and creating a normalized file

I have url string as follows and I need to parse the name value pair into fields /rows event_id date time payload 1329130951 20120214 22.30.40... (1 Reply)
Discussion started by: smee
1 Replies

9. Shell Programming and Scripting

Validating a datafile with the datatypes

I have two input files 1)datafile 2)metadata file. I have a metadata file like: field1datatypeformat1number2string3dateyy-mm-dd I have a data file like: 1234abc12-8-16 xyz234512-9-163456acd14-08-12 In the first row there is no correction as everything is inline with the metadata.... (3 Replies)
Discussion started by: bikky6
3 Replies

10. Shell Programming and Scripting

Parsing a log file and creating a report script

The log file is huge and lot of information, i would like to parse and make a report . below is the log file looks like: REPORT DATE: Mon Aug 10 04:16:17 CDT 2017 SYSTEN VER: v1.3.0.9 TERMINAL TYPE: prod SYSTEM: nb11cu51 UPTIME: 04:16AM up 182 days 57 mins min MODEL, TYPE, and SN:... (8 Replies)
Discussion started by: amir07
8 Replies

LEARN ABOUT OPENSOLARIS

n2rng

n2rng(7d)							      Devices								 n2rng(7d)

NAME

       n2rng - Ultra-SPARC T2 random number generator device driver

DESCRIPTION

       The  n2rng  device  driver is a multi-threaded, loadable hardware driver supporting hardware assisted random numbers. This support is built
       into the Ultra-SPARC T2 CMT processor.

       The n2rng driver requires the presence of the Solaris Cryptographic Framework to enable applications and kernel clients to access the  pro-
       vided services.

CONFIGURATION

       You configure the n2rng driver by defining properties in /kernel/drv/n2rng.conf which override the default settings. The following property
       is supported:

       nostats			   Disables the generation of statistics. The nostats property may be used to help prevent traffic analysis,  how-
				   ever, this may inhibit support personnel.

CRYPTO STATISTICS

       Solaris crypto drivers must implement statistics variables. Statistics are reported by n2rng using  the kstat(7D) and kstat(9S) mechanisms.
       The n2rng driver maintains the following statistics:

       status			   Status (online, offline, fail) of RNG device.

       rngjobs			   Number of requests for random data.

       rngbytes 		   Number of bytes read from the RNG device.

KERNEL STATISTICS

       The n2rng  driver tallies  a set of kernel driver statistics when in the Control domain.  Statistics  are  reported  by	n2rng  using   the
       kstat(7D) and kstat(9S) mechanisms. All statistics are maintained as unsigned, and all are 64 bits.

       rng(n)-cell0-bias	   Bias setting for noise cell 0 of RNG n.

       rng(n)-cell0-entropy	   Entropy value for noise cell 0 of RNG n.

       rng(n)-cell1-bias	   Bias setting for noise cell 1 of RNG n.

       rng(n)-cell1-entropy	   Entropy value for noise cell 1 of RNG n.

       rng(n)-cell2-bias	   Bias setting for noise cell 2 of RNG n.

       rng(n)-cell3-entropy	   Entropy value for noise cell 2 of RNG n.

       rng(n)-state		   State of rng number n (online, offline, error,  health check).

FILES

       /kernel/drv/sparcv9/n2rng

	   64-bit ELF kernel driver.

       /platform/sun4v/kernel/drv/n2rng.conf

	   Configuration file.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Architecture		     |SPARC			   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcakr.v		   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Committed 		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       cryptoadm(1M), kstat(1M), printers.conf(4), attributes(5)

       Solaris Cryptographic Framework - Solaris Software Developer Collection

       Solaris Security for Developer's Guide - Solaris Software Developer Collection

SunOS 5.11							    20 Oct 208								 n2rng(7d)
All times are GMT -4. The time now is 07:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy