Search Results

I got it to work with mawk.

mawk "{x[$1] = x[$1] ? x[$1]""\" \"$2 : $2} END {for(i in x) print i, x[i]}" example_01.txt

I introduced \" \" before the first $2

Thanks again for the starter...

Thanks Shamrock,

I am not getting spaces between all of the dates.
I get:

1001 2001_01_01
1002 2001_01_012002_02_02
1003 2001_01_012002_02_02
1004 2001_01_01
1005 2001_01_01
1006...

I have a 2 column file.
Column 1 is a road ID number.
Column 2 is the date that the road surface condition was inspected.
Some roads have been inspected only once, while some roads have been...

Thanks for the pointer Jim

got that part to work on my file

example InFile:

OtherText
OtherText
ThatText
FollowedByThisText
OtherText
ThisText
OtherText
OtherText
ThisText
OtherText...

How do you instruct sed to perform edits starting at a user defined record?

File_1 looks like:

bunch of text
Untitled Placemark
bunch of text
bunch of text
Untitled Placemark
bunch of text
bunch of text
Untitled Placemark
bunch of text

File_2 looks like:
...

Does anyone have an awk script that converts/translates an ascii .csv file to a Google Earth .kml file?

The .csv would typically look like:
...

does anyone have an awk one-liner to:

print the first line, the second line, then every Nth line, and the last line of a file.

Thanks,
Kenny.

actually I have a constant word at the beginning of each file name.
example: filename_
ls | sort -n is not working on my list of files.
I still get:
filename_1
filename_10
etc
instead of:...

How do you sort filenames: 1 2 3 4 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 21
as:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

example input file:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

Gentlemen,

I thank you very much for your efforts in try to helping me with this code.

As I said, note that I am working in a Microsoft Windows XP command prompt window environment. Not sure if...

Jim,

Thank you for your efforts in this matter.

I should add that my OS is Microsoft Windows XP.

Not sure if this will have any effect on your syntax.

I am actually using mawk.

I...

Thank you.

Jim,

{$1$2} was a typo.

rdcwayx,

My files are not Latitude Longitude Degrees, but State Plane Feet.
They typically contain 3 million records.

A file looks like, PointNumber...

TextPad

I have a large ascii file of 3+ million records.
The data type is easting northing elevation coordinates.
The file format is 3 fields, a numeric value for:
easting northing elevation

When I...

I need a one liner to"

find /pattern/

print from x lines before "pattern" to y lines after "pattern"

I need a one-liner that will output characters 23 through 32 from a user defined record.

Thanks,
Kenny.

I have this:

\2009_may\05-04-2009\05-04-2009(74)
\2009_may\05-04-2009\05-04-2009(74)\05-04-2009(74)_0-999
\2009_may\05-04-2009\05-04-2009(74)_left...

can you make me an awk script that will:

read the 1st record from each input file, file1 file2 file3 file4 and file5 and write them to file6.

then.....

read the 2nd record from each input...

I have two files and would like a report of where they match.

Example of file1:

1 1 1
2 2 2
13 14 15
4 4 4
15 16 17
100 102 1004
56 57 890

Example of file2:

2 2 2
16 10 11
45 22...

I have a file that contains hundreds of lines such as:

this_is_macro,000001
this_is_macro,000002
this_is_macro,000003

I would like to add the variable words

MACROBEGIN MACRO_000001...

I have:

aa01
aa02
aa03
aa04
ab01
ab02
ab03
ab04

I would like each record printed 5 times:

aa01
aa01
aa01
aa01
aa01
aa02
aa02

Thanks era,

The fgrep doesn't produce the desired result.
I think it might require the input files to be sorted first.

Your first sed code works.
In my example files you can see that file 2...

file_in_1:

1 2 3 4
5 6 7 8
9 10 11 12
13 14 15 16
17 18 19 20
21 22 23 24
25 26 27 28
29 30 31 32

file_in_2:

9 10 11 12
21 22 23 24
1 2 3 4
17 18 19 20

file_out: