awk script to (un)/concatenate fields in file Post: 302406448

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want. The vendor wants me to submit three fields to them. Field 1 is the studentid field,...

2. Shell Programming and Scripting

Get 4 character each from 2 different fields concatenate and add as a new field

Hi, I have a huge text file. It looks like abcde bangalo country 12345 lastfield i want to get first 3 characters from field1 and first 3 characters from field 2 and insert the result as a new field. example the result should be: abcde bangalo abcban country 12345 lastfield Please...

3. Shell Programming and Scripting

Need awk script to compare 2 fields in fixed length file.

Need a script that manipulates a fixed length file that will compare 2 fields in that file and if they are equal write that line to a new file. i.e. If fields 87-93 = fields 119-125, then write the entire line to a new file. Do this for every line in the file. After we get only the fields...

4. UNIX for Advanced & Expert Users

Concatenate lines in file shell script

Hi colleagues, I have a file in this format. "/cccc/pppp/dddd/ggg/prueba.txt". ERROR" THE error bbbbbbbbbb finish rows. "/kkkk/mmmm/hhhh/jjj/ejemplo.txt". ERROR This is other error rows.I need my file in this format. "/cccc/pppp/dddd/ggg/prueba.txt". ERROR" THE error bbbbbbbbbb finish rows....

5. Shell Programming and Scripting

Comparing two csv file fields using awk script

Hi All, I want to remove the rows from File1.csv by comparing the columns/fields in the File2.csv. I only need the records whose first column is same and the second column is different for the same record in both files.Here is an example on what I need. File1.csv: RAJAK|ACTIVE|1...

6. Shell Programming and Scripting

How to get fields and get output with awk or shell script.?

7. Shell Programming and Scripting

awk script to parse case with information in two fields of file

The below awk parser works for most data inputs, but I am having trouble with the last one. The problem is in the below rules steps 1 and 2 come from $2 (NC_000013.10:g.20763686_20763687delinsA) and steps 3 and 4 come from $1 (NM_004004.5:c.34_35delGGinsT). Parse Rules: The header is...

8. Shell Programming and Scripting

XML Fields comparison using awk script

Hello All, I have many zipped XMLs (example file name in tgz formate - file_rec.trx.2016-01-23.000123.exc.85sesdzd45wsds5299c8f2994f7.tgz) looks following and I need to verify two numbers, they are RecordNumber and EnrolData (only sequence number, NOT hole). for all the records, both should be...

9. Shell Programming and Scripting

awk script concatenate two column and perform mutiplication

Need your help in solving this puzzle. Any kind of help will be appreciated and link for any documents to read and learn and to deal with such scenarios would be helpful Concatenate column1 and column2 of file 1. Then check for the concatenated value in Column1 of File2. If found extract the...

10. UNIX for Beginners Questions & Answers

Concatenate a string and number and compare that with another string in awk script

I have below code inside my awk script if ( $0 ~ /SVC IN:/ ) { svc_in=substr( $0,23 , 3); if (msg_start == 1 && msg_end == 0) { msg_arr=$0; } } else if ( $0 ~ /^SVC OUT:/ ) { svc_out=substr( $0, 9, 3); if (msg_start == 1 && msg_end == 0) ...

LEARN ABOUT DEBIAN

concat

concat(3tcl)						       Tcl Built-In Commands						      concat(3tcl)

__________________________________________________________________________________________________________________________________________________

NAME

       concat - Join lists together

SYNOPSIS

       concat ?arg arg ...?
_________________________________________________________________

DESCRIPTION

       This  command  joins  each of its arguments together with spaces after trimming leading and trailing white-space from each of them.  If all
       the arguments are lists, this has the same effect as concatenating them into a single list.  It permits any number of arguments; if no args
       are supplied, the result is an empty string.

EXAMPLES

       Although concat will concatenate lists, flattening them in the process (so giving the following interactive session):

	      % concat a b {c d e} {f {g h}}
	      a b c d e f {g h}

       it will also concatenate things that are not lists, as can be seen from this session:

	      % concat " a b {c   " d "  e} f"
	      a b {c d e} f

       Note also that the concatenation does not remove spaces from the middle of values, as can be seen here:

	      % concat "a   b	c" { d e f }
	      a   b   c d e f

       (i.e., there are three spaces between each of the a, the b and the c).

SEE ALSO

       append(3tcl), eval(3tcl), join(3tcl)

KEYWORDS

       concatenate, join, lists

Tcl									8.3							      concat(3tcl)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

Discussion started by: axo959

2. Shell Programming and Scripting

Get 4 character each from 2 different fields concatenate and add as a new field

Discussion started by: ajithshankar@ho

3. Shell Programming and Scripting

Need awk script to compare 2 fields in fixed length file.

Discussion started by: Muga801

4. UNIX for Advanced & Expert Users

Concatenate lines in file shell script

Discussion started by: systemoper