Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Adding a delimiter to a variable length file
Top Forums Shell Programming and Scripting Adding a delimiter to a variable length file Post 302695275 by radoulov on Sunday 2nd of September 2012 12:42:06 PM
Old 09-02-2012
Quote:
Originally Posted by neutronscott
Code:
$ awk -F'|' '{NF=11}1' OFS='|' input
01|Test|Test1|Sample|||||||
02|AA|BB|CC|DD||||||
03|AAA|BBB|CCC|DDD|EEE|RRR|TTT|SSS|YYY|

Just to add that in some awk implementations the assignment to NF won't trigger the reconstruction of the current record:

Code:
zsh-5.0.0[t]% awk -F\| 'NF=11' OFS=\| infile            
01|Test|Test1|Sample|||||||
02|AA|BB|CC|DD||||||
03|AAA|BBB|CCC|DDD|EEE|RRR|TTT|SSS|YYY|
zsh-5.0.0[t]% nawk -F\| 'NF=11' OFS=\| infile
01|Test|Test1|Sample|
02|AA|BB|CC|DD|
03|AAA|BBB|CCC|DDD|EEE|RRR|TTT|SSS|YYY|
zsh-5.0.0[t]% nawk --version
awk version 20070501

The above nawk is the GnuWin32 nawk.

In such cases something like this could also be used as a workaround:

Code:
awk F\| '{
  for (i = 0; ++i < = c;)
    printf "%s", ($i (i < c ? OFS : ORS))
  }' OFS=\| c=11 infile

Last edited by radoulov; 09-02-2012 at 01:50 PM..
 

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

adding delimiter to a fixed width file

Hi , I have a file : CSCH74000.00 CSCH74000.00 CSCH74100.00 CSCH74000.00 CSCH74100.00 CSCH74000.00 CSCH74000.00 CSCH74100.00 CSCH74100.00 CSCH74100.00 I have to put a delimiter( say comma) in between after 6th character: CSCH74,000.00 CSCH74,000.00 CSCH74,100.00 (2 Replies)
Discussion started by: sumeet
2 Replies

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

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

5. Shell Programming and Scripting

Adding a delimiter to a text file

Im writing a KSH script to read a simple text file and add a delimiter. Ive written the following script but it runs very slow. I initially used the cut command to substring the input record then switched to this version using awk to substring... both run too slow. Any ideas how to make this more... (2 Replies)
Discussion started by: lock
2 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

Split variable length and variable format CSV file

Dear all, I have basic knowledge of Unix script and her I am trying to process variable length and variable format CSV file. The file length will depend on the numbers of Earnings/Deductions/Direct Deposits. And The format will depend on whether it is Earnings/Deductions or Direct Deposits... (2 Replies)
Discussion started by: chechun
2 Replies

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

9. Shell Programming and Scripting

Shell script to put delimiter for a no delimiter variable length text file

Hi, I have a No Delimiter variable length text file with following schema - Column Name Data length Firstname 5 Lastname 5 age 3 phoneno1 10 phoneno2 10 phoneno3 10 sample data - ... (16 Replies)
Discussion started by: Gaurav Martha
16 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 OSF1

sh

sh(1)							      General Commands Manual							     sh(1)

NAME

       sh - Shell, the standard command language interpreter

DESCRIPTION

       [Tru64  UNIX]  Tru64  UNIX  provides two command interpreters with the name sh.	The XCU5.0 and POSIX.2 compliant command interpreter sh is
       available in the file /usr/bin/posix/sh and is described in the sh(1p) reference page.  The Bourne shell,  historically	known  as  sh,	is
       available in the file /usr/bin/sh and is described in the sh(1b) reference page.

       [Tru64 UNIX]  Your initial, or login, shell is determined by your entry in the file /etc/passwd. This file can be changed only by your sys-
       tem administrator. You must use whatever procedures are in place at your location to have this entry changed.

       [Tru64 UNIX]  If available on your system, you may use the passwd -s or the chsh commands to change your login shell.

									  Note

       This option is not available if your site manages passwords through the Network Information Service (NIS) facility.  Check with your system
       administrator.

       [Tru64 UNIX]  Subsequent shells spawned from the initial shell depend on the value in the environment variable BIN_SH.  If this variable is
       set to xpg4, the POSIX shell is started. If this variable is set to svr4, an SVR4 compliant version of the shell is started. If this  vari-
       able  is  unset,  the  Bourne shell is started. If this variable is set to any other value, an error is reported and the results are unpre-
       dictable. See the EXAMPLES section for information on setting this variable.

NOTES

       [Tru64 UNIX]  With Tru64 UNIX Version 4.0 the Korn shell, /usr/bin/ksh is the same as the POSIX shell /usr/bin/posix/sh.

RESTRICTIONS

       [Tru64 UNIX]  The file /etc/shells must include entries for both the POSIX shell /usr/bin/posix/sh and the Bourne  shell,  /usr/bin/sh.	If
       this file is incorrect, see your system administrator.

EXAMPLES

       Using  the  Bourne,  Korn,  or  POSIX  shell, to set the variable BIN_SH to use the POSIX/ XCU5.0compliant shell, enter: BIN_SH=xpg4 export
       BIN_SH Using the Bourne, Korn, or POSIX shell, to set the variable BIN_SH to use the SVR4 compliant shell, enter: BIN_SH=svr4 export BIN_SH
       Using the Bourne, Korn, or POSIX shell, to unset the variable BIN_SH, enter: unset BIN_SH Using the C/ shell, to set the variable BIN_SH to
       use the POSIX/XCU5.0 compliant shell, enter: setenv BIN_SH xpg4 Using the C/ shell, to set the variable BIN_SH to use  the  SVR4  compliant
       shell, enter: setenv BIN_SH svr4 Using the C/ shell, to unset the variable BIN_SH, enter: unsetenv BIN_SH

FILES

       User profile.  Contains user information, including the login shell name.  Contains the names of available and permitted shells.

SEE ALSO

       Commands:  csh(1), ksh(1), Bourne shell sh(1b), POSIX shell sh(1p), passwd(1)

       Files:  passwd(4), shells(4)

       Standards:  standards(5)

																	     sh(1)
All times are GMT -4. The time now is 01:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy