Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Creating new file with new record length
Top Forums UNIX for Dummies Questions & Answers Creating new file with new record length Post 302217714 by mrjunsy on Wednesday 23rd of July 2008 11:02:10 AM
Old 07-23-2008
updating data in a file automatically
Thanks guys! it worked!
I have followup, I need to update the file by putting a 12byte data on each line (from column 305 through 317) and output it to a file with fix line length of 350 (as the previous post solution). I am doing this manually and i wonder if it can be automated using the awk programming.
Thanks a lot !!! you guys rock!
 

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

Pivot variable record length file and change delimiter

Hi experts. I got a file (500mb max) and need to pivot it (loading into ORCL) and change BLANK delimiter to PIPE |. Sometimes there are multipel BLANKS (as a particular value may be BLANK, or simply two BLANKS instead of one BLANK). thanks for your input! Cheers, Layout... (3 Replies)
Discussion started by: thomasr
3 Replies

3. UNIX for Dummies Questions & Answers

Creating a file in variable length format

Hi all, Does anyone know a technique for creating a download file in variable length format? I have looked around but haven't found any resources on this (or, maybe I'm not sure what to Google for :) ) Thanks in advance! (2 Replies)
Discussion started by: Sarahb29
2 Replies

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

5. Shell Programming and Scripting

search and replace fixed length record file

Hi I need to be search a file of fixed length records and when I hit a particular record that match a search string, substitute a known position field In the example file below FHEAD000000000120090806143011 THEAD0000000002Y0000000012 P00000000000000001234 TTAIL0000000003... (0 Replies)
Discussion started by: nedkelly007
0 Replies

6. Shell Programming and Scripting

Make variable length record a fixed length

Very, very new to unix scripting and have a unique situation. I have a file of records that contain 3 records types: (H)eader Records (D)etail Records (T)railer Records The Detail records are 82 bytes in length which is perfect. The Header and Trailer records sometimes are 82 bytes in... (3 Replies)
Discussion started by: jclanc8
3 Replies

7. Shell Programming and Scripting

sort file specifying record length

I've been searching high and low for this...but, maybe I'm just missing something. I have a file to be sorted that, unfortunately, contains binary data at the end of the line. As you may guess, this binary data may contain a newline character, which messes up the sort. I think I could resolve this... (5 Replies)
Discussion started by: jcagle
5 Replies

8. Shell Programming and Scripting

Add substring in a file containing fixed length record.

I am new to awk and writing a script using awk. I have file containing fixed length records, I wish to extract 2 substring(each substring is padded with zeros on left e.g 000000003623) and add each substring respectively for every record in the file to get total sum of respective substring for all... (5 Replies)
Discussion started by: Devesh5683
5 Replies

9. Shell Programming and Scripting

Creating repeating record in between file through script

apprecieate your help to resove this. My source file looke like 1001 000 HEADER 1001 001 RAJESH 1001 002 100 1001 002 200 1001 002 500 1001 006 FOOTER 1002 000 HEADER 1002 001 RAMESH 1002 002 100 1002 002 200 1002 002 500 1002 006 FOOTER my... (8 Replies)
Discussion started by: Ganesh L
8 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 SUNOS

iconv_8859-5

iconv_8859-5(5) 					Standards, Environments, and Macros					   iconv_8859-5(5)

NAME

       iconv_8859-5 - code set conversion tables for ISO 8859-5 (Cyrillic)

DESCRIPTION

       The following code set conversions are supported:

       +-------------------------------------------------------------------------+
       |		     Code Set Conversions Supported			 |
       +--------------+--------+--------------+--------+-------------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |      Target Output	 |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |KOI8-R	      |koi8    | KOI8-R 		 |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |PC Cyrillic   |alt     | Alternative PC Cyrillic |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |MS 1251       |win5    | Windows Cyrillic	 |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |Mac Cyrillic  |mac     | Macintosh Cyrillic	 |
       +--------------+--------+--------------+--------+-------------------------+

CONVERSIONS

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

   ISO 8859-5 to KOI8-R
       For the conversion of ISO 8859-5 to KOI8-R, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-5   |    KOI8-R	|  ISO 8859-5	 |    KOI8-R	 |
       |24	       | 4		|320		 |301		 |
       |241	       | 263		|321		 |302		 |
       |242	       | 261		|322		 |327		 |
       |243	       | 262		|323		 |307		 |
       |244	       | 264		|324		 |304		 |
       |245	       | 265		|325		 |305		 |
       |246	       | 266		|327		 |332		 |
       |247	       | 267		|330		 |311		 |
       |250	       | 270		|331		 |312		 |
       |251	       | 271		|332		 |313		 |
       |252	       | 272		|333		 |314		 |
       |253	       | 273		|334		 |315		 |
       |254	       | 274		|335		 |316		 |
       |256	       | 276		|336		 |317		 |
       |257	       | 277		|337		 |320		 |
       |260	       | 341		|340		 |322		 |
       |261	       | 342		|341		 |323		 |
       |262	       | 367		|342		 |324		 |
       |263	       | 347		|343		 |325		 |
       |264	       | 344		|344		 |306		 |
       |265	       | 345		|345		 |310		 |
       |266	       | 366		|346		 |303		 |
       |267	       | 372		|347		 |336		 |
       |270	       | 351		|350		 |333		 |
       |271	       | 352		|351		 |335		 |
       |272	       | 353		|352		 |337		 |
       |273	       | 354		|353		 |331		 |
       |274	       | 355		|354		 |330		 |
       |275	       | 356		|355		 |334		 |
       |276	       | 357		|356		 |300		 |
       |277	       | 360		|357		 |321		 |
       |300	       | 362		|360		 |260		 |
       |301	       | 363		|361		 |243		 |
       |302	       | 364		|362		 |241		 |
       |303	       | 365		|363		 |242		 |
       |304	       | 346		|364		 |244		 |
       |305	       | 350		|365		 |245		 |
       |306	       | 343		|366		 |246		 |
       |307	       | 376		|367		 |247		 |
       |310	       | 373		|370		 |250		 |
       |311	       | 375		|371		 |251		 |
       |312	       | 377		|372		 |252		 |
       |313	       | 371		|373		 |253		 |
       |314	       | 370		|374		 |254		 |
       |315	       | 374		|375		 |255		 |
       |316	       | 340		|376		 |256		 |
       |317	       | 361		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-5 to PC Cyrillic
       For the conversion of ISO 8859-5 to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-5   |  PC Cyrillic	|  ISO 8859-5	 | PC Cyrillic	 |
       |24	       | 4		|307		 |227		 |
       |200-240        | 40		|310		 |230		 |
       |241	       | 360		|311		 |231		 |
       |242-254        | 40		|312		 |232		 |
       |255	       | 260		|313		 |233		 |
       |256-257        | 40		|314		 |234		 |
       |260	       | 200		|315		 |235		 |
       |261	       | 201		|316		 |236		 |
       |262	       | 202		|317		 |237		 |
       |263	       | 203		|320		 |240		 |
       |264	       | 204		|321		 |241		 |
       |265	       | 205		|322		 |242		 |
       |266	       | 206		|323		 |243		 |
       |267	       | 207		|324		 |244		 |
       |270	       | 210		|325		 |245		 |
       |271	       | 211		|326		 |246		 |
       |272	       | 212		|327		 |247		 |
       |273	       | 213		|330		 |250		 |
       |274	       | 214		|331		 |251		 |
       |275	       | 215		|332		 |252		 |
       |276	       | 216		|333		 |253		 |
       |277	       | 217		|334		 |254		 |
       |300	       | 220		|335		 |255		 |
       |301	       | 221		|336		 |256		 |
       |302	       | 222		|337		 |257		 |
       |303	       | 223		|360-374	 |40		 |
       |304	       | 224		|375		 |260		 |
       |305	       | 225		|376		 |40		 |
       |306	       | 226		|365		 |40		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-5 to MS 1251
       For the conversion of ISO 8859-5 to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-5   |    MS 1251	|  ISO 8859-5	 |   MS 1251	 |
       |24	       | 4		|317		 |337		 |
       |200-237        | 40		|320		 |340		 |
       |241	       | 250		|321		 |341		 |
       |242	       | 200		|322		 |342		 |
       |243	       | 201		|323		 |343		 |
       |244	       | 252		|324		 |344		 |
       |245	       | 275		|325		 |345		 |
       |246	       | 262		|326		 |346		 |
       |247	       | 257		|327		 |347		 |
       |250	       | 243		|330		 |350		 |
       |251	       | 212		|331		 |351		 |
       |252	       | 214		|332		 |352		 |
       |253	       | 216		|333		 |353		 |
       |254	       | 215		|334		 |354		 |
       |255	       | 210		|335		 |355		 |
       |256	       | 241		|336		 |356		 |
       |257	       | 217		|337		 |357		 |
       |260	       | 300		|340		 |360		 |
       |261	       | 301		|341		 |361		 |
       |262	       | 302		|342		 |362		 |
       |263	       | 303		|343		 |363		 |
       |264	       | 304		|344		 |364		 |
       |265	       | 305		|345		 |365		 |
       |266	       | 306		|346		 |366		 |
       |267	       | 307		|347		 |367		 |
       |270	       | 310		|350		 |370		 |
       |271	       | 311		|351		 |371		 |
       |272	       | 312		|352		 |372		 |
       |273	       | 313		|353		 |373		 |
       |274	       | 314		|354		 |374		 |
       |275	       | 315		|355		 |375		 |
       |276	       | 316		|356		 |376		 |
       |277	       | 317		|357		 |377		 |
       |300	       | 320		|360		 |271		 |
       |301	       | 321		|361		 |270		 |
       |302	       | 322		|362		 |220		 |
       |303	       | 323		|363		 |203		 |
       |304	       | 324		|364		 |272		 |
       |305	       | 325		|365		 |276		 |
       |306	       | 326		|366		 |263		 |
       |307	       | 327		|367		 |277		 |
       |310	       | 330		|370		 |274		 |
       |311	       | 331		|371		 |232		 |
       |312	       | 332		|372		 |234		 |
       |313	       | 333		|373		 |236		 |
       |314	       | 334		|374		 |235		 |
       |315	       | 335		|375		 |210		 |
       |316	       | 336		|376		 |242		 |
       |376	       | 331		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-5 to Mac Cyrillic
       For the conversion of ISO 8859-5 to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-5   | Mac Cyrillic	|  ISO 8859-5	 | Mac Cyrillic  |
       |24	       | 4		|317		 |237		 |
       |200-237        | 40		|320		 |340		 |
       |240	       | 312		|321		 |341		 |
       |241	       | 335		|322		 |342		 |
       |242	       | 253		|323		 |343		 |
       |243	       | 256		|324		 |344		 |
       |244	       | 270		|325		 |345		 |
       |245	       | 301		|326		 |346		 |
       |246	       | 247		|327		 |347		 |
       |247	       | 272		|330		 |350		 |
       |250	       | 267		|331		 |351		 |
       |251	       | 274		|332		 |352		 |
       |252	       | 276		|333		 |353		 |
       |253	       | 40		|334		 |354		 |
       |254	       | 315		|335		 |355		 |
       |255	       | 40		|336		 |356		 |
       |256	       | 330		|337		 |357		 |
       |257	       | 332		|340		 |360		 |
       |260	       | 200		|341		 |361		 |
       |261	       | 201		|342		 |362		 |
       |262	       | 202		|343		 |363		 |
       |263	       | 203		|344		 |364		 |
       |264	       | 204		|345		 |365		 |
       |265	       | 205		|346		 |366		 |
       |266	       | 206		|347		 |367		 |
       |267	       | 207		|350		 |370		 |
       |270	       | 210		|351		 |371		 |
       |271	       | 211		|352		 |372		 |
       |272	       | 212		|353		 |373		 |
       |273	       | 213		|354		 |374		 |
       |274	       | 214		|355		 |375		 |
       |275	       | 215		|356		 |376		 |
       |276	       | 216		|357		 |337		 |
       |277	       | 217		|360		 |334		 |
       |300	       | 220		|361		 |336		 |
       |301	       | 221		|362		 |254		 |
       |302	       | 222		|363		 |257		 |
       |303	       | 223		|364		 |271		 |
       |304	       | 224		|365		 |317		 |
       |305	       | 225		|366		 |264		 |
       |306	       | 226		|367		 |273		 |
       |307	       | 227		|370		 |300		 |
       |310	       | 230		|371		 |275		 |
       |311	       | 231		|372		 |277		 |
       |312	       | 232		|373		 |40		 |
       |313	       | 233		|374		 |316		 |
       |314	       | 234		|375		 |40		 |
       |315	       | 235		|376		 |331		 |
       |316	       | 236		|		 |		 |
       +---------------+----------------+----------------+---------------+

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_8859-5(5)
All times are GMT -4. The time now is 05:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy