|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
file column length using awk
Post 302688279 by bmk on Saturday 18th of August 2012 01:26:49 PM
08-18-2012
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: manneni prakash
5 Replies
2. Shell Programming and Scripting
Hi guys,
I have tried to find a solution for this problem but couln't. If anyone of you have an Idea do help me.
INPUT_FILE
with three columns shown to be separated by - sign
A5BNK723NVI - 1 - 294
A7QZM0VIT - 251 - 537
A7NU3411V - 245 - 527
I want an output file in which First column... (2 Replies)
Discussion started by: smriti_shridhar
2 Replies
3. UNIX for Dummies Questions & Answers
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies
4. Shell Programming and Scripting
Hi
I use the following code to read the file and to fix the length of the column of the record in the file 'Sample.txt'
ls Samp* | awk '
{ a=$1 }
END{
FS="n"
for(i=1;i<=NR;i++)
{
while( getline < a )
{
f1=$0;
print("Line::",f1);
f2=substr(f1,1,10)
print("Field1::",f2);... (10 Replies)
Discussion started by: meva
10 Replies
5. Shell Programming and Scripting
Hi,
I have a fixed length file where I need to verify the values of 3 different fields, where each field will have a different value.
How can I do that in a single step. (6 Replies)
Discussion started by: naveen_sangam
6 Replies
6. Shell Programming and Scripting
Hi ,
I need to extract data from below mentioned data, having no delimiter and havin no fixed column length.
For example:
Member nbr Ref no date
10000 1000 10202012
200000 2000 11202012
Output:
to update DB with memeber nbr on basis of ref no.
... (6 Replies)
Discussion started by: ns64110
6 Replies
7. Shell Programming and Scripting
Hi..
Just got a problem with awk and cannot figure out whats the issue. I am not really expert in awk so looking for help/opinion from experts
Command is
$ cat abinaryfile | sed -e "s/@@//g;s/@$//" | awk ' begin {} { printf(length($0)); }'
Well its a binary file and I am... (3 Replies)
Discussion started by: iffarrukh
3 Replies
8. Shell Programming and Scripting
Hi,
I have two input files as
File1 :
ABC:client1:project1
XYZ:client2-aa:project2
DEF:client4:proj
File2 :
client1:W-170:xx
client2-aa:WT-04:yy
client4:L-005A:zz
Also, array of valid values can be hardcoded like
Output :
ABC:W:project1
XYZ:WT:project2 (1 Reply)
Discussion started by: aa2601
1 Replies
9. Shell Programming and Scripting
Hi,
I need to split a fixed length file of 160 characters based on value of a column. Example:
ABC 456780001 DGDG SDFSF
BCD 444440002 SSSS TTTTT
ABC 777750003 HHHH UUUUU
THH 888880001 FFFF LLLLLL
HHH 999990002 GGGG OOOOO
I need to split this file on basis of column from... (7 Replies)
Discussion started by: Neelkanth
7 Replies
10. Shell Programming and Scripting
Hi,
I have input file whose first column needs(match.txt) to be matched with the first column of the input file with min & max length as defined in match.txt. But conditions are not matching. Please help on the changes in the code below as for multiple enteries in match.txt complete match.txt will... (3 Replies)
Discussion started by: siramitsharma
3 Replies
LEARN ABOUT OPENSOLARIS
iconv_646
iconv_646(5) Standards, Environments, and Macros iconv_646(5) NAME
iconv_646 - code set conversion tables for ISO 646 DESCRIPTION
The following code set conversions are supported: +-----------------------------------------------------------------------+ | Code Set Conversions Supported | +----------+---------------+--------------+--------+--------------------+ | Code | Symbol |Target Code |Symbol | Target Output | +----------+---------------+--------------+--------+--------------------+ |ISO 646 | 646 |ISO 8859-1 |8859 |US ASCII | +----------+---------------+--------------+--------+--------------------+ |ISO 646de | 646de |ISO 8859-1 |8859 |German | +----------+---------------+--------------+--------+--------------------+ |ISO 646da | 646da |ISO 8859-1 |8859 |Danish | +----------+---------------+--------------+--------+--------------------+ |ISO 646en | 646en |ISO 8859-1 |8859 |English ASCII | +----------+---------------+--------------+--------+--------------------+ |ISO 646es | 646es |ISO 8859-1 |8859 |Spanish | +----------+---------------+--------------+--------+--------------------+ |ISO 646fr | 646fr |ISO 8859-1 |8859 |French | +----------+---------------+--------------+--------+--------------------+ |ISO 646it | 646it |ISO 8859-1 |8859 |Italian | +----------+---------------+--------------+--------+--------------------+ |ISO 646sv | 646sv |ISO 8859-1 |8859 |Swedish | +----------+---------------+--------------+--------+--------------------+ CONVERSIONS
The conversions are performed according to the following tables. All values in the tables are given in octal. ISO 646 (US ASCII) to ISO 8859-1 For the conversion of ISO 646 to ISO 8859-1, all characters in ISO 646 can be mapped unchanged to ISO 8859-1 ISO 646de (GERMAN) to ISO 8859-1 For the conversion of ISO 646de to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646de | ISO 8859-1 | ISO 646de | ISO 8859-1 | |100 | 247 |173 |344 | |133 | 304 |174 |366 | |134 | 326 |175 |374 | |135 | 334 |176 |337 | +---------------+----------------+----------------+---------------+ ISO 646da (DANISH) to ISO 8859-1 For the conversion of ISO 646da to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646da | ISO 8859-1 | ISO 646da | ISO 8859-1 | |133 | 306 |173 |346 | |134 | 330 |174 |370 | |135 | 305 |175 |345 | +---------------+----------------+----------------+---------------+ ISO 646en (ENGLISH ASCII) to ISO 8859-1 For the conversion of ISO 646en to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------+ | Conversions|Performed | | ISO 646en | ISO 8859-1 | |043 |243 | +-----------------------------+-----------------------------+ ISO 646es (SPANISH) to ISO 8859-1 For the conversion of ISO 646es to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646es | ISO 8859-1 | ISO 646es | ISO 8859-1 | |100 | 247 |173 |260 | |133 | 241 |174 |361 | |134 | 321 |175 |347 | |135 | 277 | | | +---------------+----------------+----------------+---------------+ ISO 646fr (FRENCH) to ISO 8859-1 For the conversion of ISO 646fr to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646fr | ISO 8859-1 | ISO 646fr | ISO 8859-1 | |043 | 243 |173 |351 | |100 | 340 |174 |371 | |133 | 260 |175 |350 | |134 | 347 |176 |250 | |135 | 247 | | | +---------------+----------------+----------------+---------------+ ISO 646it (ITALIAN) to ISO 8859-1 For the conversion of ISO 646it to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646it | ISO 8859-1 | ISO 646it | ISO 8859-1 | |043 | 243 |140 |371 | |100 | 247 |173 |340 | |133 | 260 |174 |362 | |134 | 347 |175 |350 | |135 | 351 |176 |354 | +---------------+----------------+----------------+---------------+ ISO 646sv (SWEDISH) to ISO 8859-1 For the conversion of ISO 646sv to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646sv | ISO 8859-1 | ISO 646sv | ISO 8859-1 | |100 | 311 |140 |351 | |133 | 304 |173 |344 | |134 | 326 |174 |366 | |135 | 305 |175 |345 | |136 | 334 |176 |374 | +---------------+----------------+----------------+---------------+ FILES
/usr/lib/iconv/*.so conversion modules /usr/lib/iconv/*.t conversion tables /usr/lib/iconv/iconv_data list of conversions supported by conversion tables SEE ALSO
iconv(1), iconv(3C), iconv(5) SunOS 5.10 28 Apr 1997 iconv_646(5)