awk script for changing a constant string in all rows with a variable string

[Inter_1]

Hi,

I have one file "test" and another file "range". See below the data. I want to create another file as below called RESULT that the constant data 0000 in first column to be replaced with 0001 for the first row, 0002 for the second row and so on.

test
------------------
'0000', '490685'
'0000', '490686'
'0000', '490687'
.
.
.

range
-------------------
0001
0002
0003
.
.
.
8621

RESULT
---------------------
'0001', '490685'
'0002', '490686'
'0003', '490687'
.
.
.


Thanks,
Andy

[James R. Ferguson]

Hi Andy:

# paste -d " " range test |awk '{print $1,$3}' > RESULT

...by the way, file's name simply 'test' are a not-so-good idea.

Regards!

...JRF...

[Inter_1]

Thank you for your quick response.

The result is not the expected:

after your script
------------------
0001 '490685'
0002 '490686'
0003 '490687'

requested
----------------
'0001', '490685'
'0002', '490686'
'0003', '490687'


Thanks,
Andy

[Heiner E. Lennackers]

paste -d " " range test | awk -v X="'" '{print X $1 X ", " $3}' > RESULT

[James R. Ferguson · Accepted solution]

Hi (again) Andy:

OK, I see, you want the first column encapsulated in single quotes.

# paste -d " " ranger tester|awk '{print "\""$1"\""","$3}'|sed -e s/\"/\'/g

Regards!

...JRF...

[James R. Ferguson]

Hi (again) Andy:

Actually, for your requirement, I find Perl more straightforward:

# paste -d " " ranger tester|perl -nale 'print join ",","\047$F[0]\047",$F[2]'

...where \047 is the octal representation of a single quote.

Regards!

...JRF...

[Inter_1]

Thank you guys