Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

File Splitter output filename

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File Splitter output filename
# 15  
Old 10-12-2012
@pamu.. i got below error

Code:
awk: 0602-533 Cannot find or open file {a++;if($0 ~ /^101/){if(s){
if(a>=CN){a=0;x++;fn=File_name""x;print s > fn;s=$0}else{print s > fn;s=$0}}
else{s=$0;x++;fn=File_name""x;}}
else{s=s"\n"$0;}}END{if(a>=CN){x++;fn=File_name""x};print s > fn}.
 The source line number is 1.

# 16  
Old 10-12-2012
corrected in previous post. Please check.
# 17  
Old 10-12-2012
Thanks @pamu . its working now. need some more refinements that was their earlier but i am unable to put them in new code

1> if Source file = A.txt. I will receive $1 as A and target file names required are A_0001.txt, A_0002.txt and so on
In old code it was achieved using sprintf command i.e.
Code:
 
awk 'NR%"'"${splitCount}"'"==1{x="'"${SrcFileName}_"'" sprintf("%04d",++i) ".txt"}{print > x}' $SrcFileName.txt

2> Need to assign CN with $2 i.e. SplitCount value
Code:
Call to shell script is as 
SplitFile.sh A 10
 
Code of shell script is as : Here i wanted to use varibales $1 and $2
SrcFileName=$1
SplitCount=$2
awk -v CN="10" -v File_name="file__" '{a++;if($0 ~ /^101/){if(s){ if(a>=CN){a=0;x++;fn=File_name""x;print s > fn;s=$0}else{print s > fn;s=$0}} else{s=$0;x++;fn=File_name""x;}} else{s=s"\n"$0;}}END{if(a>=CN){x++;fn=File_name""x};print s > fn}' ${SrcFileName}.txt

# 18  
Old 10-12-2012
Code:
SrcFileName=$1
SplitCount=$2


awk -v CN="$SplitCount" -v File_name="$SrcFileName" '{a++;if($0 ~ /^101/){if(s){ 
if(a>=CN){a=0;x++;fn=File_name""x;print s > fn;s=$0}else{print s > fn;s=$0}}
else{s=$0;x++;fn=File_name""x;}}
else{s=s"\n"$0;}}END{if(a>=CN){x++;fn=File_name""x};print s > fn}'file

Hope this helps youSmilie
This User Gave Thanks to pamu For This Post:
santosh2k2
# 19  
Old 10-12-2012
Thanks @pamu .. new code works and able to solve issue#2 in my earlier post. can you pls have a look at issue#1 in earlier post pls
# 20  
Old 10-12-2012
Quote:
Originally Posted by santosh2k2
can you pls have a look at issue#1 in earlier post pls
Code:
awk -v CN="$SplitCount" -v File_name="$SrcFileName" '{a++;if($0 ~ /^101/){if(s){ 
if(a>=CN){a=0;x++;fn=File_name"_"sprintf("%04d",x)".txt";print s > fn;s=$0}else{print s > fn;s=$0}}
else{s=$0;x++;fn=File_name"_"sprintf("%04d",x)".txt"}}
else{s=s"\n"$0;}}END{if(a>=CN){x++;fn=File_name"_"sprintf("%04d",x)".txt"};print s > fn}' file

OR using function..

Code:
awk -v CN="$SplitCount" -v File_name="$SrcFileName" '
function file_namec(){
    fn=File_name"_"sprintf("%04d",++x)".txt";
}
{a++;if($0 ~ /^101/){if(s){ 
if(a>=CN){a=0; file_namec();print s > fn;s=$0}else{print s > fn;s=$0}}
else{s=$0; file_namec()}}
else{s=s"\n"$0;}}END{if(a>=CN){file_namec()};print s > fn}' file

Last edited by pamu; 10-12-2012 at 10:46 PM..
This User Gave Thanks to pamu For This Post:
santosh2k2
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Web Development

Filename output in curl

How can I get the name of the default output filename from curl using the argument -O? Using -o one can choose a filename. I want to get the name of the original file, but don't understand how to get it. curl -o filename http://www.website.com curl -O http://www.website.com The... (3 Replies)
Discussion started by: locoroco
3 Replies

2. UNIX for Beginners Questions & Answers

Insert the line number from text file to filename output

Hi everyone :) I have a file "words.txt" containing hundreds of lines of text. Each line contains a slogan. Using the code below i am able to generate an image with the slogan text from each line. The image filename is saved matching the last word on each line. Example: Line 1: We do... (2 Replies)
Discussion started by: martinsmith
2 Replies

3. Shell Programming and Scripting

How to remove filename from output file?

Hello, I am trying to print searched multiple keywords in multiple files. It is almost okay with the code but the code puts filename in front of each line. How may I get rid of it? -grep -A1 'word1' *.txt | grep -A1 'word2' | grep -A1 'word3' I expect: Real outcome: How may I... (3 Replies)
Discussion started by: baris35
3 Replies

4. UNIX for Dummies Questions & Answers

Output a list of five books with their filename titles into one file

Dear unix forum, could I output a list of five books with their file name titles into one file? In order o output all the contents of all the files with their file names there was: find . -type f | while read x; echo -e "\n$x";cat "$x";done > бетховен.txt In spite of them being successively... (5 Replies)
Discussion started by: Xcislav
5 Replies

5. Shell Programming and Scripting

File splitter

I have below script which does splitting based on a different criteria. can it be amended to produce required result SrcFileName=XML_DUMP awk '/<\?xml version="1\.0" encoding="utf-8"\?>/{n++} n{f="'"${SrcFileName}_"'" sprintf("%04d",n) ".txt" print >> f close(f)}' $SrcFileName.txt My... (3 Replies)
Discussion started by: santosh2k2
3 Replies

6. Shell Programming and Scripting

Source xml file splitter

I have a source file that contains multiple XML files concatenated in it. The separator string between files is <?xml version="1.0" encoding="utf-8"?>. I wanted to split files in multiple files with mentioned names. I had used a awk code earlier to spilt files in number of lines i.e. awk... (10 Replies)
Discussion started by: santosh2k2
10 Replies

7. Shell Programming and Scripting

Text Splitter

Hi, I need to split files based on text: BEGIN DSJOB Identifier "LA" DateModified "2011-10-28" TimeModified "11.10.02" BEGIN DSRECORD Identifier "ROOT" BEGIN DSSUBRECORD Owner "APT" Name "RecordJobPerformanceData" Value "0" ... (16 Replies)
Discussion started by: unme
16 Replies

8. Shell Programming and Scripting

use input filename as an argument to name output file

I know this is a simple matter, but I'm new to this. I have a shell script that calls a sed script from within it. I want the output of the shell script to be based on the input file I pass as an argument to the original script. In other words... ./script.sh file.txt (script.sh calls sed... (2 Replies)
Discussion started by: estebandido
2 Replies

9. Shell Programming and Scripting

Filename from splitting files to have the same filename of the original file with counter value

Hi all, I have a list of xml file. I need to split the files to a different files when see the <ko> tag. The list of filename are B20090908.1100-20090908.1200_CDMA=1,NO=2,SITE=3.xml B20090908.1200-20090908.1300_CDMA=1,NO=2,SITE=3.xml B20090908.1300-20090908.1400_CDMA=1,NO=2,SITE=3.xml ... (3 Replies)
Discussion started by: natalie23
3 Replies

10. Shell Programming and Scripting

File splitter by nth row

I need to split a file into n separate files of about the same size. The way the file will be split is at every nth row, starting with the first row, that row will be cut and copied to it's corresponding new file so that each file has unique records. Any 'leftovers' will go into the last file. e.g.... (4 Replies)
Discussion started by: sitney
4 Replies
Login or Register to Ask a Question