Sorry if this question has been posted elsewhere, but I'm hoping someone can help me! Bit of an AWK newbie here, but I'm learning (slowly!)
I'm trying to cobble a script together that will save me time (is there any other kind?), to swap two fields (one containing whitespace), with each field on different lines
As an arbitrary example (I'll explain as best as I can!):
Code:
ENTRANT LIST
Name Entry Type Fastest Time
--------------------------------------------
Andrew Cyclist 10:59 #(newline here)
Cyclist Mr. Smith has a great track record....
******************************
Chris Runner 45:12
Runner Mr. Jones has been an avid runner for....
******************************
Now my problem is this: I want to Switch $1 of the first line ("Andrew") with $2 of the second line ("Mr. Smith" [note whitespace]) to give me:
Code:
ENTRANT LIST
Name Entry Type Fastest Time
--------------------------------------------
Mr. Smith Cyclist 10:59 #(newline here)
Cyclist Andrew has a great track record....
******************************
Im assuming I'll need to use the *s as record separator and operate from there, but I'm coming up short on:
A) How to read two lines at once - presumably I will need a third area in memory to store one of the fields while the other is moved- should I create a temp file for this?
B) Avoiding having 'Mr. Smith' separated into two fields.
I'm trying to avoid creating two arrays if possible, but I can see this being the only way - does anybody have any suggestions about how I could approach this another way?
Sorry for all the questions - hopefully someone can help me out!
Hi
I have afile with 15fields,say f1,f2....f15 delimited on comma. How can i swap the f1,f15 fields using unix shell commands or any script?
Thanks (3 Replies)
I have a CSV file with a variable number of fields per record. How do I print lines of a certain number of fields only? Several permutations of the following (including the use of escape characters) have failed to retrieve the line I'm after (1,2,3,4)...
$ cat myfile
1,2,3,4
1,2,3
$ # Print... (1 Reply)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
The assignment is to convert a text table to csv format. I've got the cleaning up done, but I need to swap two... (0 Replies)
I've run into a problem getting exactly what I want out of awk - some folks may recognize this as an output from Amazon's ec2-describe-instances:
Given the following:
INSTANCE i-4960f321
BLOCKDEVICE Line2Var2
TAG instance i-4960f321 Name web1
TAG instance i-4960f321... (2 Replies)
Hi Friends ,
I have file1.txt
1|b|46|123|47673|348738
2|c|63|124|7346|4783
3|y|45|125|5555|78789
output should swap the 4th field to the first field.
output
123|1|b|46|47673|348738
124|2|c|63|7346|4783
125|3|y|45|5555|78789 (3 Replies)
I need a awk command to select from a log-file only the lines that have on the 2nd field (considering "|" separator) one of the values 10.216.22.XX or 10.216.22.YY or 10.216.22.ZZ and on the 4th field only values that contain strictly digits. I want the command to work parsing the file only once (I... (2 Replies)
Hallo Team,
This is the command that i am running :
grep ",Call Forward Not Reachable" *2013*
this is the output that i am getting (i did a head -10 but the files can be more than 1000)
... (8 Replies)
Hallo Team,
I would like to replace filed 4 and 7 with filed 39 how can i achieve this ?
-bash-3.2$ cat dip1.csv| cut -f4,7,24,36,39 -d","|sort -u
+27113996891,+27113996891,196.35.130.52,828854047,+27873500077
+27116452690,+27825702918,10.0.109.13:5060,+27116452690,+27116452690... (2 Replies)
In the awk below, what I am attempting to do is check each line in the tab-delimeted input, which has ~20 lines in it, for a keyword
SVTYPE=Fusion. If the keyword is found I am splitting $3 using the . (dot) and reading the portion before and after the dot in an array a.
If it does have that... (12 Replies)
Discussion started by: cmccabe
12 Replies
LEARN ABOUT FREEBSD
dotty
DOTTY(1) General Commands Manual DOTTY(1)NAME
dotty - A Customizable Graph Editor
SYNOPSIS
dotty [ -V ] [ file ]
DESCRIPTION
dotty is a graph editor for the X Window System. It may be run as a standalone editor, or as a front end for applications that use graphs.
It can control multiple windows viewing different graphs.
dotty is written on top of dot and lefty. lefty is a general-purpose programmable editor for technical pictures. It has an interpretive
programming language similar to AWK and C. The user interface and graph editing operations of dotty are written as lefty functions. Pro-
grammer-defined graph operations may be loaded as well. Graph layouts are made by dot, which runs as a separate process that communicates
with lefty through pipes.
USAGE
The file name is optional. If present, the graph contained in that file is displayed in the dotty window.
OPTIONS -V Prints the version.
SEE ALSO dot(1), lefty(1)
dotty user guide.
DOTTY(1)
04-16-2012
