Setting the number of fields using awk Post: 302998897

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

Number of fields handled by awk

Hi Gurus, Have a file seperated by "~" and no of fields is 104. When i try to run awk, it erros out. awk: record `B~A31~T24_STF~~~2009...' has too many fields Any idea how can i extract a specific filed with this many fields in a row. Kindly help

4. Shell Programming and Scripting

How to (n)awk lines of CSV with certain number of fields?

I have a CSV file with a variable number of fields per record. How do I print lines of a certain number of fields only? Several permutations of the following (including the use of escape characters) have failed to retrieve the line I'm after (1,2,3,4)... $ cat myfile 1,2,3,4 1,2,3 $ # Print...

5. Shell Programming and Scripting

awk split lines without knowing the number of fields a-priori

I want to use awk to split fields and put them into a file but I don't know the number of fields for example, in the following line Ports: 22/filtered/tcp//ssh///, 53/open/tcp//tcpwrapped///, 111/filtered/tcp//rpcbind///, 543/filtered/tcp//klogin///, 544/filtered/tcp//kshell///,...

6. Shell Programming and Scripting

[ksh88 and awk] Number of fields with a value.

Hi, With: # VALUES="one~two~~~" # echo $VALUES | awk 'BEGIN {FS="~"} {print NF}' 5 I can determine the number of fields. How to determine the number of fields with a value ? In this case 2. Thanks in advance, ejdv

7. Shell Programming and Scripting

awk processing of variable number of fields data file

Hy! I need to post-process some data files which have variable (and periodic) number of fields. For example, I need to square (data -> data*data) the folowing data file: -5.34281E-28 -3.69822E-29 8.19128E-29 9.55444E-29 8.16494E-29 6.23125E-29 4.42106E-29 2.94592E-29 1.84841E-29 ...

8. UNIX for Dummies Questions & Answers

Make all records with the same number of fields (awk)

Hi, input: AA|BB|CC DD|EE FF what I am trying to get: AA|BB|CC DD|EE| FF|| I tried to create first an UDF for printing repeats, but I think I have an issue with my END section or my array: function repeat(str, n, rep, i) { for(i=1 ;i<n;i++) rep=rep str return rep } ...

9. Shell Programming and Scripting

Awk: Combine multiple lines based on number of fields

If a file has following kind of data, comma delimited 1,2,3,4 1 1 1,2,3,4 1,2 2 2,3,4 My required output must have only 4 columns with comma delimited 1,2,3,4 111,2,3,4 1,222,3,4 I have tried many awk command using ORS="" but couldnt progress

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 OSF1

mrd

mrd(1)							      General Commands Manual							    mrd(1)

NAME

       mrd - mtools utility to remove a DOS directory

SYNOPSIS

       mrd msdosdirectory [msdosdirectories...]

DESCRIPTION

       The  mrd command removes a directory from a DOS file system.  If the directory is not empty, an error occurs.  Unlike DOS conventions, this
       command allows multiple arguments.

       DOS subdirectory names that contain the '/' or '' separator are supported.  If you use the '' separator or wildcards,	you  must  enclose
       file names in quotes to protect them from the shell.

       The mcd command can be used to establish the device and the current working directory (relative to DOS), otherwise the default is A:.

EXIT STATUS

       The following exit values are returned: Success.  Failure.

ENVIRONMENT VARIABLES

       The following environment variables affect the execution of mrd: If set, this variable names the file that contains the name of the current
       mtools working directory as established by the mcd command.  If this variable is not set, the file $HOME/.mcwd is used.

FILES

       Contains the name of the current mtools working directory as established by the mcd command.  If this file  does  not  exist,  the  default
       mtools working directory is A:.  Executable file

SEE ALSO

       Commands:  mcd(1), mmd(1), mtools(1)

																	    mrd(1)

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. UNIX for Dummies Questions & Answers

count number of fields not using SED or AWK

Discussion started by: strasner

3. Shell Programming and Scripting

Number of fields handled by awk

Discussion started by: srivat79

4. Shell Programming and Scripting

How to (n)awk lines of CSV with certain number of fields?

Discussion started by: cs03dmj

5. Shell Programming and Scripting

awk split lines without knowing the number of fields a-priori

Discussion started by: esolvepolito

6. Shell Programming and Scripting

[ksh88 and awk] Number of fields with a value.

Discussion started by: ejdv

7. Shell Programming and Scripting

awk processing of variable number of fields data file

Discussion started by: radudownload