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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.