Print column details from fixed width file using awk command
hi,
i have a fixed width file with multiple columns and need to print data using awk command.
i use:
for a delimiter file.
but now i have a fixed width file like below:
Fixed width column wise lengths: 7,3,3,1,2,11,8,3,3,1,3,1
Could u pls help me to fetch data for rows with col5 as 'BH' value
I am new to awk coomands.
Appreciate ur help in advance
Moderator's Comments:
Please post in the proper forum
Last edited by Scrutinizer; 12-26-2014 at 11:33 AM..
Reason: CODE tags
Hi, I have two input files.
File1:
ID Name Place
1-234~name1~Newyork
1-34~name2~Boston
1-2345~name3~Hungary
File1 is a variable length file where each column is seperated by delimitter "~".
File2:
ID Country
1-34<<11 SPACES>>USA<<7 spaces>>
1-234<<10 SPACES>>UK<<8... (5 Replies)
Col1 Col2 Col3 Col4
12 Completed 08 0830
12 In Progress 09 0829
11 For F U 07 0828
Considering the file above, how could i replace the third column the most efficient way? The actual file size is almost 1G. I am... (10 Replies)
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Hi,
How to output the duplicate record to another file. We say the record is duplicate based on a column whose position is from 2 and its length is 11 characters.
The file is a fixed width file.
ex of Record:
DTYU12333567opert tjhi kkklTRG9012
The data in bold is the key on which... (1 Reply)
Hi,
I have a fixed width text file without any header row. One of the columns contains a date in YYYYMMDD format.
If the original file contains 3 dates, I want my shell script to split the file into 3 small files with data for each date.
I am a newbie and need help doing this. (14 Replies)
I have a fixed with file with header & trailer length having the same length of the detail record file.
The details record length of this file is 24, for Header and Trailer the records will be padded with spaces to match the record length of the file
Currently I am adding 3 spaces in header... (14 Replies)
All,
I used to use following command to replace specific location in a fixed width file.
Recently looks like my command stopped working as intended. We are on AIX unix.
awk 'function repl(s,f,t,v)
{ return substr(s,1,f-1) sprintf("%-*s", t-f+1, v) substr(s,t+1) }
NR<=10 {... (3 Replies)
Hi All,
I am trying to select the rows in a fixed width file based on values in the columns.
I want to select only the rows if column position 3-4 has the value AB
I am using cut command to get the column values. Is it possible to check if cut -c3-4 = AB is true then select only that... (2 Replies)
Discussion started by: ashok.k
2 Replies
LEARN ABOUT SUSE
gappletviewer
GAPPLETVIEWER(1) GNU GAPPLETVIEWER(1)NAME
gappletviewer - Load and runs an applet
SYNOPSIS
appletviewer [OPTION]... URL...
appletviewer [OPTION]... -code CODE
appletviewer [OPTION]... -plugin INPUT,OUTPUT
DESCRIPTION
The appletviewer tool loads and runs an applet.
Use the first form to test applets specified by tag. The URL should resolve to an HTML document from which the appletviewer will extract
applet tags. The APPLET, EMBED and OBJECT tags are supported. If a given document contains multiple applet tags, all the applets will be
loaded, with each applet appearing in its own window. Likewise, when multiple URLs are specified, each applet tag instance is given its
own window. If a given document contains no recognized tags the appletviewer does nothing.
appletviewer http://www.gnu.org/software/classpath/
Use the second form to test an applet in development. This form allows applet tag attributes to be supplied on the command line. Only one
applet may be specified using the -code option. The -code option overrides the URL form -- any URLs specified will be ignored.
appletviewer -code Test.class -param datafile,data.txt
gcjwebplugin uses the third form to communicate with the appletviewer through named pipes.
OPTIONS
URL OPTIONS
-debug
This option is not yet implemented but is provided for compatibility.
-encoding CHARSET
Use this option to specify an alternate character encoding for the specified HTML page.
APPLET TAG OPTIONS
-code CODE
Use the -code option to specify the value of the applet tag CODE attribute.
-codebase CODEBASE
Use the -codebase option to specify the value of the applet tag CODEBASE attribute.
-archive ARCHIVE
Use the -archive option to specify the value of the applet tag ARCHIVE attribute.
-width WIDTH
Use the -width option to specify the value of the applet tag WIDTH attribute.
-height HEIGHT
Use the -height option to specify the value of the applet tag HEIGHT attribute.
-param NAME,VALUE
Use the -param option to specify values for the NAME and VALUE attributes of an applet PARAM tag.
PLUGIN OPTION
-plugin INPUT,OUTPUT
gcjwebplugin uses the -plugin option to specify the named pipe the appletviewer should use for receiving commands (INPUT) and the one
it should use for sending commands to gcjwebplugin (OUTPUT).
DEBUGGING OPTION
-verbose
Use the -verbose option to have the appletviewer print debugging messages.
STANDARD OPTIONS
-help
Use the -help option to have the appletviewer print a usage message, then exit.
-version
Use the -version option to have the appletviewer print its version, then exit.
-JOPTION
Use the -J option to pass OPTION to the virtual machine that will run the appletviewer. Unlike other options, there must not be a
space between the -J and OPTION.
BUGS SEE ALSO AUTHOR 0.98 2010-07-05 GAPPLETVIEWER(1)