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

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help with ksh/awk/sed script, random # of fields

Hello all, I'm working on an attendance callout script for a school district. I need to change our current layout for the vendor. Currently the data is in the form of: studentid,period,building, Heres a sample of some made up records: 500,1,30, 500,2,30, 500,3,30, 500,6,30,...

2. UNIX for Dummies Questions & Answers

count number of fields not using SED or AWK

hi forums i need help with a little problem i am having. i need to count the number of fields that are in a saved variable so i can use that number to make a different function work properly. is there a way of doing this without using SED/AWK? anything would be greatly appreciated

3. Shell Programming and Scripting

awk,cut fields by change field format

Hi Everyone, # cat 1.txt 1321631,77770132976455,19,20091001011859,20091001011907 1321631,77770132976455,19,20091001011859,20091001011907 1321631,77770132976455,19,20091001011859,20091001011907 # cat 1.txt | awk -F, '{OFS=",";print $1,$3,$4,$5}' 1321631,19,20091001011859,20091001011907...

4. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Hi experts, I need to print the first field first then last two fields should come next and then i need to print rest of the fields. Input : a1,abc,jsd,fhf,fkk,b1,b2 a2,acb,dfg,ghj,b3,c4 a3,djf,wdjg,fkg,dff,ggk,d4,d5 Expected output: a1,b1,b2,abc,jsd,fhf,fkk...

5. Shell Programming and Scripting

Using awk to rearrange fields

Hi, I am required to arrange columns of a file i.e make the 15th column into the 1st column. I am doing awk 'begin {fs=ofs=","} {print $15,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14}' ad.data>ad.csv the problem is that column 15 gets to column 1 but it is not comma separated with the...

6. Shell Programming and Scripting

awk - compare 1st 15 fields of record with 20 fields

I'm trying to compare 2 files for differences in a selct number of fields. When differnces are found it will write the whole record of the second file including appending '|C' out to a delta file. Each record will have 20 fields, but only want to do comparison of 1st 15 fields. The 1st field of...

7. Shell Programming and Scripting

awk sort based on difference of fields and print all fields

Hi I have a file as below <field1> <field2> <field3> ... <field_num1> <field_num2> Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields. I tried this and it doesn't sort on the difference field .. Appreciate your help. cat...

8. Shell Programming and Scripting

Pattern Match and Rearrange the Fields in UNIX

For an Output like below Input : <Subject A="I" B="1039502" C="2015-06-30" D="010101010101"> Output : <Subject D="010101010101" B="1039502" C="2015-06-30" A="I"> I have been using something like below but not getting the desired output : awk -F ' ' '/Subject/ BEGIN{OFS=" ";}...

9. Shell Programming and Scripting

Rearrange fields of delimited text file

I want to rearrange the fields of delimited text file after sorting first line (only): input file: a_13;a_2;a_1;a_10 13;2;1;10 the result should be: a_1;a_2;a_10;a_13 1;2;10;13 any help would be appreciated andy

10. UNIX for Beginners Questions & Answers

Is there a UNIX command that can compare fields of files with differing number of fields?

Hi, Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account. $ head -500 x.txt y.txt ==> x.txt <== TEST01 APP_USER_PROFILE USER03 APP_USER_PROFILE TEST02 APP_USER_EXP_PROFILE TEST04 APP_USER_PROFILE USER01 ...

LEARN ABOUT BSD

mkmanifest

MKMANIFEST(1)						      General Commands Manual						     MKMANIFEST(1)

NAME

       mkmanifest - create a shell script to restore Unix filenames

SYNOPSIS

       mkmanifest [ files ]

DESCRIPTION

       Mkmanifest creates a shell script that will aid in the restoration of Unix filenames that got clobbered by the MSDOS filename restrictions.
       MSDOS filenames are restricted to 8 character names, 3 character extensions, upper case only, no device names, and no illegal characters.

       The mkmanifest program is compatible with the methods used in pcomm, arc, and mtools to change perfectly good Unix  filenames  to  fit  the
       MSDOS restrictions.

EXAMPLE

       I want to copy the following Unix files to a MSDOS diskette (using the mcopy command).

	    very_long_name
	    2.many.dots
	    illegal:
	    good.c
	    prn.dev
	    Capital

       Mcopy will convert the names to:

	    very_lon
	    2xmany.dot
	    illegalx
	    good.c
	    xprn.dev
	    capital

       The command:

       mkmanifest very_long_name 2.many.dots illegal: good.c prn.dev Capital > manifest

       would produce the following:

	    mv very_lon very_long_name
	    mv 2xmany.dot 2.many.dots
	    mv illegalx illegal:
	    mv xprn.dev prn.dev
	    mv capital Capital

       Notice that "good.c" did not require any conversion, so it did not appear in the output.

       Suppose	I've  copied  these files from the diskette to another Unix system, and I now want the files back to their original names.  If the
       file "manifest" (the output captured above) was sent along with those files, it could be used to convert the filenames.

SEE ALSO

       arc(1), pcomm(1), mtools(1)

								       local							     MKMANIFEST(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help with ksh/awk/sed script, random # of fields

Discussion started by: axo959

2. UNIX for Dummies Questions & Answers

count number of fields not using SED or AWK

Discussion started by: strasner

3. Shell Programming and Scripting

awk,cut fields by change field format

Discussion started by: jimmy_y

4. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Discussion started by: 100bees