10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
I have two (2) things that I want to do.
First is to change the date format that is in the nth field from MM/DD/YY to YY/MM/DD. Preferably, I wish I know how to make it a 4-digit year but I don't. Problem is I can only assume it is a 20 century
Second is somehow know how to figure out... (1 Reply)
Discussion started by: newbie_01
1 Replies
2. Shell Programming and Scripting
I have posted this again as old post is closed and I am not able to reopen. so please consider this new post
Input File :
1,A,Completed,06.02_19.36,Jun 30 20:00
2,BBB,Failed,07.04_05.12,Jul 21 19:06
3,CCCCC,New,07.21_03.03,Jul 26 12:57
4,DDDDD,Pending,,
I wast output file as:
... (7 Replies)
Discussion started by: Amit Joshi
7 Replies
3. Shell Programming and Scripting
$ cat /cygdrive/d/Final2.txt
1,A ,Completed, 07.03_23.01 ,Jun 30 20:00
2,BBB,Pending,,
3,CCCCC,Pending,,
4,DDDDD,Pending,,
5,E,Pending,,
6,FFFF,Pending,,
7,G,Pending,,
In the above file 4th field is date which is in MM.DD_HH.MIN format and I need to convert it to as it is there in 5th... (1 Reply)
Discussion started by: Amit Joshi
1 Replies
4. Shell Programming and Scripting
Using Awk, how can I achieve the following?
I have set of record numbers, for which, I have to replace the nth field with some values, say spaces.
Eg:
Set of Records : 4,9,10,55,89,etc
I have to change the 8th field of all the above set of records to spaces (10 spaces).
Its a delimited... (1 Reply)
Discussion started by: deepakwins
1 Replies
5. Shell Programming and Scripting
Hello
I was working on a script where the output of my file is
1234
4567
8973
43214
78965
I need the value in below format of this file.The nth field should have space instead of ,(comma)
1234,4567,8973,43214 78965
I tried the code but not working completely
xargs <temp_PP.7250... (3 Replies)
Discussion started by: anuragpgtgerman
3 Replies
6. UNIX for Dummies Questions & Answers
Hey,
I'm sure this is answered somewhere but my Googling has turned up nothing. I have a file with data in the following format:
<desription of event> at <time and date>The desription of the event is variable length and hence when the list is displayed it is hard to easily see the date (and... (8 Replies)
Discussion started by: RECrerar
8 Replies
7. Shell Programming and Scripting
How do I do the product of nth filed just like sum. For sum I know like
awk '{ sum += $12 } END {printf "%.2f\n", sum}'
works as initial sum = 0.
But for product how do initialize the variable to 1? (2 Replies)
Discussion started by: madhavb
2 Replies
8. UNIX for Dummies Questions & Answers
Hi !
input:
111|222|333|aaa|bbb|ccc
999|888|777|nnn|kkk
444|666|555|eee|ttt|ooo|ppp
With awk, I am trying to change the FS "|" to "; " only from the 4th field until the end (the number of fields vary between records).
In order to get:
111|222|333|aaa; bbb; ccc
999|888|777|nnn; kkk... (1 Reply)
Discussion started by: beca123456
1 Replies
9. Shell Programming and Scripting
Hi,
Is there any short method to print from a particular field till another filed using awk?
Example File:
File1
====
1|2|acv|vbc|......|100|342
2|3|afg|nhj|.......|100|346
Expected output:
File2
====
acv|vbc|.....|100
afg|nhj|.....|100 (8 Replies)
Discussion started by: machomaddy
8 Replies
10. Shell Programming and Scripting
I have a large csv file that looks like this:
The 3rd field is a unix time stamp that I want to convert to human readable.
I wrote a bash script with this code:
IFS=$','
cat $1 | while read ID user DATE text flags read; do
echo -e "$ID,$user,$(date -d @$DATE),$text,$flags,$read... (3 Replies)
Discussion started by: stumpyuk
3 Replies