Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jimineep
  • Content: Threads
  • Order by date
  1. jimineep

    word wrap with more / less

    is there a way of using less to open a file with no word wrap, ie with horizontal scrolling? Im sure there is but 'man less > grep "wrap"' doesnt seem to bring up anything. Apologies if this is the wrong forum! Many thanks Jim
  2. jimineep

    split

    is there a way of splitting standard out/ standard error from a script that falls over, so far I've got: % ./scratch.pl | split if you imagine the error was like: asdf asdf werqwer asdfasf asdasdf I want a way to split this up by whitespace to become: asdf asdf werqwer asdfasf asdasdf I...
  3. jimineep

    DISTINCT on some things, not on others

    Is it possible to use SELECT DISTINCT to use distinct on certain columns, but not on others, for example "SELECT DISTINCT columna, columnb, columnc FROM table" would bring back all the results where columna, columnb and columnc were not all the same, and if they were it would bring back only...
  4. jimineep

    Creating 2 tables from one on the fly - mind draws a blank

    Hi guys, I am currently writing a complicated script (perl) to do something I feel I could do with one SQL command: I have a table - EXP_NAME ID CHANGE A AX 234.23 A AB -23.23 A AC 22.23 B AX -43.25 B...
  5. jimineep

    DBI fetchrow array/ general Perl oo question - quickie

    Hi guys I'm trying to work out if a table exists in my database, using an object which inherits from DBI. my $TableExists = $dbh->fetchrow_array; if ( $TableExists = "NO") { warn "No table";} Now my question is...surely there is a way of combining the $dbh->fetchrow_arraty into the...
  6. jimineep

    Multiple expressions in a SWITCH STATEMENT

    I am trying to do a switch statement which analyses multiple expression: int main(){ char str1[] = "H"; char str2[] = "B"; switch ( * str1, * str2 ){ case 'H''B': printf("%s","YUP"); break; case 'B''B'...
  7. jimineep

    substituting repeated regions in a long string

    Hi I have a long string in which I want to substitute repeated AT regions with N, ie ATATATATATATATATATAT NNNNNNNNNNNNNNNNNNNN I am having a problem doing this i have tried with tr/// which seems to mask all AT no matter how many repeats there are, and also with the s/// which behaves oddly...
  8. jimineep

    Insert date into MySQL database with DBI

    Hey I'm using DBI to put a date entered value into a mysql database. However I'm having problems. My date column in NOTNULL but when i enter the date (as a string) from my perl script, whilst all other columns are filled, the date entered column remains 0000-00-00. I know it is calculating the...

Part and Inventory Search

Back
Top