10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello everyone!
I have thousands of csv files I have to import into a Database table. As usually the files aren't perfect. For example they have a different number of columns and some weird columns.
The second problem is, that I have to add 3 parts of the filename into 3 rows in the... (6 Replies)
Discussion started by: elRonaldo
6 Replies
2. Shell Programming and Scripting
Hi Guys,
i world like to do the following with awk,
i have the the complete username
example in a file a have some names
Mario Rossi
John Doe
i would like to convert this name in this format from file with awk
Mario,Rossi,"Mario Rossi ",m.rossi_ext@mydomain.com,$TRUE,
John,Doe,"John... (7 Replies)
Discussion started by: charli1
7 Replies
3. Shell Programming and Scripting
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
4. Shell Programming and Scripting
Hi All,
I want to modify(changing the status from "on" to "off" status of Stage-element value from the below xml file using sed or awk:
File Name: global.xml
<?xml version="1.0" encoding="UTF-8"?>
<config>
<widget>
<name>HTTP-POOL</name>
<attributes>
... (5 Replies)
Discussion started by: wamqemail2
5 Replies
5. Shell Programming and Scripting
I have text file with lines as shown here. Each row has 11 columns separated by tab. In each row, i want to split the 8th column such that the output should look like shown below. Here value in the 9th column is DP value and in the 10th column is MQ value followed by the values after resource.EFF=.... (15 Replies)
Discussion started by: mehar
15 Replies
6. Shell Programming and Scripting
awk "BEGIN {if($PERCENT<$WARNING)
{print \"OK\" ; exit 0}
else if(($PERCENT>=$WARNING) && ($PERCENT<$CRITICAL))
{print \"WARNING\" ; exit 1}
else if($PERCENT>=$CRITICAL)
{print \"CRITICAL\" ; exit 2}
}"
how can i... (1 Reply)
Discussion started by: SkySmart
1 Replies
7. Shell Programming and Scripting
Hello,
I have 2 files. One has a list of serial numbers:
12345_7
2345_9
35454
4759:1
PEP8794
The other is an excel file, with multiple columns, separated by tab:
12345_7 ... ... .. .. .. .. ..
2345_9 ... ... .. .. .. .. ..
35454 ... ... .. .. .. .. ..
4759:1 ...... (4 Replies)
Discussion started by: ad23
4 Replies
8. Shell Programming and Scripting
Hi *
I've just wanted to ask you if it's possible to modify the input file by using awk.
Let me explain what I need:
I need to change the value $4 from "defaults" to "nodev" in my text file. I've tried to use a string function called "sub" and it works. But I can't figure it out how to... (6 Replies)
Discussion started by: martinp111
6 Replies
9. Linux
Ok, so I have this script that was provided to me by one of the posters on this site.
This script seems to be perfect. However, since this is a telnet script, i need to add an if then statement to it but dont know how to do it.
What i want to do is to have this script spit out a certain... (3 Replies)
Discussion started by: SkySmart
3 Replies
10. Shell Programming and Scripting
I have a file, a.asc which is generated from a shell script:
-----BEGIN PGP MESSAGE-----
Version: PGP 6.5.8
qANQR1DBwE4DR5PN6zVjZTcQA/9z5Eg94cwYdTnC7v+JUegQuJwHripqnyjFrEs/ejzKYCNmngbHHmf8V4K3uFkYyp74aFf+CdymA030RKs6ewOwkmqRW19oIXCgVe8Qmfg+/2KTq8XN
=0QSP
-----END PGP MESSAGE-----
I want... (12 Replies)
Discussion started by: nattynatty
12 Replies