using print

[netrookie]

Guys, I'm stuck trying to format my output using "print". I basically want to keep the string as one line, but it breaks off at the point where I'm calling the scalar variable.

Here is the sample output.

create table urldb3.Heartbeat
 select * from urldb2.Heartbeat
 limit 10;

Here is my code:

foreach my $tblist (@tblist)
{
   print  MYOUTFILE "create table $dbtgt.$tblist select * from $dbsrc.$tblist limit 10;\n";
};

Desired format:

create table urldb3.Heartbeat select * from urldb2.Heartbeat limit 10;

 

[travs69]

chomp $tblist;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[netrookie]

Sweet :-> That did the trick. Thanks!

for reference:

foreach my $tblist (@tblist)
{
   chomp $tblist;
   print  MYOUTFILE "create table $dbtgt.$tblist select * from $dbsrc.$tblist limit 10;\n";
};

 

[travs69]

probably more efficient to just
chomp @tblist;
instead of each $tblist;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;