Greetings Experts,
I am generating a validation query through awk and facing an issue, which I need to overcome by splitting the data based on the pattern matching count in the value of an array.
Here Table11 can contain more than 100 columns with type as "d" or "o" which is specified in the last column i.e., there can be more than 100 entries in the combination of column1, column4, column7 there by making it more than 100 entries in the file. My awk script is
I am getting the output as below for the combination of Table11, Table21,d
But as there is a restriction that I cannot export more than 100 columns in a single select (Teradata Bteq export restriction), I need to break down the contents of array a in case if there are more than 100 entries based on the column1, column4, column7 i.e.,
I am confused on how to handle this with in awk as I need to complete this task with in awk as there are several tables involved which can be processed easily with the array structure in awk. At first I thought of using another array to count++ for column1, column4, column7 combination and write a loop; I need to think on this; or make another array in the combination of x[$1 OFS $4 OFS $7 OFS cnt++] where the variable cnt would be specific to each combination of $1 OFS $4 OFS $7; I am not sure how to do this as the array may not be processed in the increasing order of cnt for the combination of $1 OFS $4 OFS $7 Another alternative is to make a comparison on the contents of the array to check if there are more than 100 SUM(CASE If yes, then split them and process; I am stuck up badly on this and in need of your help greatly. Thank you for your time..
x[$1 OFS $4 OFS $7 OFS cnt++] does not make sense.
A counter for each col1,col4,col7 combination is cnt[$1 OFS $4 OFS $7]++ i.e. every cnt element is a counter.
Thank you for the suggestion. Creating one more array to count the combination of $1 OFS $4 OFS $7 and then I need to find a way to go through this algorithm
I don't know how to get the z to z+99 matching SUM(CASE from the array a with in the loop. Can someone kindly explain how to achieve this. Please note that storing every part of z to z+99 in another array++is not feasible for my script as that makes the script dependent on the data on the combination of $1 OFS $4 OFS $7
That was a hell of a specification to understand - not sure I did to its entirety. Anyway, try
Set the max No. of lines LNMX to 100 if happy with the result and dealing with your large files...
I have a huge file (around 4-5 GB containing 20 million rows) which has text like:
<EOFD>11<EOFD>22<EORD>2<EOFD>2222<EOFD>3333<EORD>3<EOFD>44<EOFD>55<EORD>66<EOFD>888<EOFD>9999<EORD>
Actually above is an extracted file from a Sql Server with each field delimited by <EOFD> and each row ends... (8 Replies)
In the below awk using the tab-delimited input, I am trying count the - symbol in $5 and output the count as well as the renamed condition ins. I am also count the - symbol in $6 and output the count as well as the renamed condition del. I am also count the tomes that in $5 and $6 there are... (6 Replies)
data.txt:
CRITICAL: iLash: 97.00%, SqlPlus: 99.00%. Warning/critical thresholds: 95/98%
I need to pull only the disknames:
iLash and SqlPlus
The following command will only pull iLash:
echo "CRITICAL: iLash: 97.00%, SqlPlus: 99.00%. Warning/critical thresholds: 95/98%" | awk -F":"... (7 Replies)
So I have a space delimited file that I'd like to split into multiple files based on multiple column values.
This is what my data looks like
1bc9A02 1 10 1000 FTDLNLVQALRQFLWSFRLPGEAQKIDRMMEAFAQRYCQCNNGVFQSTDTCYVLSFAIIMLNTSLHNPNVKDKPTVERFIAMNRGINDGGDLPEELLRNLYESIKNEPFKIPELEHHHHHH
1ku1A02 1 10... (9 Replies)
KSH
HP-SOL-Lin
Cannot use xAWK
I have several strings that are quite long and i want to break them down into smaller substrings.
What I have
String = "word1 word2 word3 word4 .....wordx"
What I want
String1="word1 word2"
String2="word 3 word4"
String3="word4 word5"
Stringx="wordx... (5 Replies)
HI Guys,
I need to split the file in to number of files . file contains FILEHEADER and EOF . I have to split n number of times . I have to form the file with each splitted message between FILEHEADER and EOF using awk beign and end . how to implement please suggest. (2 Replies)
Hi,
can some one please help me to split the file based on groups.
like in the below scenario x indicates the begining of the group and the file should be split each with 2 groups below there are 10 groups it should create 5 files. could you please help? (4 Replies)
Hi
I am having files with date and time stamp as the folder names like 200906051400,200906051500,200906051600 .....hence everyday 24 files will be generated
i need to do certain things on this 24 files daily
file contains the data like
200906050016370 0 1244141195225298lessrv3 ... (13 Replies)
Hi All,
Can someone please help me write a script for the following requirement in awk, grep, sed or perl.
Buuuu xxx bbb
Kmmmm rrr ssss uuuu
Kwwww zzzz ccc
Roooowwww eeee
Bxxxx jjjj dddd
Kuuuu eeeee nnnn
Rpppp cccc vvvv cccc
Rhhhhhhyyyy tttt
Lhhhh rrrrrssssss
Bffff mmmm iiiii
Ktttt... (5 Replies)
I have the file with the records like
4234234 US phone
3244234 US cup
2342342 CA phone
8947234 US phone
2389472 CA cup
2348972 US maps
3894234 CA phone
I want the records with (US,phone) as record to be in one file, (Us, cup) in another file and (CA,cup) to be in another
I mean all... (12 Replies)