Sponsored Content
Top Forums Shell Programming and Scripting split input data file and put into same output file Post 302514461 by rasmith on Saturday 16th of April 2011 11:11:08 AM
Old 04-16-2011
Need to split the data in multiples of 25 with left over data of the ID in the same CSV file as given below and not N files of 25.

Code:
Start of Report    20110224~
227050994    20110224               
13    227050994    LALN3819959    2089851292    2085254977    20110224
.
.
13    227050994    LFLN3449126    2082113563    2082113396    20110224
~End of Report    227050994    19           
Start of Report    20110224~               
232510151    20110224               
283    232510151    LALC3914497    152469347    152466752    20110224
.
.
.
283    232510151    LBWM3183936    1905799142    1905773331    20110224
~End of Report    232510151    25           
Start of Report    20110224~               
232510151    20110224               
283    232510151    LBWW2842523    1752698299    1752690888    20110224
.
.
283    232510151    LDND3387092    1474815506    1474814211    20110224
~End of Report    232510151    25           
Start of Report    20110224~               
232510151    20110224               
283    232510151    LHSS3133014    1793433382    1793513907    20110224
.
.
283    232510151    LFLV3454969    1514942972    1514279499    20110224
~End of Report    232510151    25           
Start of Report    20110224~               
232510151    20110224               
283    232510151    LFMY3455276    1943464440    1943466154    20110224
.
.
283    232510151    LFST3462358    1425672593    1425672226    20110224
~End of Report    232510151    4           
Start of Report    20110224~               
232510151    20110224

Thanks
Rasmith

---------- Post updated 04-16-11 at 10:11 AM ---------- Previous update was 04-15-11 at 05:16 PM ----------

hi David,

Can you please explain your script.

Thanks,

Rasmith

Last edited by Franklin52; 04-16-2011 at 08:55 AM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replacing data of output file with input

Hi, I have a ksh which peocess and get me data from 3 days... ie if i process it on jan 28.. it gets data for 25, 26 and 27.... the process run every day and get previous 3 days data...all this data is appened to a file lets call time.out Now time.out cannot have deplicate data so what i want... (10 Replies)
Discussion started by: bhagya2340
10 Replies

2. UNIX for Dummies Questions & Answers

I want some selected data from first file and put into other file in specified format

I have a file with follwing content ---------------------------------- SCHEDULE XXXXXXXXX#JOBCOUNT ON EVERYDAY AT 0000 PRIORITY 50 SCHEDULE XXXXXXXXX#ABCDEFGH ON EVERYDAY AT 0001 PRIORITY 29 SCHEDULE... (5 Replies)
Discussion started by: shreyas
5 Replies

3. Shell Programming and Scripting

Need script to take input from file, match on it in file 2 and input data

All, I am trying to figure out a script to run in windows that will allow me to match on First column in file1 to 8th Column in File2 then Insert file1 column2 to file2 column4 then create a new file. File1: 12345 Sam 12346 Bob 12347 Bill File2:... (1 Reply)
Discussion started by: darkoth
1 Replies

4. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies

5. Shell Programming and Scripting

How to add data from 2 input files and save it in 1 output file

Hi, i have 2 input files which are file1.txt and file2.txt. I need to extract data from file1.txt and file2.txt and save it in file3.txt like example below:- File1.txt ID scrap1 Name scrap1 start 1 end 10 ID scrap2 Name scrap2 start 11 end ... (4 Replies)
Discussion started by: redse171
4 Replies

6. Shell Programming and Scripting

adding data in input file if 2nd script output SUCCESS

Hi All, how can i edit my original data and add more data if my 2nd script outputs SUCESS? ex. input file: 1.txt nik,is,the 1script.sh if 2ndscript.sh output SUCCESS then i'm going to edit my input file and add data best,pogi.. sample outputdata. nik,is,the,best,pogi 2ndscript.sh... (3 Replies)
Discussion started by: nikki1200
3 Replies

7. Shell Programming and Scripting

Get Data From CSV File and put into a txt file

Hi Guys, File A I have File A as CSV Format.... No R SS MK Par value S AL A1 PKL123 Lo12 1 S AL A2 PKl123 Lo34 22 S AL A3 PkLK234 Lo67 -34 S AL A4 PkLK235 Lo09 120 S AL A5 PkLK236 Lo76 19 S AL A6 PkLK237 Lo44 -17 S AL A7 PkLK238 Lo90 2 S AL A8 PkLK239 Lo34 -9 I want file B like... (4 Replies)
Discussion started by: asavaliya
4 Replies

8. Shell Programming and Scripting

Split: File into multiple and keeping the same 3 lines from input into all output files

The following code will split the infile into multiple files. However, I need it to insert the same first 3 lines from the original input file into each splitted file. How do I modify my script below to do so: print -n "Enter file name to split? " ; read infile if then echo "Invalid file... (4 Replies)
Discussion started by: mrn6430
4 Replies

9. Shell Programming and Scripting

awk to reformat output if input file is empty, but not if file has data in it

The below awk improved bu @MadeInGermany, works great as long as the input file has data in it in the below format: input chrX 25031028 25031925 chrX:25031028-25031925 ARX 631 18 chrX 25031028 25031925 chrX:25031028-25031925 ARX 632 14... (3 Replies)
Discussion started by: cmccabe
3 Replies

10. Shell Programming and Scripting

Extract data from a log file and put it in a file

Hi, I would like to seek your help for a script that will extract data from log file and put it in a file. Sample log file 2018-10-23 12:33:21 AI ERROR -- tpid: SAMPLE_TH account: 123456789 aiSessionNumber: 660640464 mapName: xxx to yyy errorDesc: Translation Error:ErrorNumber : 993 ... (2 Replies)
Discussion started by: neverwinter112
2 Replies
df_vxfs(1M)															       df_vxfs(1M)

NAME
df_vxfs: df - report number of free disk blocks on a VxFS file system SYNOPSIS
[special|directory]... DESCRIPTION
prints the number of free blocks and free inodes in VxFS file systems or directories based on the counts kept in the super-blocks. VxFS dynamically allocates inodes from a pool of free blocks. The number of free inodes and blocks reported by is an estimate based on the number of free 8K or larger extents and the current ratio of allocated inodes to allocated blocks. (Extents smaller than 8K may not be usable for all types of allocation, so does not count free blocks in extents smaller than 8K.) Allocating additional blocks may therefore decrease the count of free inodes and vice versa. If the operand to is a special device name, the file system can be an unmounted or mounted file system (for example, If you specify a directoryname, displays information for the file system at that mount point. If neither special nor directory is specified, the free space on all of the mounted file systems is printed. Options recognizes the following options: Report only the number of kilobytes free. Report the number of files free. Report only an actual count of the blocks in the free list (free inodes are not reported). When this option is specified, reports on raw devices. Specify the file system type Report the entire statvfs(2) structure. Report the total number of inodes, the number of free inodes, number of used inodes and the percentage of inodes in use. Report the allocation in kilobytes. Report on local file systems only. Report the file system name. If invoked with no other options this option prints a list of mounted file system types. Print the number of free extents of each size. Free extents are always an integral power of two in length, ranging from a minimum of one block to the maximum extent size supported by the file system. Report the total allocated block figures and the number of free blocks. Report the percentage of blocks used, the number of blocks used and the number of blocks free. This option cannot be used with other options. Echo the completed command line, but performs no other action. The command line is generated by incorporating the user-specified options and other information derived from This option allows the user to verify the command line. There are a number of options that specify output formats, some combinations of which are incompatible. If an incompatible combination is specified, one of the options will override the other(s). Operands recognizes the following operands: directory Name of the mount point from which the VxFS file system is accessed. special Device name, which contains a mounted or unmounted VxFS file system. EXAMPLES
Report the number of free disk blocks for all mounted file systems: Report the number of free extents of each size, for all mounted VxFS file systems: Report the number of free files for all mounted VxFS file systems: Report the total allocated block figures and the number of free blocks, for all mounted file systems: Report the total allocated block figures and the number of free blocks, for the file system mounted as FILES
File-system devices. File-system devices. Static information about the file systems. mounted-file-system table. SEE ALSO
du(1), df(1M), fsck_vxfs(1M), statvfs(2), fs_vxfs(4), mnttab(4). STANDARDS CONFORMANCE
: SVID2, XPG2, XPG3 df_vxfs(1M)
All times are GMT -4. The time now is 03:30 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy