Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Partial Column extraction/Process/Repasting changed Columns back to Source file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Partial Column extraction/Process/Repasting changed Columns back to Source file
# 1  
Old 04-03-2009
Question Partial Column extraction/Process/Repasting changed Columns back to Source file
I have the following requirement.

file1.txt (this could contain 5 million rows)
ABC 1234 XYZ .... (3000 bytes)
QRD 4612 GHT .... (3000 bytes)

I need to create
file2.txt
1234
4612

I have a EAI process to change file2.txt into
file3.txt
4555
3743

Then I would have to use file3.txt and repaste this value into file1.txt
changed file1.txt
ABC 4555 XYZ .... (3000 bytes)
QRD 3743 GHT .... (3000 bytes)

Any help is appreciated.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Keep only columns in first two rows based on partial header pattern.

I have this code below that only prints out certain columns from the first two rows (doesn't affect rows 3 and beyond). How can I do the same on a partial header pattern “G_TP” instead of having to know specific column numbers (e.g. 374-479)? I've tried many other commands within this pipe with no... (4 Replies)
Discussion started by: aachave1
4 Replies

2. UNIX for Dummies Questions & Answers

Search for partial matches in particular column

I have a list a b c d I want to search this list to have partial matches in column 2 in data file col1 col2 col3 1 a/e aa 2 b/e aa 3 z/y aa 4 t/u bb 5 d/f aa 6 a/t aa and extract the relevant rows with header (4 Replies)
Discussion started by: jianp83
4 Replies

3. Shell Programming and Scripting

Need columns changed to rows

I have some data in a file that looks like the following: reqs : 447342 max : 3.455 avg : 0.020 reqs : 68936 max : 24.078 avg : 0.202 reqs : 1093 max : 3:52.713 avg : 3.358 reqs : 0 max : 0.000 total : 0.000 (5 Replies)
Discussion started by: x96riley3
5 Replies

4. Shell Programming and Scripting

Bring back a file changed with sed

Hello everbody I changed one of my important files with a false sed statement by mistake now I lost my file and I hope I could bring it back what I did was: sed '/^..//' a > myfile myfile should have been another file like b ot something I know I also forgot to place an 's' to the... (5 Replies)
Discussion started by: miriammiriam
5 Replies

5. Shell Programming and Scripting

Partial average of a column with awk

Hello, Let's assume I have 100 files FILE_${m} (0<m<101). Each of them contains 100 lines and 10 columns. I'd like to get in a file called "result" the average value of column 3, ONLY between lines 11 and 17, in order to plot that average as a function of the parameter m. So far I can compute... (6 Replies)
Discussion started by: DMini
6 Replies

6. Shell Programming and Scripting

extracting columns using pattern file from source file

Hi experts,Please help me for the below requirement. i have a source file.(lets say contains 50 columns). I am extarcting five columns from the source file by using pattern file. for example input file:--------a,b,c,d,"a,g","v b",s,koutputfile=======a,"a,g","v b",s,kThanks in advance subhendu (2 Replies)
Discussion started by: subhendu81
2 Replies

7. Shell Programming and Scripting

fileutility to extract columns from source file

Hi experts,Please help me for the below requirement.i have a source file.(lets say contains 50 columns). I am extarcting five columns from the source file by using pattern file.for exampleinput file:--------a,b,c,d,"a,g","v b",s,koutputfile=======a,"a,g","v b",s,kThanks in advancesubhendu (1 Reply)
Discussion started by: subhendu81
1 Replies

8. Shell Programming and Scripting

use of format file to extract columns from a source file

hi experts lets say my format file is B B ========= column no,name,type,length 1,ee,N,12 3,hj,N.4 4,kl,N,5 source file ======== d e f g h i 5 8 9 7 6 5 1 3 4 5 6 6 (2 Replies)
Discussion started by: subhendu81
2 Replies

9. UNIX for Dummies Questions & Answers

Searching partial columns and returning maximum as output

Hello, I am just getting starting with awk and wondering if anyone could help with the following problem. I have a large file of data, 50,000 rows x 6 columns. I would like to search in blocks of 500 rows for a maximum value in a specific column and compile an output file that prints the... (0 Replies)
Discussion started by: xb_analysis
0 Replies

10. Shell Programming and Scripting

How to check Null values in a file column by column if columns are Not NULLs

Hi All, I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
Discussion started by: Mandab
7 Replies
Login or Register to Ask a Question

LEARN ABOUT SUNOS

cmp

cmp(1)								   User Commands							    cmp(1)

NAME

       cmp - compare two files

SYNOPSIS

       cmp [-l] [-s] file1 file2 [skip1] [skip2]

DESCRIPTION

       The cmp utility compares two files. cmp will write no output if the files are the same. Under default options, if they differ, it writes to
       standard output the byte and line numbers at which the first difference occurred. Bytes and lines are numbered beginning  with  1.  If  one
       file  is  an  initial  subsequence  of the other, that fact is noted. skip1 and skip2 are initial byte offsets into file1 and file2 respec-
       tively, and may be either octal or decimal; a leading 0 denotes octal.

OPTIONS

       The following options are supported:

       -l	Write the byte number (decimal) and the differing bytes (octal) for each difference.

       -s	Write nothing for differing files; return exit statuses only.

OPERANDS

       The following operands are supported:

       file1	A path name of the first file to be compared. If file1 is -, the standard input will be used.

       file2	A path name of the second file to be compared. If file2 is -, the standard input will be used.

       If both file1 and file2 refer to standard input or refer to the same FIFO special, block  special  or  character  special  file,  an  error
       results.

USAGE

       See largefile(5) for the description of the behavior of cmp when encountering files greater than or equal to 2 Gbyte (2**31 bytes).

EXAMPLES

       Example 1: Comparing files byte for byte

       The following example:

       example% cmp file1 file2 0 1024

       does a byte for byte comparison of file1 and file2. It skips the first 1024 bytes in file2 before starting the comparison.

ENVIRONMENT VARIABLES

       See  environ(5)	for  descriptions of the following environment variables that affect the execution of cmp: LANG, LC_ALL, LC_CTYPE, LC_MES-
       SAGES, and NLSPATH.

EXIT STATUS

       The following error values are returned:

       0	The files are identical.

       1	The files are different; this includes the case where one file is identical to the first part of the other.

       >1	An error occurred.

ATTRIBUTES

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

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |CSI			     |enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       comm(1), diff(1), attributes(5), environ(5), largefile(5), standards(5)

SunOS 5.10							    1 Feb 1995								    cmp(1)