Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sort on fixed length files
Top Forums Shell Programming and Scripting sort on fixed length files Post 302094246 by sach_in on Thursday 26th of October 2006 09:11:40 AM
Old 10-26-2006
Thanks igor for the solution., but only works if the file doesn't have "|" in the data.

since its fixed lenght file, there is no guarantee that i will only get data without "|" in the data.

sorry my bad, i didn't give the correct example., just modification,

51|341|5153100@|0047363758741
51|341|51533010@0|47363758741
515342|515360000020063758742
515349|51537|0|0047363758749

output should be
5153100@|0047363758741
51533010@0|47363758741

Thanks
Sachin.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a fixed length output from a variable length input

Is there a command that sets a variable length? I have a input of a variable length field but my output for that field needs to be set to 32 char. Is there such a command? I am on a sun box running ksh Thanks (2 Replies)
Discussion started by: r1500
2 Replies

2. Shell Programming and Scripting

Awk with fixed length files

Hi Unix Champs, I want to awk on a fixed length file. Instead if the file was a delimited file, then I could have used -F and then could have easily done manipulation on the fields. How do i do the same in case of fixed length file? Thanks in Advance. Regards. (7 Replies)
Discussion started by: c2b2
7 Replies

3. Shell Programming and Scripting

Join two fixed length Files in Unix

Hi, Can we join two fixed length files in Unix using JOIN command? Is there any other command to accomplish the same? Thanks, G.Harikrishnan (6 Replies)
Discussion started by: gharikrishnan
6 Replies

4. Shell Programming and Scripting

Awk - Working with fixed length files

OK I am somewhat new to UNIX programming please see what you can do to help. I have a flat file that is a fixed length file containing different records based on the 1st character of each line. The 1st number at the beginning of the line is the record number, in this case it's record #1. I... (3 Replies)
Discussion started by: ambroze
3 Replies

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

6. Shell Programming and Scripting

Need a sort solution for fixed length file

I have a 1250 byte record that I need to sort in column 10-19 and in column 301. I have tried the sort command, but it looks like it needs delimiters to work. The record can have spaces in a lot of its 1250 columns, but 10-19, and 301 are guaranteed. These columns are numeric too. A sample... (1 Reply)
Discussion started by: mb1201
1 Replies

7. Shell Programming and Scripting

changing a variable length text to a fixed length

Hi, Can anyone help with a effective solution ? I need to change a variable length text field (between 1 - 18 characters) to a fixed length text of 18 characters with the unused portion, at the end, filled with spaces. The text field is actually field 10 of a .csv file however I could cut... (7 Replies)
Discussion started by: dc18
7 Replies

8. Shell Programming and Scripting

Help with extracting words from fixed length files

I am very new to scripting and need to write a script that will extract the account number from a line that begins with HDR. For example, the file is as follows HDR2010072600300405505100726 00300405505 LBJ FREEWAY DALLAS TELEGRAPH ... (9 Replies)
Discussion started by: bds052189
9 Replies

9. Shell Programming and Scripting

Unix sort for fixed length columns and records

I was trying to use the AIX 6.1 sort command to sort fixed-length data records, sorting by specific columns only. It took some time to figure out how to get it to work, so I wanted to share the solution. The sort man page wasn't much help, because it talks about field delimeters (default space... (1 Reply)
Discussion started by: CheeseHead1
1 Replies

10. Shell Programming and Scripting

Convert variable length record to fixed length

Hi Team, I have an issue to split the file which is having special chracter(German Char) using awk command. I have a different length records in a file. I am separating the files based on the length using awk command. The command is working fine if the record is not having any... (7 Replies)
Discussion started by: Anthuvan
7 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 10:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy