Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Removing \n within a fixed width record
Top Forums Shell Programming and Scripting Removing \n within a fixed width record Post 302312414 by CKT_newbie88 on Friday 1st of May 2009 10:12:51 AM
Old 05-01-2009
I've give you an example, since data is senstive. It is a fixed width file downloaded from Mainframe via FTP. This is the what the file would look like (in Unix Env).

Col1 Char5
Col2 Char5
Col3 Char20
Col4 Char5

Expected Format:
12345abcdeMy name is Jack SmitSVY01

Actual Format
12345abcdMy name is
Jack SmitSVY01

There was an embedded (\n) after "My name is" and automatically forced a new line...furthermore, each record has a (\n) as its record delimter (not visibly shown).

I would like to remove the embedded LF (\n) BUT not the record delimiter.

Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to insert a record in fixed width flatfile

I have a fixed width flatfile with 5 columns, i will load file from oracle database to the flatfile for every 15 min at the end of the file, i want to insert a record by calling a shell script for inserting a record. please can any one help me. Thanks. (1 Reply)
Discussion started by: limou
1 Replies

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

3. Shell Programming and Scripting

Removing inserted newlines from a fileld of fixed width file.

Hi champs! I have a fixed width file in which the records appear like this 11111 <fixed spaces such as 6> description for 11111 <fixed spaces such as 6> some more field to the record of 11111 22222 <fixed spaces such as 6> description for 22222 <fixed spaces such as 6> some more field to the... (8 Replies)
Discussion started by: enigma_1
8 Replies

4. Shell Programming and Scripting

Printing Fixed Width Columns

Hi everyone, I have been working on a pretty laborious shellscript (with bash) the last couple weeks that parses my firewall policies (from a Juniper) for me and creates a nifty little columned output. It does so using awk on a line by line basis to pull out the appropriate pieces of each... (4 Replies)
Discussion started by: cixelsyd
4 Replies

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

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

7. Shell Programming and Scripting

variable fixed-width fields

Hi there, CTL Port IO Rate(IOPS) Read Rate(IOPS) Write Rate(IOPS) Read Hit(%) Write Hit(%) Trans. Rate(MB/S) Read Trans. Rate(MB/S) Write Trans. Rate(MB/S) 09:36:48 0 A 136 0 135 97 100 ... (6 Replies)
Discussion started by: gray380
6 Replies

8. UNIX for Advanced & Expert Users

how to find lenght of fixed width file record?

actually i am trying to find the lenght of fixed width file record reading from teradata db but its not working can u guys help me out? code which i wrote--- colmn_lngth=`cat $RPT_FILE | awk -F~ '{print $1}'` rm $RPT_FILE while read line do result=`echo $line | wc -m` ... (4 Replies)
Discussion started by: Seshendranath
4 Replies

9. Shell Programming and Scripting

Removing duplicates in fixed width file which has multiple key columns

Hi All , I have a requirement where I need to remove duplicates from a fixed width file which has multiple key columns .Also , need to capture the duplicate records into another file . File has 8 columns. Key columns are col1 and col2. Col1 has the length of 8 col 2 has the length of 3. ... (5 Replies)
Discussion started by: saj
5 Replies

10. Shell Programming and Scripting

Joining fixed width files

Hi All, I need to join fixed width files on a column which is position 1 to 3 and need to have all the records from file1 file1.txt Cu1nullL1L2 Cu2nullL1L2 Cu3nullL1L2 file2.txt Cu1B1B2 Cu3B1B2 output.txt Cu1L1B1L2B2 Cu2L1L2 Cu3L1B1L2B3 I tried but not getting the expected... (12 Replies)
Discussion started by: shash
12 Replies

LEARN ABOUT DEBIAN

igrep

IGREP(1)						      General Commands Manual							  IGREP(1)

NAME

       igrep - search images for matching metadata

SYNOPSIS

       igrep [options] pattern files...

DESCRIPTION

       The igrep utility is invoked as follows:

       igrep [options] pattern filename...

       Where  pattern  is  a POSIX.2 regular expression (just like the Unix/Linux grep(1) command), and filename (and any following names) specify
       images or directories that should be searched. An image file will "match" if any of its metadata contains values contain substring that are
       recognized  regular  expression.  The  image  files  may be of any format recognized by OpenImageIO (i.e., for which ImageInput plugins are
       available).

       Example:

       $ igrep Jack *.jpg
       bar.jpg: Keywords = Carly; Jack
       foo.jpg: Keywords = Jack
       test7.jpg: ImageDescription = Jack on vacation

       For a complete description, see /usr/share/doc/libopenimageio-dev/openimageio.pdf.gz.

OPTIONS

       --help Print help message

       -i     Ignore upper/lower case distinctions

       -v     Invert match (select non-matching files)

       -E     Pattern is an extended regular expression

       -f     Match against file name as well as metadata

       -l     List the matching files (no detail)

       -r     Recurse into directories

       -d     Print directories (when recursive)

       -a     Search all subimages of each file

       SEE ALSO
	      iconvert(1), idiff(1), iinfo(1), iprocess(1), iv(1), maketx(1), oiiotool(1).

AUTHOR

       OpenImageIO was written by Larry Gritz and the other authors and contributors.

       This manual page was written by IRIE Shinsuke <irieshinsuke@yahoo.co.jp>, for the Debian project (and may be used by others).

								   May 19, 2012 							  IGREP(1)
All times are GMT -4. The time now is 08:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy