10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Greetings Experts,
I have an excel file and I am unable to read it directly into awk (contains , " etc); So, I cleansed and copied the data into notepad.
I need to generate a script that generates the SQL.
Requirement:
1. Filter and select only the data that has the "mapping" as "direct"... (4 Replies)
Discussion started by: chill3chee
4 Replies
2. Shell Programming and Scripting
I am trying to check my logic on a long awk i'm using. I have about 30 checks that I built into an awk and I "believe" I did this right, but I could be wrong.
awk -F\| '
$9 !~ /\/*{1,}*/
$9 ~ /\(-{4}, {2,3}/
$9 ~ /\({6}, {2,3}\)/
$9 ~ /\(\+{5}, {2,3}\)/
$9 ~ /\(\+\+{4}, {2,3}\)/
$9 ~... (8 Replies)
Discussion started by: dagamier
8 Replies
3. Shell Programming and Scripting
Hello
I want to achieve the following.
However the concatenation is not working
mv `ls -ltr *myfile*.log|awk '{print $9}'` `ls -ltr *myfile*.log|awk '{print `date +'%d%m%y%k%M%S'` $9}'`
I tried
awk '{x=`date +'%d%m%y%k%M%S'` print $x "" $9}'
awk '{x=`date +'%d%m%y%k%M%S'`... (2 Replies)
Discussion started by: Chetanz
2 Replies
4. Shell Programming and Scripting
Hi friends, I am having 2 files, I just want to compare 2 files each containing 2 columns 1st column is lat, and 2nd column is long, if anyone can understand below logic please help me in writing script with awk.. here each field of file2 needs to be compared with std_file
main
counter=0... (1 Reply)
Discussion started by: Akshay Hegde
1 Replies
5. UNIX for Dummies Questions & Answers
Hello,
I have a table as shown below. I want to concatenate values in col2 and col3 based on a value in col4.
1 X Y A
3 Y Z B
4 A W B
5 T W A
If col4 is A, then I want to concatenate col3 with itself. Otherwise it should concateneate col2 with col3.
1 X Y YY
3 Y Z YZ... (10 Replies)
Discussion started by: Gussifinknottle
10 Replies
6. Shell Programming and Scripting
Hi All
I have the data as
id-number 01
name-id x0 input-id x0 output-id x0
name-id x0 input-id x0 output-id x0
name-id x0 input-id x0 output-id x0
id-number 02
name-id x0 input-id x0 output-id x0
name-id x0 input-id x0 output-id x0
name-id x0 input-id x0 output-id x0
.
.
I... (4 Replies)
Discussion started by: posner
4 Replies
7. UNIX for Dummies Questions & Answers
I have task to find out the min,max, average value of each service for example i searched for " StatementService "
$awk '/VST.*StatementService:/{print $3,$4,$19,$22,$25}' performance.log > smp.log
$cat smp.log
amexgtv VST: : StatementService:1860 StatementService:getCardReference:0... (3 Replies)
Discussion started by: senthil.ak
3 Replies
8. Shell Programming and Scripting
In one data file i have values like this
a b c 1 2
e f g 2 3
i j k 3 5
I need to sum up the last 2 columns and make a data file...How i can do that.
a b c 1 2
e f g 2 3
i j k 3 5... (8 Replies)
Discussion started by: bobprabhu
8 Replies
9. Shell Programming and Scripting
I want to print lines that have "IND" or "ind" or nothing in field 2 or 3
file:
output needed:
Code i wrote:
nawk -F"," '{if(tolower($2||$3) ~"ind"||"")print}' file
Help is appreciated (3 Replies)
Discussion started by: pinnacle
3 Replies
10. Shell Programming and Scripting
Hello Friends,
I have a txt file like below
//*Init Start
Reg(read,12'h42E,16'h0000);
Nop(5628.5);
//*Init End
//*Main Start
Reg(read,12'h42E,16'h0000);
Nop(5628.5);
//*Main End
I want to calculate the values between //* Init Start & //* Init End
And //*Main Start & //*Main... (5 Replies)
Discussion started by: user_prady
5 Replies