Search results for query: *

I have a txt file with filenames going straight down. I need to delete them. rm -f $(echo $(cat files_to_del.txt)) gives me arg list too long. also tried xargs rm -rf < files_to_del.txt it doesn't do anything. any help would be greatly appreciated.

I have a column that looks like this: LOT_2891_2894 CCI LOT_2991_2993 CCI Diverse LOT_50176_50188 HSBC Retail 3/12/14 Diverse LOT_50112_50188 HSBC Retail 3/12/14 Diverse LOT 50142_50188 HSBC Retail 3/12/14 Diverse LOT_50231_50243 Credit One Diverse LOT_2994_2996 Sterling 3/12/14 Diverse LOT...

I am trying to grab some columns from Sheet 2 based on the filenumber (which is on both sheets). this is what my Sheet 2 looks like. There are more columns but just so you see the first few... filenumber, name_first, name_last, name_suffix, street_address, p_city_name, st, z5, z4 my columns...

So, I have these 3 queries that return the exact data that I want: select assignedto, ifnull(count(*),0),portfolio, sum(ifnull(round(paymentamount*contingencyamount/100,2),0)) from payments where paymentstatus='PENDING' group by assignedto; select assignedto, ifnull(count(*),0)...

Hello, I have excel sheets that I want to "mask" the data with the header column. However, there are blank spaces between the data. How can I just mask the existing data and not the blanks? Thanks in advance. I know how to use the Fill Down, but it fills in the blanks and I don't want that...

I am trying to get some totals....I have assignedto, portfolio, paymentamount, status as columns. What I have is: select assignedto, portfolio, paymentamount "total payment money" from payments group by assignedto; But that doesnt' give me the total amount of payment money for each...

I am trying to write a trigger, but nothing is getting updated. The insert portion works fine. Any advice is greatly appreciated. Thanks in advance. DROP TABLE IF EXISTS `collectionsmax`.`payments_timestamp`; CREATE TABLE `collectionsmax`.`payments_timestamp` ( `PaymentsID` int(10)...

Hello, I'm getting null values for paymentamout when it should be 0 and I would like to populate the nulls with a zero. I thought this would do it: select sum(p.paymentamount), pf.portfolio, pf.placementdate from portfolios pf left outer join payments p on p.portfolio=pf.portfolio and...

I am trying to return all portfolios, even if they don not have any that have NEWBIZ (return 0 with portfolio). I tried IFNULL. Not sure how to go about it. Any advice? [code] select ifnull(count(*),0) ,d.portfolio from dbase d, portfolios pf where statusname='NEWBIZ' and...

I'm trying to create a report procedure. I created a report table, liqReports and I need columns/data from 3 other tables. This is what I have done, it's wrong. When I run the 3 selects alone, I get the correct data. I thought I could just do 3 inserts, then I thought I could do updates...

I was looking for info on a SIP Gateway. Someone recommended the 2811. Any thoughts? Thanks in advance.

I get an email, daily, with an excel spreadsheet of all calls made by all agents from the day before. I'm looking to have it custom sorted by calling number, then direction, then time, duration. I would like to be able to just upload the file either via .NET app or php, etc... Then I want the...

Hello, I have 3 sheets and they all have full name (First Last). I want to pull the amt column from sheet one and populate a column on sheet 3 based on Full Name. Any help would be greatly appreciated. Thanks in advance!

Hello, I'm trying to figure out how many employees I have had at daily intervals. Meaning, let's say I want to look at Jan 3rd and see how many employees I had on that day. Or Feb 15th, same thing. I have 2 columns that are of interest: Date Hired and Termination Date. in format of...

I am trying to get a total of each statusType for each agent.. example of data: agent statusType Kelly New Tom No Info Kelly Active Kelly New Kelly Exhausted Mary Sold Mary New I would like something similar to this...

Ok, so I have 2 tables sales_ppl and potential_clients. I want to assign the clients to the sales people in a round robin fashion to distribute them more evenly by state, etc.. like one client gets assigned to the first salesp_name, the second client ot the second salesp_name, third to the...

Hello, I have a spreadsheet with several columns (fname, lname, address, city, etc....) My boss gave me a spreadsheet with just last names and wants a spreadsheet with all the data but only of the names on his sheet. is there a built-in function that can assist or can someone help me out...

Hello, When I attempt to login, I enter password and it says loading your personal settings, applying settings, logging off....then it kicks me back to ctl/alt/del screen. I put in Ultimate Boot CD and created a new user, but same results. Any help would be greatly appreciated. Thanks in...

I have a macro in MS Access 2007 that opens a report, prints it (print layout), then quits. I would like to Save as "report_date.txt" or some other text format before it quits. There is no Save/Save As command option in the macro design view. Any and all help would be greatly appreciated...

How do I get the total amount of sum of sales in this query? Thanks in advance [code]SELECT [product history].[transaction date], [product history].[Product Code], [product history].[description one] AS Brand, Sum([product history].Quantity) AS SumOfQuantity, Sum([product history].[Sales...