Search Query Post: 302504513

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Search Query Post 302504513 by theref on Monday 14th of March 2011 07:50:04 PM

03-14-2011

Registered User

Search Query

This issue has been causing me a headache all night....

I have a file, from a third party payment vendor, that contains an export of data including an order number (unique) and a payment value, amongst other data. I need to use the order numbers to integrate the database to check the order status on the database - no issues here a bit of awking gets me the right response. [FILE A]

If an order comes back in a pending state I need to run another bit of SQL that gives me more information including how much money our system took - once again no issues here. [FILE B]

Now this is the bit I can't work out.... How do I match up the value column from [FILE A] with the results of [FILE B] when [FILE A] may contain 100 records and [FILE B] may only have two. Basically, I need to take the order numbers in [FILE B] and search for the value column in [FILE A] and create [FILE C]

Any help would be a godsend!

./pjg

theref

View Public Profile for theref

Find all posts by theref

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

query on how to search for a line and read 4th word from that line

Assume I have a text file as below: me con pi ind ken pras ur me con rome ind kent pras urs pintu con mys ind pan pras ki con kit ind sys My requirement, I need to search for "con rome" and if exists, then print 4th word from rome, i.e in above example, since "con rome"...

2. UNIX for Dummies Questions & Answers

LDAP search query help

I would like to do an ldap search which looks for entries which do not actually have a certain attribute. Not that the attribute is Null, but where the attribute does not exist. Is this possible using ldapsearch?

3. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

4. Shell Programming and Scripting

Ldap search query

Hi All, I have a existing Ldap query which take a HOME as variable and gives the result where i grep for a particular line. ldapsearch -h server_domain_name -p 389 -D "uid=user,ou=appadm,o=ent" -w PaB -b "ou=roles,o=ent" "cidx=$HOME" | grep -w "ent: xyz" Now i have 330K Homes in a...

5. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh...

6. Shell Programming and Scripting

Complex string search query.

Hi, I wish to find the latest occurance of the below string in my log file. Once found, I need to search the below string after the above string and display this Request 331489 has passed or Request 331489 has failed I would like my query to be platform...

7. Shell Programming and Scripting

Search query

Hi, I have a typical requirement to find users having at least three occurrence in a log within an hour, and perform some action for that user. We have several steps, however I am kind of stuck here to accomplish the said requirement. Here are the logs : conn=13570 op=14 msgId=13 - BIND...

8. Programming

MYSQL query search between dates

Just a little help if possible I have a table with date data, I want to select dates that fall between today and 1 month ago, here's my query SELECT id, stdate, DATE_SUB(CURDATE(), INTERVAL 1 month) as monthago, CURDATE() as today FROM data_table where (stdate between 'today' and 'monthago')...

LEARN ABOUT PHP

apple_dump

APPLE_DUMP(1)							   Netatalk 2.2 						     APPLE_DUMP(1)

NAME

       apple_dump - Dump AppleSingle/AppleDouble format file

SYNOPSIS

       apple_dump [-a] FILE | DIR
							  apple_dump -f FILE
							  apple_dump -d FILE
							  apple_dump -h | -help | --help
							  apple_dump -v | -version | --version

DESCRIPTION

       apple_dump dump AppleSingle/AppleDouble format file.

OPTIONS

       -a FILE|DIR
	   This is default. Dump a AppleSingle/AppleDouble file for FILE or DIR automatically. Extrapolate FinderInfo type from absolute path. If
	   FILE is not AppleSingle/AppleDouble format, look for .AppleDouble/FILE and ._FILE. If DIR, look for DIR/.AppleDouble/.Parent and ._DIR.

       -f FILE
	   Dump FILE. Assume FinderInfo to be FileInfo.

       -d FILE
	   Dump FILE. Assume FinderInfo to be DirInfo.

       -h, -help, --help
	   Display the help and exit

       -v, -version, --version
	   Show version and exit

NOTE

       There is no way to detect whether FinderInfo is FileInfo or DirInfo. By default, apple_dump examins whether file or directory, a parent
       directory is .AppleDouble, filename is ._*, filename is .Parent, and so on.

       If setting option -f or -d, assume FinderInfo and doesn't look for another file.

SEE ALSO

       ad(1)

Netatalk 2.2							    02 Sep 2011 						     APPLE_DUMP(1)