Search results for query: *

dos2unix fixed it

Yeah, I checked that too. I am in the directory of the files. and the file looks like this: PXPROD_bqsj2c03_77_1 PXPROD_bqsj2c03_78_1 PXPROD_bqsj2c03_79_1 PXPROD_bqsj2c03_80_1 PXPROD_bqsj2c03_81_1 PXPROD_bqsj2c03_82_1 how would I spit the output to a log file to try and look for any error(s)?

so...I ran the echo first and got the correct output: rm -rf PXPROD_7csoh8si_64_1 rm -rf PXPROD_7dsoh8si_101_1 rm -rf PXPROD_7hsoh8sj_101_1 rm -rf PXPROD_7lsoh8sk_101_1 rm -rf PXPROD_jks8868l_101_1 cat files_to_del.txt | while read fn; do echo rm -f ${fn}; done but when I took the echo...

LOL, I'm sorry I didn't catch it either!

rm -f rm -f rm -f rm -f rm -f rm -f rm -f rm -f rm -f rm -f rm -f rm -f rm -f etc....

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 changed that in Excel Option and it's now only grabbing the first value =VLOOKUP(CG2,'Sheet 2'!$CD:$CP,2,FALSE) When I move to the next column, I can do this: =VLOOKUP(CG2,'Sheet 2'!$CD:$CP,3,FALSE) =VLOOKUP(CG2,'Sheet 2'!$CD:$CP,4,FALSE) ...etc. but I have to keep putting CG2 back in...

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...

absolutely! Sorry for the shabby copy/pasting. I was out yesterday due to illness. I think we are good and I really appreciate your help and patience. Boss seems happy now!

Ok, so I'm working through this and this is my query: select collector, portfolio_name as portfolio, sum(numAccts) as "number of accounts", sum(numPendPayments), sum(totalPending), sum(numPostPayments), sum(totalPosted), sum(totalNumPayments), sum(totalValue)...

well, that is why I included the link so you could actually see the data. It's listing the same collector several times for the same portfolio. It should list the collector once per portfolio with the associated data.

Ok, so even with the extra grouping my query is wrong. The three initial 3 queries are returning the correct data. I don't understand why the final one is completely off. http://www.mediafire.com/?qh7hbnyk98jhxc5 are my result files: pending, posted, numAccts are correct. The final_table is...

r937, can you give me an example?

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)...

let me try and play around with that. Thanks!

I'm just trying to hide the actual data and say it's AVAILABLE or replace/mask the data with the header column(example above). I just make a copy of the open/original file and then hide the actual data to show the potential buyer the portfolio. but I don't want the blank fields to get filled...

I want to fill any DATA cells with AVAILABLE and leave the blanks BLANK. name ssn acctnumber phone altphone refname TOM 12344 X3453s 713-3443 David Jeff 44334 h435ss 713-1233...

so, I have name, address, city, ssn, acct number, alt phone, ref name, etc.. I want to fill the ssn, acct number, phone, alt phone, ref name and some others. However, I do not want to fill in the blanks. For instance, not all have ssn, not all have alt phone or ref names. I want to leave the...

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...