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 Wanet Telecoms Ltd 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: *

  1. mrimagepueblo

    Compare two fields and create a third

    I have two files that I would like to lookup id's for and add their corresponding values to the end of a master file. I can do this in Microsoft Access, but don't really want to. The office file has a structure of Office ID|Office Name|Address|City|... etc. The agent file has a structure of...
  2. mrimagepueblo

    Extracting and printing variables from array

    I am attempting to print the results of an array, @database rows which shows the results of 5 records in my database. I need to populate showAddress with each record in the array to put those fancy markers in a google map. If I manually put showAddress in the spot below 5 times with 5 address...
  3. mrimagepueblo

    awk array to add text to a file

    I see another post that is almost what I'm looking for but thought I'd ask about my specific circumstance. Maybe between your input here and the other post I can figure out what I need. I'd like to get away from using microsoft access to do these queries. I know how to do this in a #!/bin/sh...
  4. mrimagepueblo

    Prepend and Append to a field

    Using /bin/sh shell script. I have to pull fields from a bigger file, no problem there, I'm just clueless on adding something to the beginning and the end of a field. I have a pipe delimited file as such: I'll only use one line for the example: 12345 will always match, as I'm just duplicating...
  5. mrimagepueblo

    Strip first part of filename with awk statement

    I need to write a bash shell script to strip the first part of the filename in a directory of files. The original filenames are 05-12345_1.jpg 05-12345_2.jpg 05-12345_3.jpg 06-56789_1.jpg 06-56789_2.jpg 06-56789_3.jpg 06-56789_4.jpg etc. I simply want to strip out the 05- or 06- whatever...
  6. mrimagepueblo

    how to open a 2nd file and loop through the lines

    I don't know if this is enough information on the code but I think this is the subroutine that is messing up. I'm basically opening a 2nd data file (test.txt) and trying to read each line and run the lookup based on the original data file for matching results. I get the first line of the...
  7. mrimagepueblo

    Which Hardware Upgrade

    Don't laugh... I'm stuck with a perl program that searches a flat file database and I'm wanting to upgrade my existing server or go up a notch in performance but not really sure what performance increase if any I'll get. I find that it only takes aproximately 5-10 seconds to search a database...
  8. mrimagepueblo

    Delete a line based on a pattern

    I have a tab delimited file where one field has multiple entries seperated by a pipe |. ie. field1 field2 field3 123|239|234| field5 what I want to do is match on the |239 and delete that line out of the file. I am running a bash shell script and have tried this line and thought it...
  9. mrimagepueblo

    Rename and Increment Inconsistent Filenames

    I have a need to rename .jpg files coming in with inconsistent ending to something I can run a better if statement on in perl script I use. The front part of the filename is always consistent but the back end of the file can be anything. I am wanting to write a shell script in #!/bin/sh to...
  10. mrimagepueblo

    Special characters quote in sh

    This one is driving me nuts. In a /bin/sh script I am trying to create a login script to a windows ftp 5.0 server from a unix box. My password is Kug.cb!\c` That is indeed a back tick at the end. I lost track of all the combinations I have tried with \ and " and ' My last attempt doesn't give an...
  11. mrimagepueblo

    Grep for occurence of a word and count the number of lines

    I've gone all around this but am not getting what I need. I want to count the number of times a word appears in a text file, but instead of showing the total number of times it occurs, I only want to show the number of lines it occurs in. This is what I have, but it's actually counting all the...
  12. mrimagepueblo

    Limiting Field Length on Linked Table

    I think I have tried all the obvious but I am still not getting the solution I need. I have a pipe delimited (|) text file that has 211 fields and approx 15,000 records that I need to link to and then ultimately export a number of files out as pipe delimited files based on a number of queries. I...
  13. mrimagepueblo

    Rename multiple file

    I have tried figuring out some of the similar posts but can't seem to match up the examples with what I need. I want to create a shell script that will automatically rename a bunch of graphics files cutting off the last part of the filename as their is no pattern to match on without a bunch of...
  14. mrimagepueblo

    Rename multiple file

    I want to create a shell script that will automatically rename a bunch of graphics files cutting off the last part of the filename as their is no pattern to match on without a bunch of if statements. I can create the shell script just need the pattern to rename. The filenames for example are...
  15. mrimagepueblo

    Convert rows to colums and append to end

    I hope this make sense to someone. I am using Access 2003. I have a table that has multiple url's for the same record id and would like to append the url's as additional fields to the end of the query. table called resmedia - the format is as follows with mediasource being the unique url for...

Part and Inventory Search

Back
Top