Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Split a single record to multiple records & add folder name to each line
Top Forums Shell Programming and Scripting Split a single record to multiple records & add folder name to each line Post 302536473 by Morgan Greywolf on Tuesday 5th of July 2011 01:16:01 PM
Old 07-05-2011
If you know that each of the records is exactly 44 characters, then you can just use the fold command (assuming you're using a POSIX compliant shell):

Code:
fold -w44 /abc/$(date +%Y%m%d)/def/asdf.dat | sed "s/$/ $(date +%Y%m%d)/" >/abc/$(date +%Y%m%d)/def/asdf_split

but that assumes that each of the records is always 44 characters and they never contain any embedded newlines, etc.

---------- Post updated at 01:16 PM ---------- Previous update was at 01:14 PM ----------

BTW -- that looks almost exactly like HPGL.
Last edited by Morgan Greywolf; 07-05-2011 at 02:23 PM.. Reason: thinko misplaced quote
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort & Split records in a file

Hi, I am new to scripting. I need a script to sort and the records in a file and then split them into different files. For example, the file is: H1...................... H2...................... D2.................... D2.................... H1........................... (15 Replies)
Discussion started by: Sunitha_edi82
15 Replies

2. Shell Programming and Scripting

Parsing record into multiple records in Shell Script

Hi, I am trying to parse a very long record in a text file into multiple records by checking ADD, DELETE, or MODIFY field value in a shell script. Input # File name xyz.txt ADD|N000|8015662|DELETE|N001|9915662|MODIFY|N999|85678 Output ADD|N000|8015662| DELETE|N001|9915662|... (8 Replies)
Discussion started by: naveed
8 Replies

3. Shell Programming and Scripting

Single/Multiple Line with Special characters - Find & Replace in Unix Script

Hi, I am creating a script to do a find and replace single/multiple lines in a file with any number of lines. I have written a logic in a script that reads a reference file say "findrep" and populates two variables $FIND and $REPLACE print $FIND gives Hi How r $u Rahul() Note:... (0 Replies)
Discussion started by: r_sarnayak
0 Replies

4. Shell Programming and Scripting

Multiple records based on ';' in the record

Hi All, I have a *.csv files in a die /pro/lif/dow, (pipe delimiter file), these files are having 8 columns and 6 column(CDR_LOGIC) records are populated as below, I need to incorporate the below logic in all the *.csv files. 11||:ColumnA||:ColumnB 123||:ColumnA IIF(:ColumnA = :ColumnC then... (6 Replies)
Discussion started by: shruthidwh
6 Replies

5. Shell Programming and Scripting

Multiple lines in a single column to be merged as a single line for a record

Hi, I have a requirement with, No~Dt~Notes 1~2011/08/1~"aaa bbb ccc ddd eee fff ggg hhh" Single column alone got splitted into multiple lines. I require the output as No~Dt~Notes 1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh" mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies

6. UNIX for Dummies Questions & Answers

Split single record to multiple records

Hi Friends, source .... col1,col2,col3 a,b,1;2;3 here colom delimeter is comma(,). here we dont know what is the max length of col3 means now we have 1;2;3 next time i will receive 1;2;3;4;5;etc... required output .............. col1,col2,col3 a,b,1 a,b,2 a,b,3 please give me... (5 Replies)
Discussion started by: bab.galary
5 Replies

7. Shell Programming and Scripting

Split records into multiple records

Hi All, I am trying to split a record into multiple records based on a value. Input.txt "A",1,0,10 "B",2,0,10,15,20 "C",3,11,14,16,19,21,23 "D",1,0,5 My desired output is: "A",1,0,10 "B",2,0,10 "B",2,15,20 "C",3,11,14 "C",3,16,19 "C",3,21,23 (4 Replies)
Discussion started by: kmsekhar
4 Replies

8. Shell Programming and Scripting

Multiple Records from 1 Record

I need to make one record to multiple records based on occurence column in the record and change the date.For example below first record has 5 ,so need to create 5 records from one and change the date to 5 months.Occurence can be any number. I am unable to come with a script.Can some one help ... (5 Replies)
Discussion started by: traininfa
5 Replies

9. Shell Programming and Scripting

Split a large file in n records and skip a particular record

Hello All, I have a large file, more than 50,000 lines, and I want to split it in even 5000 records. Which I can do using sed '1d;$d;' <filename> | awk 'NR%5000==1{x="F"++i;}{print > x}'Now I need to add one more condition that is not to break the file at 5000th record if the 5000th record... (20 Replies)
Discussion started by: ibmtech
20 Replies

10. Shell Programming and Scripting

How to split one record to multiple records?

Hi, I have one tab delimited file which is having multiple store_ids in first column seprated by pipe.I want to split the file on the basis of store_id(separating 1st record in to 2 records ). I tried some more options like below with using split,awk etc ,But not able to get proper output. can... (1 Reply)
Discussion started by: jaggy
1 Replies

LEARN ABOUT FREEBSD

fold

FOLD(1) 						    BSD General Commands Manual 						   FOLD(1)

NAME

     fold -- fold long lines for finite width output device

SYNOPSIS

     fold [-bs] [-w width] [file ...]

DESCRIPTION

     The fold utility is a filter which folds the contents of the specified files, or the standard input if no files are specified, breaking the
     lines to have a maximum of 80 columns.

     The options are as follows:

     -b      Count width in bytes rather than column positions.

     -s      Fold line after the last blank character within the first width column positions (or bytes).

     -w width
	     Specify a line width to use instead of the default 80 columns.  The width value should be a multiple of 8 if tabs are present, or the
	     tabs should be expanded using expand(1) before using fold.

ENVIRONMENT

     The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of fold as described in environ(7).

SEE ALSO

     expand(1), fmt(1)

STANDARDS

     The fold utility conforms to IEEE Std 1003.1-2001 (``POSIX.1'').

BUGS

     If underlining (see ul(1)) is present it may be messed up by folding.

BSD
								 December 15, 2006							       BSD
All times are GMT -4. The time now is 08:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy