Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Groups keyboard shortcuts have been updated

Dismiss

See shortcuts

replace string with values from a dictionary file

3 views

Skip to first unread message

unread,

Aug 6, 2009, 2:36:53 PM8/6/09

I have file 1 with one million rows. one of the fields is
"FIRSTNAME" (the string)

I have a second file with about 20 first names.

JUDE
DAVID
HOMER
CANE
ABEL
MARTY
CARL
SONNY
STEVE
BERT
OSCAR
MICKY
JAMES
JOHN
GLENN
DOUG
ERNIE
CECIL
KENNY
KEVIN
LARRY
MING
ROCKY
RONNY
GREGG

I want to either recursively, or randomly (it really doesn't matter)
replace "FIRSTNAME" with a value from the second line.

I know how to replace and space fill FIRSTNAME with MING, for example,
but then my whole document is full of MING.

I looked and couldn't find an answer to my conundrum... I have many
more operations to perform, but they are all of the same kind.

Thanks for your input.

Lionel

unread,

Aug 6, 2009, 2:47:08 PM8/6/09

Of course, I meant " with a value from the second file."

0 new messages