Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to delimit a flat file with records with SED
Top Forums Shell Programming and Scripting How to delimit a flat file with records with SED Post 302251754 by RogCor on Monday 27th of October 2008 11:41:04 PM
Old 10-28-2008
How to delimit a flat file with records with SED
Hi gurus, hoping someone can help with a sed line that can do the following...

I have a flat file with about 1000 records, but in order to import into openoffice spreadsheet, I need to create a delimited file. I'd like to do 2 things with the SED command:
1- add a pipe character "|" at the end of each line
2- (the above will create a double pipe for every two blank links, such as ||). Replace the || double-pipe with carriage returns so in the end I have a delimited file. Im not rigid on how to perform step 2, so any recommendations are appreciated. See the file format below for a better view.


The file format is like this:

Person1
Address
Value1
License Status blah blah blah

<2 carriage returns>
Person2
Address
Value1
License status.. blah...

<2 Carriage returns>
etc...


After running the text file through a SED command, i'd like the file to look like this:

Person1|Address|Value1|License Status blah blah blah
Person2|Address|Value1|License status.. blah...
Person3|etc...


Any help is greatly appreciated! Thanks in advance!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inserting records from flat file to db table

I have 20000 numbers present in a file in each line like 25663, 65465, 74579, 56446, .. .. I have created a table in db with single number column in it. create table testhari (no number(9)); I want to insert all these numbers into that table. how can i do it? can anybody please... (4 Replies)
Discussion started by: Hara
4 Replies

2. UNIX for Dummies Questions & Answers

Problems with sed and flat file variables

Hello All, It has been a loooooooooooong time since I had last used sed but decided to use it for a simple task I have . My goal is to use sed to read variables from a flat file then use those same variables in order to make some subsitutions. However what I am finding is that when the... (1 Reply)
Discussion started by: icalderus
1 Replies

3. Shell Programming and Scripting

Sorting the records in the Flat file

Hi all, I am using this command "sort -d -u -k1 IMSTEST.74E -o tmp.txt" to the records in the flat. Can any tell me how to sort the file except first line in the file For ex: i/p First line: DXYZ Second line : jumy third : cmhk fourth : andy Output should... (5 Replies)
Discussion started by: sudhir_barker
5 Replies

4. Shell Programming and Scripting

How do I load records from table to a flat file!

Hi All, I need to load records from oracle table XYZ to a flat file say ABC.dat. could any one tell me how do i do this in UNXI, Regards Ann (1 Reply)
Discussion started by: Haque123
1 Replies

5. Shell Programming and Scripting

SED | Awk flat file one liner

sed awk one liner (2 Replies)
Discussion started by: jap2614
2 Replies

6. Shell Programming and Scripting

Remove somewhat Duplicate records from a flat file

I have a flat file that contains records similar to the following two lines; 1984/11/08 7 700000 123456789 2 1984/11/08 1941/05/19 7 700000 123456789 2 The 123456789 2 represents an account number, this is how I identify the duplicate record. The ### signs represent... (4 Replies)
Discussion started by: jolney
4 Replies

7. Shell Programming and Scripting

How to remove space and delimit a csv file?

Hi All , I am facing a small challenge i need unix command to remove space as well as replace "|" to "," in a csv file . original file : A | B | c | D E | F | G | H I | J | K | L P | M | N | O Expected o/p: A,B,c,D E,F,G,H I,J,K,L P,M,N,O (4 Replies)
Discussion started by: Sweety532
4 Replies

8. Shell Programming and Scripting

sed flat file manipulation

Hello, I have a large flat file where i need to change data in columns 131-133 based on what is in columns 172-173. I am not sure if I need to read the file line by line and make the change or if I can do this in a single statement. thank you (3 Replies)
Discussion started by: gblmin
3 Replies

9. Shell Programming and Scripting

Delimit file based on character length using awk

Hi, I need help with one problem, I came across recently. I have one input file which I need to delimit based on character length. $ cat Input.txt 12345sda231453 asd760kjol62569 sdasw4g76gdf57 And, There is one comma separated file which mentions "start of the field" and "length... (6 Replies)
Discussion started by: Prathmesh
6 Replies

10. Shell Programming and Scripting

How to delimit the fields of a input file which has special characters?

Hi All, I am a newbie to Shell scripting. I have a requirement to Delimit the file fields of a Input file having special characters and spaces with ";". Input File ---------------------------------- Server Port ---------------------------------- Local ... (5 Replies)
Discussion started by: Suganbabu
5 Replies

LEARN ABOUT DEBIAN

impressive-gettransitions

IMPRESSIVE-GETTRANSITIONS(1)				      Debian GNU/Linux manual				      IMPRESSIVE-GETTRANSITIONS(1)

NAME

       impressive-gettransitions - Generate Impressive info scripts for LaTeX presentations

SYNOPSIS

       impressive-gettransitions FILE.tex

DESCRIPTION

       A simple script to produce a .info file for use with Impressive, using special comments in a LaTeX/Beamer file. FILE.tex is a file to be
       parsed into .info file. For each /fullpath/blah.tex /fullpath/blah.pdf.info gets produced.

SYNTAX

       In the LaTeX document, impressive-gettransitions counts the pages to determine the PDF slide number of each one.

       The simpler page changes are automatically detected, that is:
	   egin{frame} and:
	   pause

       Other, more elaborated page changes must be noted with a %O comment:
	   item<1-> Foo
	   item<2-> Bar %O

       The transition to apply can be specified in a %O comment:
	   egin{frame} %O SlideUp

OPERATION

       When the .info file corresponding to the LaTeX document already exist, impressive-gettransitions does not clear it, but only adds the
       transitions if finds to it.

       Thus, if you modified your document in a way that requires to completely replace the transitions, manually clear the PageProps section of
       the .info file. This can be done by running the following sed command:
	   sed -i -e "/^PageProps = {/,/^}/d" FILE.info

SEE ALSO

       impressive(1)

AUTHOR

       impressive-gettransitions (originally gettransitions) has been written by Rob Reid.

       This manpage has been originally written by Yaroslav Halchenko <debian@onerussian.com>.

Debian Project							    2012-02-10					      IMPRESSIVE-GETTRANSITIONS(1)
All times are GMT -4. The time now is 09:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy