Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need to Split the file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to Split the file
# 1  
Old 01-10-2011
Need to Split the file
hi,

i have the below file

file1.txt
Code:
vst_qp_vds_Fido_VT0220101029.txt
Active
 
vst_fact_cms_purchase_trans_20101015.dat
Active
 
vst_soc_activity_detail2_VT0120101028.dat
Active
 
vst_fact_api_cdr_VT0320101029.csv
Active

I need the below output.

output.txt
Code:
vst_qp_vds_Fido_VT0220101029.txt,Active
vst_fact_cms_purchase_trans_20101015.dat,Active
vst_soc_activity_detail2_VT0120101028.dat,Active
vst_fact_api_cdr_VT0320101029.csv,Active

Can you please help me out on this.
Thanks in advance.

Regards,
Siva
Last edited by Scott; 01-10-2011 at 06:49 AM.. Reason: Code tags, please...
# 2  
Old 01-10-2011
Code:
awk '!/^$/ {a=$0;getline;print a","$0}' file1.txt

If input file is strictly like below:
Code:
vst_qp_vds_Fido_VT0220101029.txt
Active

vst_fact_cms_purchase_trans_20101015.dat
Active

vst_soc_activity_detail2_VT0120101028.dat
Active

vst_fact_api_cdr_VT0320101029.csv
Active

i.e. filename 1st, then Active
# 3  
Old 01-10-2011
the above awk code working this this...
Code:
 
vst_warner_20101230_04:29:21.csv,
Active,
vst_qp_sony_20101230_04:56:25.csv,
Active,
vst_qp_mthly_stmg_20101230_05:49:15.txt,
Active,
vst_qp_emi_20101230_02:03:42.csv,
Active,

---------- Post updated at 06:08 AM ---------- Previous update was at 06:04 AM ----------

i want like this...
Code:
vst_qp_vds_Fido_VT0220101029.txt,Active
vst_fact_cms_purchase_trans_20101015.dat,Active
vst_soc_activity_detail2_VT0120101028.dat,Active
vst_fact_api_cdr_VT0320101029.csv,Active

Last edited by Scott; 01-10-2011 at 07:14 AM.. Reason: Code tags
# 4  
Old 01-10-2011
For input
Code:
vst_qp_vds_Fido_VT0220101029.txt
Active
 
vst_fact_cms_purchase_trans_20101015.dat
Active
 
vst_soc_activity_detail2_VT0120101028.dat
Active
 
vst_fact_api_cdr_VT0320101029.csv
Active

I get following as output:
Code:
vst_qp_vds_Fido_VT0220101029.txt,Active
vst_fact_cms_purchase_trans_20101015.dat,Active
vst_soc_activity_detail2_VT0120101028.dat,Active
vst_fact_api_cdr_VT0320101029.csv,Active

If you don't get this, then your input file may be little different. Please post that.
I assume that,
very 1st line is file name, next line is Active
3rd is empty.
4th line is file name, next line is Active

If your input file is OK, then please verify the command you are trying, if no clue, Please post the command you are trying.
This User Gave Thanks to anurag.singh For This Post:
rsivasan
# 5  
Old 01-10-2011
thru sed..
Code:
sed '/^$/d;N;s/\n/,/' inputfile > outfile

This User Gave Thanks to michaelrozar17 For This Post:
rsivasan
# 6  
Old 01-10-2011
Thanks this is working
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

sed awk: split a large file to unique file names

Dear Users, Appreciate your help if you could help me with splitting a large file > 1 million lines with sed or awk. below is the text in the file input file.txt scaffold1 928 929 C/T + scaffold1 942 943 G/C + scaffold1 959 960 C/T +... (6 Replies)
Discussion started by: kapr0001
6 Replies

2. Shell Programming and Scripting

How to split file into multiple files using awk based on 1 field in the file?

Good day all I need some helps, say that I have data like below, each field separated by a tab DATE NAME ADDRESS 15/7/2012 LX a.b.c 15/7/2012 LX1 a.b.c 16/7/2012 AB a.b.c 16/7/2012 AB2 a.b.c 15/7/2012 LX2 a.b.c... (2 Replies)
Discussion started by: alexyyw
2 Replies

3. Shell Programming and Scripting

Split file based on file size in Korn script

I need to split a file if it is over 2GB in size (or any size), preferably split on the lines. I have figured out how to get the file size using awk, and I can split the file based on the number of lines (which I got with wc -l) but I can't figure out how to connect them together in the script. ... (6 Replies)
Discussion started by: ssemple2000
6 Replies

4. Shell Programming and Scripting

awk to split one field and print the last two fields within the split part.

Hello; I have a file consists of 4 columns separated by tab. The problem is the third fields. Some of the them are very long but can be split by the vertical bar "|". Also some of them do not contain the string "UniProt", but I could ignore it at this moment, and sort the file afterwards. Here is... (5 Replies)
Discussion started by: yifangt
5 Replies

5. Shell Programming and Scripting

Split a file into multiple files based on first two digits of file.

Hi , I do have a fixedwidth flatfile that has data for 10 different datasets each identified by the first two digits in the flatfile. 01 in the first two digit position refers to Set A 02 in the first two digit position refers to Set B and so on I want to genrate 10 different files from my... (6 Replies)
Discussion started by: okkadu
6 Replies

6. Shell Programming and Scripting

Split File by Pattern with File Names in Source File... Awk?

Hi all, I'm pretty new to Shell scripting and I need some help to split a source text file into multiple files. The source has a row with pattern where the file needs to be split, and the pattern row also contains the file name of the destination for that specific piece. Here is an example: ... (2 Replies)
Discussion started by: cul8er
2 Replies

7. Shell Programming and Scripting

How to split a data file into separate files with the file names depending upon a column's value?

Hi, I have a data file xyz.dat similar to the one given below, 2345|98|809||x|969|0 2345|98|809||y|0|537 2345|97|809||x|544|0 2345|97|809||y|0|651 9685|98|809||x|321|0 9685|98|809||y|0|357 9685|98|709||x|687|0 9685|98|709||y|0|234 2315|98|809||x|564|0 2315|98|809||y|0|537... (2 Replies)
Discussion started by: nithins007
2 Replies

8. Shell Programming and Scripting

Split one file to Multiple file with report basis in unix

Hi, Please help on this. i want split the below file(11020111.CLT) to more files with some condition. :b: 1) %s stating of the report 2) %e ending of the report example starting of the report: %sAEGONCA| |MUMBAI | :EXPC|N|D ending of the report %eAEGONCA| |MUMBAI | :EXPC 3)so the... (10 Replies)
Discussion started by: krbala1985
10 Replies

9. Shell Programming and Scripting

Split large file and add header and footer to each file

I have one large file, after every 200 line i have to split the file and the add header and footer to each small file? It is possible to add different header and footer to each file? (1 Reply)
Discussion started by: ashish4422
1 Replies

10. UNIX for Dummies Questions & Answers

Split a file with no pattern -- Split, Csplit, Awk

I have gone through all the threads in the forum and tested out different things. I am trying to split a 3GB file into multiple files. Some files are even larger than this. For example: split -l 3000000 filename.txt This is very slow and it splits the file with 3 million records in each... (10 Replies)
Discussion started by: madhunk
10 Replies
Login or Register to Ask a Question