Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: splitting a column into rows
Top Forums UNIX for Dummies Questions & Answers splitting a column into rows Post 302128404 by Shell_Life on Tuesday 24th of July 2007 03:25:45 PM
Old 07-24-2007
Quote:
By the way, I'm aware that some people may be frustrated with me as I hav eposted a numbber of times on the same project. Please understand, this my very first foray into programming and, for whatever it's worth, I have learned a shitload about unix and I'm getting much more independent at it. But I'm not ready to take the training wheels off just yet. Simple or annotated, explained scripts are welcome!
I have also helped you a while back.

Your requests start with a small and simple specification and then it grows
to become a large project.

Keep in mind the following:

1) We are all volunteers here.

2) We are here to help and we are glad to help.

3) Unix is an operating system for information systems professionals.
It is not non-professional user friendly.

4) We can help people resolve an specific issue that does not require
many lines of code and specially many hours/days of thinking.

Per your description, you have a large and complex project.

It will be very hard to find a volunteer to devote time and effort
to complete your project.

What I suggest to you is to hire a programmer in your city to analyze,
plan and develop your project.

Spindoctor, think how much time you have put into this project
and it is still far away from being finished.

If you had hired a programmer from the beginning you would already
have a finished product.

Sometimes, it does not pay to try fix our own cars.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting file based on number of rows

Hi, I'm, new to shell scripting, I have a requirement where I have to split an incoming file into separate files each containing a maximum of 3 million rows. For e.g: if my incoming file say In.txt has 8 mn rows then I need to create 3 files, in which two will 3 mn rows and one will contain 2... (2 Replies)
Discussion started by: wahi80
2 Replies

2. Linux

Splitting a Text File by Rows

Hello, Please help me. I have hundreds of text files composed of several rows of information and I need to separate each row into a new text file. I was trying to figure out how to split the text file into different text files, based on each row of text in the original text file. Here is an... (2 Replies)
Discussion started by: dvdrevilla
2 Replies

3. Shell Programming and Scripting

Replicating rows by splitting column in text file

Hi, I have flat file with following format Col1, Col2, Col3, Col4 --------------------------------- r1_c1, r1_c2, r1_c3, abc | def | efg r2_c1, r2_c2, r2_c3, abcwdw | dweweef | efg | ijk r3_c1, r3_c2, r3_c3, abaac ........... The first three columns contain only one entry per... (3 Replies)
Discussion started by: nick2011
3 Replies

4. Shell Programming and Scripting

awk command to print only selected rows in a particular column specified by column name

Dear All, I have a data file input.csv like below. (Only five column shown here for example.) Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 3,2,4,5,6 5,3,5,5,6 From this I want the below output Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies

5. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
1 Replies

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

7. UNIX for Dummies Questions & Answers

[Solved] Deleting all rows where the first column equals the second column

Hi, I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks! Input: 1 1 ABC DEF 2 2 IJK LMN 1 2 ZYX OPW Output: 1 2 ZYX OPW (2 Replies)
Discussion started by: evelibertine
2 Replies

8. Shell Programming and Scripting

Need help in splitting the string to diff rows

Hi, I have file with values as below 1~ab~456~ac:bd:de:ef~yyyy-mm-dd 2~cd~458~af:fg:ty:er:ty:uj:io:~yyyy-mm-dd I want the o/p as for frist row 1~ab~456~ac~yyyy-mm-dd 1~ab~456~bd~yyyy-mm-dd 1~ab~456~de~yyyy-mm-dd 1~ab~456~ef~yyyy-mm-dd and for the second row 2~cd~458~af~yyyy-mm-dd... (4 Replies)
Discussion started by: rithushri
4 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

Splitting delimited string into rows

Hi, I have a requirement that has 50-60 million records that we need to split a delimited string (Delimeter is newline) into rows. Source Date: SerialID UnidID GENRE 100 A11 AAAchar(10)BBB 200 B11 CCCchar(10)DDD(10)ZZZZ Field 'GENRE' is a string with new line as delimeter and not sure... (5 Replies)
Discussion started by: techmoris
5 Replies

LEARN ABOUT V7

projdel

projdel(1M)						  System Administration Commands					       projdel(1M)

NAME

       projdel - delete a project from the system

SYNOPSIS

       projdel [-f filename]  project

DESCRIPTION

       The projdel utility deletes a project from the system and makes the appropriate changes to the system file.

OPTIONS

       The following options are supported:

       -f filename     Specify the project file to modify. If no filename is specified, the system project file, /etc/project, is modified.

OPERANDS

       The following operands are supported:

       project	       The name of the project to be deleted.

EXIT STATUS

       The following exit values are returned:

       0	Successful completion.

       2	The command syntax was invalid. A usage message for projdel is displayed.

       3	An invalid argument was provided to an option.

       4	The projid given with the -p option is already in use.

       5	The project files contain an error. See project(4).

       6	The project to be modified, group, user, or resource does not exist.

       9	The project is already in use.

       10	Cannot update the /etc/project file.

FILES

       /etc/project	       System project file

ATTRIBUTES

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

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWesu			   |
       +-----------------------------+-----------------------------+
       |Interface stabilty	     | See below.		   |
       +-----------------------------+-----------------------------+

       Invocation is evolving. Human readable output is unstable.

SEE ALSO

       projects(1),  groupadd(1M),  groupdel(1M),  groupmod(1M),  grpck(1M), logins(1M), projadd(1M), projmod(1M), useradd(1M), userdel(1M), user-
       mod(1M), project(4), attributes(5)

DIAGNOSTICS

       In case of an error, projdel prints an error message and exits with a non-zero status.

NOTES

       projdel deletes a project definition only on the local system. If a network name service such as NIS or LDAP is being  used  to	supplement
       the local /etc/project file with additional entries, projdel cannot change information supplied by the network name service.

SunOS 5.10							    4 May 2004							       projdel(1M)
All times are GMT -4. The time now is 01:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy