Sponsored Content
Top Forums Shell Programming and Scripting splitting a pipe delimited file in unix Post 302111195 by ddedic on Tuesday 20th of March 2007 12:48:54 AM
Old 03-20-2007
Question unix script to split file

My file for ex. is a 10mil record file. Within the shell script I need to determine the record count and divided it into 4 separate files.

Is it ok to do a wc -l into a variable / 4? Would reminder take care of itself - meaning it will be a part of the 4th file.

Please advise and I hope this helps.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to split pipe delimited file

I have a pipe delimited input file as below. First byte of the each line indicate the record type. Then i need to split the file based on record_type = null,0,1,2,6 and create 5 files. How do i do this in a ksh script? Pls help |sl||SL|SL|SL|1996/04/03|1988/09/15|C|A|sl||||*|... (4 Replies)
Discussion started by: njgirl
4 Replies

2. Shell Programming and Scripting

splitting tab-delimited file with awk

Hi all, I need help to split a tab-delimited list into separate files by the filename-field. The list is already sorted ascendingly by filename, an example list would look like this; filename001 word1 word2 filename001 word3 word4 filename002 word1 word2 filename002 word3 word4... (4 Replies)
Discussion started by: perkele
4 Replies

3. Shell Programming and Scripting

convert a pipe delimited file to a':" delimited file

i have a file whose data is like this:: osr_pe_assign|-120|wg000d@att.com|4| osr_evt|-21|wg000d@att.com|4| pe_avail|-21|wg000d@att.com|4| osr_svt|-11|wg000d@att.com|4| pe_mop|-13|wg000d@att.com|4| instar_ready|-35|wg000d@att.com|4| nsdnet_ready|-90|wg000d@att.com|4|... (6 Replies)
Discussion started by: priyanka3006
6 Replies

4. Shell Programming and Scripting

How to convert a space delimited file into a pipe delimited file using shellscript?

Hi All, I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted... AA ATIU2345098809 009697 005374 BB ATIU2345097809 005445 006518 CC ATIU9685098809 003215 003571 DD... (7 Replies)
Discussion started by: nithins007
7 Replies

5. UNIX for Dummies Questions & Answers

Reading a pipe delimited file

Hi Guys, i am reading a pipe delimited file using awk command. I have tested the gawk separately. it was fine. But when i execute the script. i am getting the following error saying command not found. Can somebody point out as what i am doing wrong. Cheers!!! (3 Replies)
Discussion started by: mac4rfree
3 Replies

6. Shell Programming and Scripting

Help with converting Pipe delimited file to Tab Delimited

I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use cat file | sed 's/|//t/g' The above command substituted "/t" not tab in the place of pipe. Sample file: abc|123|2012-01-30|2012-04-28|xyz have to convert to: abc 123... (6 Replies)
Discussion started by: karumudi7
6 Replies

7. Shell Programming and Scripting

How to ignore Pipe in Pipe delimited file?

Hi guys, I need to know how i can ignore Pipe '|' if Pipe is coming as a column in Pipe delimited file for eg: file 1: xx|yy|"xyz|zzz"|zzz|12... using below awk command awk 'BEGIN {FS=OFS="|" } print $3 i would get xyz But i want as : xyz|zzz to consider as whole column... (13 Replies)
Discussion started by: rohit_shinez
13 Replies

8. Shell Programming and Scripting

Splitting a delimited text file

Howdy folks, I've got a very large plain text file that I need to split into many smaller files. My script-fu is not powerful enough for this, so any assistance is much appreciated. The file is a database dump from Cyrus IMAP server. It's basically a bunch of emails (thousands) all... (13 Replies)
Discussion started by: lupin..the..3rd
13 Replies

9. UNIX for Dummies Questions & Answers

Need to convert a pipe delimited text file to tab delimited

Hi, I have a rquirement in unix as below . I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column. ex: Input Text file: 1|A|apple 2|B|bottle excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies

10. Shell Programming and Scripting

UNIX/PERL script to convert XML file to pipe delimited format

Hello, I need to get few values from a XML file and output needs to be written in another file with pipe delimited format. The Header & Footer of the Pipe Delimited file will be constant. The below is my sample XML file. I need to pull the values in between the XML tags <Operator_info to... (15 Replies)
Discussion started by: karthi1305561
15 Replies
splitshp(1)						      General Commands Manual						       splitshp(1)

NAME
splitshp - Split Shape into frames or combine frames into Shapes SYNOPSIS
splitshp SHAPE FRAME... splitshp SHAPE DESCRIPTION
Shape files are used for storage of all visible elements (from UI buttons to terrain features) of the games Exult supports. Shapes contain one or more frames. splitshp can be used to combine frames into one file, or split a Shape file into its component frames. The mode of operation is determined by looking at the number of commandline arguments. Exactly one argument means splitting, more than one argument signals a combining operation. Combining Each FRAME names a Shape file typically consisting of only one frame (i.e. subsequent frames are ignored). All these frames are concate- nated and written to the Shape file SHAPE. Splitting SHAPE will be read and split into its component frames. Each of those will be written to its own Shape file. The names of these files are determined by splitting the name of SHAPE before the last dot -- anything before this dot is the STEM, anything else (including the dot) is the PREFIX, which may be empty in case there is no dot in the name. The output files are then named STEM_nnSUFFIX with nn replaced by the frame number. EXAMPLES
splitshp button.shp button-up.shp button-down.shp Packs the (first) two frames from button-up.shp and button-down.shp into the Shape file button.shp splitshp grizzly Unpacks the frames contained in the Shape file grizzly into the (single-frame) Shape files grizzly_00, grizzly_01, grizzly_02, etc. splitshp boar.new.shp Unpacks the frames contained in the Shape file boar.new.shp into the (single-frame) Shape files boar.new_00.shp, boar.new_01.shp, boar.new_02.shp, etc. AUTHOR
This manpage was written by Robert Bihlmeyer. It may be freely redistributed and modified under the terms of the GNU General Public License version 2 or higher. SEE ALSO
exult(6), shp2pcx(1) Exult 2002-03-24 splitshp(1)
All times are GMT -4. The time now is 12:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy