Insert Delimiter at fixed locations in a flat file Post: 302429518

10 More Discussions You Might Find Interesting

1. 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. Shell Programming and Scripting

How to insert at a particular position in flat file

Hi All, I have a flat file with ~ as de-limiter (e.g: aaa~ba a~caa~0~d~e) What I want is check if the 4th character is 0 and replace it with say 4. So now it becomes : aaa~ba a~caa~4~d~e. I have to do this for the whole file, but the delimiter position remains the same, not the...

3. UNIX for Dummies Questions & Answers

Conditional sorting on fixed length flat file

I have a fixed length file that need to be sorted according to the following rule IF B=1 ORDER by A,B Else ORDER by A,C Input file is ABC 131 112 122 231 212 222 Output needed ABC 112 131 122 212 231 222

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

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

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

7. Shell Programming and Scripting

How to read the first column in a flat file with ~ as delimiter

I have one flat file like below id1~col~batch1 id2~col2~batch2 id3~col3~batch3 I need to read the first column one by one and I need to write one db2 query based on that column1 Like for (i=0;i<=10;i++) do insert into table column (con_id) values (select column from table where...

8. Shell Programming and Scripting

Program to insert Delimiters at fixed locations in a file, Can you please Debug it for me??

Can someone please help?I have a file - fixed.txt----------------------------AABBBBCCCCCCDDDEEFFFFGGGGGGHHHIIJJJJKKKKKKLLL----------------------------To insert delimiters at fixed lengths of 2, 4, 6, 3, I created a file text1.txt as-------------------2463----------------------and trying to execute...

9. Shell Programming and Scripting

how to implement in one-line awk in a fixed file having no delimiter

Hi, I have a file a.txt having no delimiter. I want to exclude the line which contains 435th character as 1 or 2 and redirect the rest of the lines to another file b. Can you pls suggest how to do this in one liner awk. Following is just one line of the input file a:- 120110116 ...

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

LEARN ABOUT OPENDARWIN

nidump

NIDUMP(8)						      System Manager's Manual							 NIDUMP(8)

NAME

       nidump - extract text or flat-file-format data from NetInfo

SYNOPSIS

       nidump [ -t ] { -r directory | format } domain

DESCRIPTION

       nidump  reads  the  specified  NetInfo domain and dumps a portion of its contents to standard output.  When a flat-file administration file
       format is specified, nidump provides output using the syntax of the corresponding flat file.  The allowed values for  format  are  aliases,
       bootparams, bootptab, exports, fstab, group, hosts, networks, passwd, printcap, protocols, rpc, and services.

       If  the	-r option is used, the first argument is interpreted as a NetInfo directory path, and its contents are dumped in a generic NetInfo
       format.

OPTIONS

       -t     Interpret the domain as a tagged domain.	For example, "trotter/network" refers to the database  tagged  "network"  on  the  machine
	      "trotter".  The machine name can be an actual name or an IP address.

       -r     Dump  the  specified  directory  in  "raw" format.  Directories are delimited by curly braces, and properties within a directory are
	      listed in the form "property = value;".  Parentheses introduce a comma-separated list of items. The special property  name  CHILDREN
	      is  used	to  hold  a  directory's children, if any are present.	Spacing and line breaks are significant only within double quotes,
	      which may be used to protect any names that might contain metacharacters.

EXAMPLES

       "nidump hosts ." dumps a hosts file from the local NetInfo domain.

       "nidump -r /locations /" dumps the /locations directory of the root domain.

       "nidump -t -r /name=users/uid=530 trotter/network" dumps the directory for the user whose UID is 530.

SEE ALSO

       niload(8), niutil(8), netinfo(5), aliases(5), bootparams(5), bootptab(5), exports(5), fstab(5), group(5), hosts(5), networks(5), passwd(5),
       printcap(5), protocols(5), rpc(5), services(5)

Apple Computer, Inc.						 December 22, 1992							 NIDUMP(8)