Hi Daptal, Kurumi,Rdcwayx,
Thanks for your reply.
All it works.
However, sometimes my raw files will have different missing columns which is not predicatable.Then how to make codes more flexible.
Possible of missing column of the raw files:
-->is the good raw files.
--> missing "nomsgnotdeliver"
--> missing "nomsgsent,nomsgnotdeliver" columns
--> missing "date and nomsgnotdeliver" columns
Thanks,
Natalie
---------- Post updated 03-26-10 at 03:56 AM ---------- Previous update was 03-25-10 at 09:15 PM ----------
I have tried:
but I just have:
Anyone have any good idea how to solve this problem?
Last edited by natalie23; 03-26-2010 at 06:02 AM..
I have a CSV file that is missing quotes around a column that contains text with commas. Example:
Column1, Column2, Column3, Column4, Column5, Column6
Data1, Data2, Data3, Data, 4, Data5, Data6
Data1, Data3, Data3, Data, text, 4, Data5, Data6
I think the easiest way for me to fix this is to... (2 Replies)
Hello everyone!!
I am not completely new to shell script but I havent been able to find the answer to my problem and I'm sure there are some smart brains here up for the challenge :D.
I have several CSV files that I need to combine into one, but I also need to know where each row came from.... (7 Replies)
Hi,
I have a input file with many records as below:
1J4RR4GG0BC508200 68646 1 N M
i want my output file to be like with columns included dgismdh and timestamp :
Example:
1J4RR4GG0BC508200 68646 1 N M dgismdh 2012-02-21 07:22:25.98591
How to do it.can we do using awk?
Pls help. (6 Replies)
please help!!!!!!
I have a file .txt that has only one column like that:
34.1
35.5
35.6
45.6
...
Now, i want to add a column in the left in which the values of this column increase by 0.4 , for example:
0.0 34.1
0.4 35.5
0.8 35.6
1.2 45.6
How can i do with awk instructions??? ... (2 Replies)
Let me start off by saying I am a self taught sometimes scripter so what you will see below won't be pretty.
I have created a script to parse through a file with a large amount of data and simply pull out what I need. In doing this I create several files and then paste them together in order to... (2 Replies)
Hello to all,
I have show below a file separated by commas. In first column has numbers where the last number is 13.
1,4
2,6
3,7
5,2
6,5
7,5
8,65
9,10
11,78
13,2
What I want to know is which numbers are missing from 1 to 13 (in this case 13 is last number in column 1). My real... (17 Replies)
Hi All:
I need your help please.
I have a include file *.awk , and I would want to know if it's there a option's awk where I can use this file include, for example:
awk -f decodifica_bitmap.awk cadena_hex.txt -e /home/snh/Awk/include/funciones.awk > sal.out
it give error:
awk:... (1 Reply)
Dear all,
I am kindly seeking assistance on the following issue.
I am working with data that is sampled every 0.05 hours (that is 3 minutes intervals) here is a sample data from the file
5.00000 15.5030
5.05000 15.6680
5.10000 16.0100
5.15000 16.3450
5.20000 16.7120
5.25000... (4 Replies)
Hi,
I am trying to incorporate 2 functions into my `awk` command.
I want to lower case Column 2 (which is essentially the same information in Col1, except in Col1 I want to maintain the capitalization) and I want to count from 0-N that begins and ends with the start of certain markers that I... (6 Replies)