String manipulation: cut, insert, column editing...

T

Toki Toki

Hi all,

Is it possible to use ruby like awk, sed or cut in unix to editing
strings?

Let say I have to write INSERT query like this:

This is the first (1°) item.
This is the second (2°) item.
This is the third (3°) item.
...

In one file I have the word-number (first, second, third) and in another
file I have the real number (1°, 2°, 3°) of the item, both on each line.

Of course, I don't want to really write it, so how can I "edit" the
number of the item dinamically? I've tried with regex, but I haven't
found a solution...

I think that with some text editors maybe it's possible to do that, but
I would like to know if with ruby the result can be achieved easier.

Let me know.

Thanks.

Best regards.
 
S

Shashank Agarwal

Toki said:
Let say I have to write INSERT query like this:

This is the first (1°) item.
This is the second (2°) item.
This is the third (3°) item.
...

I don't think this would be the best solution, but you could map 1 =>
"first"... and then use regex to identify the number and get its mapped
value. Problem is that it runs one way and limited.
 
E

Eric I.

Hi all,

Is it possible to use ruby like awk, sed or cut in unix to editing
strings?

Let say I have to write INSERT query like this:

This is the first (1°) item.
This is the second (2°) item.
This is the third (3°) item.
..

In one file I have the word-number (first, second, third) and in another
file I have the real number (1°, 2°, 3°) of the item, both on each line.

Here's some Ruby code that may do what you're interested in:

====

d1 = open("f1.txt") do |f|
f.readlines.map { |line| line.chomp }
end

d2 = open("f2.txt") do |f|
f.readlines.map { |line| line.chomp }
end

d3 = [d1, d2].transpose

p d1, d2, d3 # just so you can see what's happened so
far

d3.each do |str1, str2|
puts "This is the #{str1} (#{str2}) item."
end

====

That's assuming f1.txt contains "first", "second", etc., one per line
and that f2.txt contains "1st", "2nd", etc., one per line.

Eric

====

Are you looking for on-site Ruby or Ruby on Rails training
that's been highly reviewed by former students?
http://LearnRuby.com
 
R

Robert Klemme

2008/8/12 Toki Toki said:
Is it possible to use ruby like awk, sed or cut in unix to editing
strings?

These are quite different tools but yes, you can use Ruby like them
most of the time. Please also have a look at command line parameters
of the Ruby interpreter (ruby -h).
Let say I have to write INSERT query like this:

This is the first (1=B0) item.
This is the second (2=B0) item.
This is the third (3=B0) item.
...

This does not look like an SQL INSERT statement, what is it?
In one file I have the word-number (first, second, third) and in another
file I have the real number (1=B0, 2=B0, 3=B0) of the item, both on each =
line.

Not sure what exactly you are trying to do. For the loading part
here's another variant:

h =3D {}

File.open "f1.txt" do |io1|
File.open "f2.txt" do |io2|
io1.zip io2 do |k,v|
h[k.chomp] =3D v.chomp
end
end
end

p h
Of course, I don't want to really write it, so how can I "edit" the
number of the item dinamically? I've tried with regex, but I haven't
found a solution...

I think that with some text editors maybe it's possible to do that, but
I would like to know if with ruby the result can be achieved easier.

Well, if you tell us what exactly you are trying to achieve. At least
to me it's not fully clear.

Kind regards

robert

--=20
use.inject do |as, often| as.you_can - without end
 
T

Toki Toki

Eric said:
Here's some Ruby code that may do what you're interested in:

====

d1 = open("f1.txt") do |f|
f.readlines.map { |line| line.chomp }
end

d2 = open("f2.txt") do |f|
f.readlines.map { |line| line.chomp }
end

d3 = [d1, d2].transpose

p d1, d2, d3 # just so you can see what's happened so
far

d3.each do |str1, str2|
puts "This is the #{str1} (#{str2}) item."
end

====

That's assuming f1.txt contains "first", "second", etc., one per line
and that f2.txt contains "1st", "2nd", etc., one per line.

Eric

====


Thanks a lot for the code, it works great and it's really clear.

Best regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,769
Messages
2,569,580
Members
45,054
Latest member
TrimKetoBoost

Latest Threads

Top