Shell Programming and Scripting

Good point.

Hi!

i dont know if question like this was already on forum, and if it was i couldn't find it.
Does anyone have script for changing numbers. For example in one text editor i have:

1,1,2,100
2,2,4,100
3,3,6,100
4,4,500,5000
5,5,600,5000
6,6,700,5000

and it need to be changed in:

1,1,5,100
2,2,10,100
3,3,15,100
4,4,1000,5000
5,5,2000,5000
6,6,3000,5000

and i want that i have 100 rows based on first three rows and 100 rows based on other three ones.

Thanks

spuzh,

Please don't hijack another posters thread, but start a new thread for your question.

Regards

Kevin, Era... You're right! Sorry... But not

SQLstr =~ s/(FROM | from)... either as that would capture that part of the match which is unnecessary... The case insensitive version looks the most elegant (i.e., /from\s(\w+)\./i, and yes I forgot that the /e (evaluate) at the end works with the substitution, not the pattern

Also yes, in the real world, any of the SQL statement could be on one or many lines.... I don't know if using "s" following the substitution (which allows "." to match newlines -- s/pattern/substitution/s) would help, or perhaps you can't really do this with a simple pattern sub...

Been playing with some of this a lot lately... Seem to have time on my hands and that's both good and bad....

The capturing is generally not critical, but sometimes it is, but you can use extended syntax to avoid the capturing:

SQLstr =~ s/(?:FROM | from)

I think ?: is correct, tells perl not to capture the pattern into memory if it is inside parenthesis.


And yes, in the real world things can get sloppy. A simple regexp may not work in many situations.