Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Conditional sorting on fixed length flat file
Top Forums UNIX for Dummies Questions & Answers Conditional sorting on fixed length flat file Post 302292317 by ShawnMilo on Friday 27th of February 2009 01:01:12 PM
Old 02-27-2009
This should help you out quite a bit:

How to ask questions the smart way

After you've read that, let us know what languages you know, such as Perl, sed, awk, Python, Bash shell scripting, Korn shell scripting, or any other relevant tool you're familiar with. Then show what you've tried so far.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

2. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

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

3. Shell Programming and Scripting

Sorting the records in the Flat file

Hi all, I am using this command "sort -d -u -k1 IMSTEST.74E -o tmp.txt" to the records in the flat. Can any tell me how to sort the file except first line in the file For ex: i/p First line: DXYZ Second line : jumy third : cmhk fourth : andy Output should... (5 Replies)
Discussion started by: sudhir_barker
5 Replies

4. Shell Programming and Scripting

Exporting a flat fixed length file (Urgent)

Hi All, So far, I've been extracting data from db2 tables and exporting the file as a tab delimited file into a UNIX server using the following command: export to /.../.../.../.../.../SM_RAW_DATA.dat of del modified by coldel| nochardel select a.accno, a.CUR_BL_AM, ... (1 Reply)
Discussion started by: jj2485
1 Replies

5. Shell Programming and Scripting

how to read fixed length flat file....

Hi Gurus, Thanks in advance... I am new to writing shell scripting and help me out reading a flat file with fixed length. I have a fixed length flat file with storename(lenth 6) , emailaddress(lenth 15), location(10). There is NO delimiters in that file. Like the following str00001.txt... (2 Replies)
Discussion started by: willywilly
2 Replies

6. Shell Programming and Scripting

reading fixed length flat file and calling java code using shell scripting

I am new to shell scripting and I have to to the following I have a flat file with storename(lenth 20) , emailaddress(lenth 40), location(15). There is NO delimiters in that file. Like the following str00001.txt StoreName emailaddress location... (3 Replies)
Discussion started by: willywilly
3 Replies

7. UNIX for Advanced & Expert Users

Insert Delimiter at fixed locations in a flat file

Hi Can somebody help me with solution for this PLEASE? I have a flat file and need to insert delimiters at fixed positions in all the lines so that I can easily convert into EXCEL with columns defined as per their width. For Example Here is the file { kkjhdhal sdfewss sdtereetyw... (7 Replies)
Discussion started by: jd_mca
7 Replies

8. Shell Programming and Scripting

Fixed length flat file extraction

Hii ,I am new to Unix ,i have a flat file which is (fixed length) sitting in unix,Which is holding the data for a table.I want to extract one column(length7-10) on the basis of another column(length13-15) and want only one single row Example: Below is the sample of flat file. 1111 AAAA 100 ... (4 Replies)
Discussion started by: laxmi1166
4 Replies

9. Shell Programming and Scripting

Flat file-make field length equal to header length

Hello Everyone, I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table. Input Data- ------ ------------------------ ---- ----------------- WFI001 Xxxxxx Control Work Item A Number of Records ------ ------------------------... (5 Replies)
Discussion started by: sonali.s.more
5 Replies

10. UNIX for Dummies Questions & Answers

Length of a fixed width file

I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers. awk '{print length;exit}' <File_name> The above code gives me length 50. wc -L <File_name> The above code gives me length 53. Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies

LEARN ABOUT OPENSOLARIS

iconv_dhn

iconv_dhn(5)						Standards, Environments, and Macros					      iconv_dhn(5)

NAME

       iconv_dhn - code set conversion tables for DHN (Dom Handlowy Nauki)

DESCRIPTION

       The following code set conversions are supported:

       +--------------------------------------------------------------------+
       |		  Code Set Conversions Supported		    |
       +--------------+--------+--------------+--------+--------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |   Target Output    |
       +--------------+--------+--------------+--------+--------------------+
       |DHN	      |dhn     |ISO 8859-2    |iso2    | ISO Latin 2	    |
       +--------------+--------+--------------+--------+--------------------+
       |DHN	      |dhn     |MS 1250       |win2    | Windows Latin 2    |
       +--------------+--------+--------------+--------+--------------------+
       |DHN	      |dhn     |MS 852	      |dos2    | MS-DOS Latin 2     |
       +--------------+--------+--------------+--------+--------------------+
       |DHN	      |dhn     |Mazovia       |maz     | Mazovia	    |
       +--------------+--------+--------------+--------+--------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   DHN to ISO 8859-2
       For the conversion of DHN to ISO 8859-2, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |  ISO 8859-2	|     DHN	 |  ISO 8859-2	 |
       |24-177	       | 40		|222		 |40		 |
       |200	       | 241		|223		 |364		 |
       |201	       | 306		|224		 |366		 |
       |202	       | 312		|225-230	 |40		 |
       |203	       | 243		|231		 |326		 |
       |204	       | 321		|232		 |334		 |
       |205	       | 323		|233-237	 |40		 |
       |206	       | 246		|240		 |341		 |
       |207	       | 254		|241		 |355		 |
       |210	       | 257		|242		 |363		 |
       |211	       | 261		|243		 |372		 |
       |212	       | 346		|244-340	 |40		 |
       |213	       | 352		|341		 |337		 |
       |214	       | 263		|342-365	 |40		 |
       |215	       | 361		|366		 |367		 |
       |216	       | 363		|367		 |40		 |
       |217	       | 266		|370		 |260		 |
       |220	       | 274		|371-376	 |40		 |
       |221	       | 277		|		 |		 |
       +---------------+----------------+----------------+---------------+

   DHN to MS 1250
       For the conversion of DHN to MS 1250, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |    MS 1250	|     DHN	 |   MS 1250	 |
       |200	       | 245		|233-237	 |40		 |
       |201	       | 306		|240		 |341		 |
       |202	       | 312		|241		 |355		 |
       |203	       | 243		|242		 |363		 |
       |204	       | 321		|243		 |372		 |
       |205	       | 323		|244-251	 |40		 |
       |206	       | 214		|252		 |254		 |
       |207	       | 217		|253-255	 |40		 |
       |210	       | 257		|256		 |253		 |
       |211	       | 271		|257		 |273		 |
       |212	       | 346		|260-340	 |40		 |
       |213	       | 352		|341		 |337		 |
       |214	       | 263		|342-345	 |40		 |
       |215	       | 361		|346		 |265		 |
       |216	       | 363		|347-360	 |40		 |
       |217	       | 234		|361		 |261		 |
       |220	       | 237		|362-365	 |40		 |
       |221	       | 277		|366		 |367		 |
       |222	       | 40		|367		 |40		 |
       |223	       | 364		|370		 |260		 |
       |224	       | 366		|371		 |40		 |
       |225-230        | 40		|372		 |267		 |
       |231	       | 326		|373-376	 |40		 |
       |232	       | 334		|		 |		 |
       +---------------+----------------+----------------+---------------+

   DHN to MS 852
       For the conversion of DHN to MS 852, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |    MS 852	|     DHN	 |    MS 852	 |
       |200	       | 244		|212		 |206		 |
       |201	       | 217		|213		 |251		 |
       |202	       | 250		|214		 |210		 |
       |203	       | 235		|215		 |344		 |
       |204	       | 343		|216		 |242		 |
       |205	       | 340		|217		 |230		 |
       |206	       | 227		|220		 |253		 |
       |207	       | 215		|221		 |276		 |
       |210	       | 275		|222-375	 |40		 |
       |211	       | 245		|		 |		 |
       +---------------+----------------+----------------+---------------+

   DHN to Mazovia
       For the conversion of DHN to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |    Mazovia	|     DHN	 |   Mazovia	 |
       |200	       | 217		|212		 |215		 |
       |201	       | 225		|213		 |221		 |
       |202	       | 220		|214		 |222		 |
       |203	       | 234		|215		 |244		 |
       |204	       | 245		|216		 |242		 |
       |205	       | 243		|217		 |236		 |
       |206	       | 230		|220		 |246		 |
       |207	       | 240		|221		 |247		 |
       |210	       | 241		|222-247	 |40		 |
       |211	       | 206		|		 |		 |
       +---------------+----------------+----------------+---------------+

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							    18 Apr 1997 						      iconv_dhn(5)
All times are GMT -4. The time now is 02:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy