Converting a Delimited File to Fixed width file Post: 302120469

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting Tab delimited file to Comma delimited file in Unix

Hi, Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix Thanks!!

2. UNIX for Advanced & Expert Users

Converting field into fixed width csv

Hi I have a file having record as - 1,aaa,a123,a I need this converted to as 2nd col to 5 chars wide & 3rd col to 6chars wide such as - 1,aaa ,a123 ,a How we could achieve this? Thx in advance.

3. UNIX for Dummies Questions & Answers

Converting Space delimited file to Tab delimited file

Hi all, I have a file with single white space delimited values, I want to convert them to a tab delimited file. I tried sed, tr ... but nothing is working. Thanks, Rajeevan D

4. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12...

5. Shell Programming and Scripting

converting fixed length file to delimited file

hi , i need to convert fixed length file to delimited file using unix where length of each column is variable

6. UNIX for Dummies Questions & Answers

cleaning up spaces from fixed width file while converting to csv file

Open to a sed/awk/or perl alternative so that i can stick command into my bash script. This is a problem I resolve using a combination of cut commands - but that is getting convoluted. So would really appreciate it if someone could provide a better solution which basically replaces all...

7. UNIX for Dummies Questions & Answers

Delete header row and reformat from tab delimited to fixed width

Hello gurus, I have a file in a tab delimited format and a header row. I need a code to delete the header in the file, and convert the file to a fixed width format, with all the columns aligned. Below is a sample of the file:...

8. UNIX for Dummies Questions & Answers

convert # delimited text file to fixed width

Hello gurus, I have a file containing 5 columns delimited by '#' as shown in the example below: HRP1000-PLVAR#HRP1000-OTYPE#HRP1000-OBJID#HRP1000-BEGDA#HRP1000-ENDDA# 99991231#AU7129#000000000#1 PROCTER & GAMBLE# 99991231#TT4283#1000013883#21111 LAUNDRY# 99991231#TT4283#1000013884#21121 DISH...

9. Red Hat

Converting fixed width file to pipe delimiter in Linux(red-hat)

Hi, I am facing a typical scenario for AWK command . In HP- UNIX is behave as expected but in red hat linux same awk code is not give the same result. The below code is for convert the fixed width file to pipe delimiter file in HP-unix server. awk code: #!/bin/awk -f NR!=1...

10. UNIX for Beginners Questions & Answers

Convert a fixed width file to a delimited file

Hi - this is a generic question .... is there any utility which can convert a fixed width file format to a delimited file (any given character delimited) ?

LEARN ABOUT FREEBSD

nisplus_table

NISPLUS_TABLE(5)						File Formats Manual						  NISPLUS_TABLE(5)

NAME

       nisplus_table - Postfix NIS+ client

SYNOPSIS

       postmap -q "string" "nisplus:[name=%s];name.name."

       postmap -q - "nisplus:[name=%s];name.name." <inputfile

DESCRIPTION

       The  Postfix  mail  system uses optional lookup tables.	These tables are usually in dbm or db format.  Alternatively, lookup tables can be
       specified as NIS+ databases.

       To find out what types of lookup tables your Postfix system supports use the "postconf -m" command.

       To test Postfix NIS+ lookup tables, use the "postmap -q" command as described in the SYNOPSIS above.

QUERY SYNTAX

       Most of the NIS+ query is specified via the NIS+ map name. The general format of a Postfix NIS+ map name is as follows:

	   nisplus:[name=%s];name.name.name.:column

       Postfix NIS+ map names differ from what one normally would use with commands such as niscat:

       o      With each NIS+ table lookup, "%s" is replaced by a version of the lookup string.	There can be only one "%s" instance in	a  Postfix
	      NIS+ map name.

       o      Postfix  NIS+  map  names  use  ";"  instead  of	",", because the latter character is special in the Postfix main.cf file.  Postfix
	      replaces ";" characters in the map name by "," before making NIS+ queries.

       o      The ":column" part in the NIS+ map name is not part of the actual NIS+ query. Instead, it specifies the number of the  table  column
	      that provides the lookup result. When no ":column" is specified the first column (1) is used.

EXAMPLE

       A NIS+ aliases map might be queried as follows:

	   alias_maps = dbm:/etc/mail/aliases,
	       nisplus:[alias=%s];mail_aliases.org_dir.$mydomain.:1

       This queries the local aliases file before the NIS+ file.

SEE ALSO

       postmap(1), Postfix lookup table manager

README FILES

       Use "postconf readme_directory" or "postconf html_directory" to locate this information.
       DATABASE_README, Postfix lookup table overview

LICENSE

       The Secure Mailer license must be distributed with this software.

AUTHOR(S)
       Geoff Gibbs
       UK-HGMP-RC
       Hinxton
       Cambridge
       CB10 1SB, UK

       Adopted and adapted by:
       Wietse Venema
       IBM T.J. Watson Research
       P.O. Box 704
       Yorktown Heights, NY 10598, USA

       Wietse Venema
       Google, Inc.
       111 8th Avenue
       New York, NY 10011, USA

																  NISPLUS_TABLE(5)