Sponsored Content
Top Forums Shell Programming and Scripting Help with datafile parsing and creating spreadsheet Post 302632249 by yifangt on Sunday 29th of April 2012 04:28:31 PM
Old 04-29-2012
Re: transpose the matrix

Then this is not a story to transpose the matrix and more complicated as the course number for the students may be different. And your output wants to combine every two original cols tagged with the course name.
Code:
TEMP, STUDENT1 A,something,Morething
TEMP, STUDENT1 B,anything,Morestuff
TEMP, STUDENT1 C,goodthing,Morebla
TEMP, STUDENT1 D,goodthing,Morebla2
TEMP, STUDENT2 A,something,Morething
TEMP, STUDENT2 B,anything,Morestuff
TEMP, STUDENT2 D,thing2,Morebla2

It seems to me you transfer the normalised table to an irregular one. Right?
Code:
      STUDENT1                              STUDENT2
A:something   A:Morething              A:something   A:Morething
B:anything    B:Morestuff              B:anything    B:Morestuff
C:goodthing   C:Morebla                D:thing2      D:Morebla2
D:goodthing2  D:Morebla2

Not a good way for your next processing, if you have. Probably you need think over what you really want.

Last edited by yifangt; 04-29-2012 at 05:39 PM.. Reason: Prune to make it better.
 

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
MAKEACTIVE(8)						      System Manager's Manual						     MAKEACTIVE(8)

NAME
makeactive - tool to recover Usenet active file. SYNOPSIS
makeactive [ -m ] [ -o ] DESCRIPTION
Makeactive invokes find(1) to get a list of all directories in the news spool tree, /var/spool/news. It discards directories named lost+found as well as those that have a period in them. It scans all other directories for all-numeric filenames and determines the high- est and lowest number. The program's output is a set of active(5) file lines. Because there is no way to know if a group is moderated or disabled, the fourth field of all entries will be y. Also, mid-level directories that aren't newsgroups will also created as newsgroups with no entries (for example, there is a ``comp.sources.unix'' group, but no ``comp.sources''). OPTIONS
-m If the ``-m'' flag is given, then makeactive will attempt to adjust the highest and lowest article numbers wherever possible. If articles are found in a newsgroup, the numbers will reflect what what was found. If no articles are found in a newsgroup, the high number from the old file will be kept, and the low number will be set to one more then the high number. This flag may only be used if the ``-o'' flag is used. -o If the ``-o'' flag is used, makeactive will read an existing active file for the list of group names and just renumber all groups. It will preserve the fourth field of the active file if one is present. This is analogous to the ctlinnd(8) ``renumber'' command, except that innd(8) should throttled or not running. Do not use this flag with output redirected to the standard active file! EXIT STATUS
Makeactive exits with non-zero status if any problems occurred. EXAMPLES
A typical way to use the program is with the following /bin/sh commands: ctlinnd throttle "Rebuilding active file" TEMP=${TMPDIR-/var/spool/news/in.coming/tmp}/act$$ if [ -f /var/lib/news/active ] ; then if makeactive -o >${TEMP} ; then mv ${TEMP} /var/lib/news/active fi else if makeactive >${TEMP} ; then # Edit to restore moderated # and aliased groups. ... mv ${TEMP} /var/lib/news/active fi fi ctlinnd reload active "New active file" ctlinnd go '' HISTORY
Written by Rich $alz <rsalz@uunet.uu.net> for InterNetNews. This is revision 1.3, dated 1996/10/29. SEE ALSO
active(5), ctlinnd(8), dbz(3), filechan(8), history(5), innd(8), newsfeeds(5), makehistory(8), newsrequeue(8). MAKEACTIVE(8)
All times are GMT -4. The time now is 08:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy