Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: adding delimiter to a fixed width file
Top Forums Shell Programming and Scripting adding delimiter to a fixed width file Post 302111490 by sumeet on Wednesday 21st of March 2007 09:47:49 AM
Old 03-21-2007
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
CSCH74,000.00
CSCH74,100.00
CSCH74,000.00
CSCH74,000.00
CSCH74,100.00
CSCH74,100.00
CSCH74,100.00

another scenario is I have:

CSCH72007-03-012007-03-04000.00
CSCH72007-03-052007-03-11000.00
CSCH72007-03-122007-03-18100.00
CSCH742007-03-192007-03-25000.00
CSCH742007-03-262007-03-31100.00
CSCH742007-04-012007-04-01000.00
CSCH742007-04-022007-04-08000.00
CSCH742007-04-092007-04-15100.00
CSCH742007-04-162007-04-22100.00
CSCH742007-04-232007-04-29100.00

I have to put delimiters as following:

CSCH74,2007-03-01,2007-03-04,000.00
CSCH74,2007-03-05,2007-03-11,000.00
CSCH74,2007-03-12,2007-03-18,100.00
CSCH74,2007-03-19,2007-03-25,000.00
CSCH74,2007-03-26,2007-03-31,100.00
CSCH74,2007-04-01,2007-04-01,000.00
CSCH74,2007-04-02,2007-04-08,000.00
CSCH74,2007-04-09,2007-04-15,100.00
CSCH74,2007-04-16,2007-04-22,100.00
CSCH74,2007-04-23,2007-04-29,100.00

Can anyone suggest any idea. I think we will have to use awk to print the file in the file in that specific format.

Thanks
SUmeet
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Fixed Width file using AWK

I am using the following command at the Unix prompt to make my 'infile' into a fixed width file of 100 characters. awk '{printf "%-100s\n",$0}' infile > outfile However, there are some records with a special character "©" These records are using 3 characters in place of one and my record... (2 Replies)
Discussion started by: alok.benjwal
2 Replies

2. Shell Programming and Scripting

Changing particular field in fixed width file

I have a fixed width file and i need to change 36th field to "G" in for about random 20 records? How can I do it? (4 Replies)
Discussion started by: dsravan
4 Replies

3. UNIX Desktop Questions & Answers

Help with Fixed width File Parsing

I am trying to parse a Fixed width file with data as below. I am trying to assign column values from each record to variables. When I parse the data, the spaces in all coumns are dropped. I would like to retain the spaces as part of the dat stored in the variables. Any help is appreciated. I... (4 Replies)
Discussion started by: sate911
4 Replies

4. Shell Programming and Scripting

Fixed-Width file from Oracle

Hi All, I have created a script which generates FIXED-WIDTH file by executing Oracle query. SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ It generates the data file with proper alignment. But if same file i transfer to windows server or Mainframe... (5 Replies)
Discussion started by: Amit.Sagpariya
5 Replies

5. Shell Programming and Scripting

Comparing two fixed width file

Hi Guys I am checking the treads to get the answer but i am not able to get the answer for my question. I have two files. First file is a pattern file and the second file is the file i want to search in it. Output will be the lines from file2. File1: P2797f12af 44751228... (10 Replies)
Discussion started by: anshul_er
10 Replies

6. Shell Programming and Scripting

Fixed width file comparision not working

when i used diff/cmp/cat -v commands i am getting the difference cmp command cmp -l file1 file2 |head -1 1300 15 10 Manually checked records. record length and data matched. diff file1 file2 3C3 <record information Manually checked records. record length and data matched.... (4 Replies)
Discussion started by: onesuri
4 Replies

7. UNIX for Dummies Questions & Answers

Length of a fixed width file

I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers. awk '{print length;exit}' <File_name> The above code gives me length 50. wc -L <File_name> The above code gives me length 53. Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies

8. Shell Programming and Scripting

Alter Fixed Width File

Thank u so much .Its working fine as expected. ---------- Post updated at 03:41 PM ---------- Previous update was at 01:46 PM ---------- I need one more help. I have another file(fixed length) that will get negative value (ex:-00000000003000) in postion (98 - 112) then i have to... (6 Replies)
Discussion started by: vinus
6 Replies

9. Shell Programming and Scripting

Adding delimiter to a fixed pattern of date

I have a text file as below: jan16201413:17PM jan1620143:17PM jan1620143:17PM jan1620143:17PM jan1620143:17PM I want to add a delimeter which will be space to the date part as below: jan 16 2014 13:17 PM jan 16 2014 3:17 PM jan 16 2014 3:17 PM jan 16 2014 3:17 PM jan 16... (13 Replies)
Discussion started by: Sharma331
13 Replies

10. 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... (11 Replies)
Discussion started by: brij_abhi
11 Replies

LEARN ABOUT OPENSOLARIS

mlib_imagecolorycc2rgb_fp

mlib_ImageColorYCC2RGB_Fp(3MLIB)			    mediaLib Library Functions				  mlib_ImageColorYCC2RGB_Fp(3MLIB)

NAME

       mlib_ImageColorYCC2RGB_Fp - YCC to RGB color conversion

SYNOPSIS

       cc [ flag... ] file... -lmlib [ library... ]
       #include <mlib.h>

       mlib_status mlib_ImageColorYCC2RGB_Fp(mlib_image *dst,
	    const mlib_image *src);

DESCRIPTION

       The mlib_ImageColorYCC2RGB_Fp() function performs a color space conversion from ITU-R Rec.601 Y'CbCr to computer R'G'B'.

       The source and destination images must be three-channel images.

       It uses the following equation:

	 |R'|	|cmat[0] cmat[1] cmat[2]|   |Y'|   |offset[0]|
	 |G'| = |cmat[3] cmat[4] cmat[5]| * |Cb| + |offset[1]|
	 |B'|	|cmat[6] cmat[7] cmat[8]|   |Cr|   |offset[2]|

       where

	 cmat[] = { 298.082/256,    0.000/256,	408.583/256,
		    298.082/256, -100.291/256, -208.120/256,
		    298.082/256,  516.411/256,	  0.000/256 };
	 offset[] = { -222.922, 135.575, -276.836 };
	 src[x][y] = { Y', Cb, Cr };
	 dst[x][y] = { R', G', B' };

PARAMETERS

       The function takes the following arguments:

       dst    Pointer to destination image.

       src    Pointer to source image.

RETURN VALUES

       The function returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mlib_ImageColorConvert2(3MLIB),	  mlib_ImageColorConvert2_Fp(3MLIB),	mlib_ImageColorRGB2XYZ(3MLIB),	 mlib_ImageColorRGB2XYZ_Fp(3MLIB),
       mlib_ImageColorRGB2YCC(3MLIB), mlib_ImageColorRGB2YCC_Fp(3MLIB), mlib_ImageColorYCC2RGB(3MLIB), attributes(5)

SunOS 5.11							    2 Mar 2007					  mlib_ImageColorYCC2RGB_Fp(3MLIB)
All times are GMT -4. The time now is 04:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy