Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


How to split a dat file based on another file ni UNIX?


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
How to split a dat file based on another file ni UNIX?

i have two files , one is var.txt and another res.dat file

var.txt contains informaton like below
Code:
date,request,sales,item

20171015,1,123456,216

20171015,1,123456,217

20171015,2,345678,214

20171015,3,456789,218

and res.dat contains is a one huge file contains information like below
Code:
RTCCVB01 213456 123456 216

.

.

.

.

.

.

VBPCVB01

RTCCVB01 213456 345678 214

.

.

.

.

.

.

VBPCVB01

RTCCVB01 213456 123456 217

.

.

.

.

.

.

VBPCVB01

RTCCVB01 213456 456789 218

.

.

.

.

.

.

VBPCVB01

For a unique request i have to create a separate dat file, for example

for Request 1

123456.dat
Code:
RTCCVB01 213456 123456 216

.

.

.

.

.

.

VBPCVB01

RTCCVB01 213456 123456 217

.

.

.

.

.

.

VBPCVB01

for Request 2 345678.dat
Code:
RTCCVB01 213456 345678 214

.

.

.

.

.

.

VBPCVB01

for Request 3 456789.dat
Code:
RTCCVB01 213456 456789 218

.

.

.

.

.

.

VBPCVB01

sales occur at 50-56 position in res.dat file item occur at 72-79 position in res.dat file

i have to write a shell script which will do below for each unique request from var.txt it will take sales and item and extract information from res.dat and will be creating separate dat files till all request number is done .

Last edited by vbe; 05-01-2017 at 05:28 AM.. Reason: code tags please
# 2  
Ignoring that there's neither positions 50-56, nor 72-79, and the Request-No doesn't occur anywhere in your output, i.e. the first file is never used, try
Code:
awk '
/^RTCC/         {FN = $3 ".dat"
                }
                {print > FN
                }
'  res.dat

Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
How to split file into multiple files using awk based on 1 field in the file?
alexyyw
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...... Shell Programming and Scripting
2
Shell Programming and Scripting
Split file based on file size in Korn script
ssemple2000
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. ...... Shell Programming and Scripting
6
Shell Programming and Scripting
Split a file into multiple files based on first two digits of file.
okkadu
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...... Shell Programming and Scripting
6
Shell Programming and Scripting
Performance issue in UNIX while generating .dat file from large text file
KRAMA
Hello Gurus, We are facing some performance issue in UNIX. If someone had faced such kind of issue in past please provide your suggestions on this . Problem Definition: /Few of load processes of our Finance Application are facing issue in UNIX when they uses a shell script having below...... Shell Programming and Scripting
19
Shell Programming and Scripting
How to attach an excel file/ dat file thru unix mails
diwakar82
Hi. I want to attach a .xls or .dat file while sending mail thru unix. I have come across diff attachments sending options, but allthose embeds the content in the mail. I want the attachement to be send as such. Please help me out. regards Diwakar... Shell Programming and Scripting
1
Shell Programming and Scripting

Featured Tech Videos