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!

Register Log in
  • Congratulations Chriss Miller 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. ksbrace

    delete 376K files from a list

    dos2unix fixed it
  2. ksbrace

    delete 376K files from a list

    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)?
  3. ksbrace

    delete 376K files from a list

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

    delete 376K files from a list

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

    delete 376K files from a list

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

    delete 376K files from a list

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

    special delimiter / text to columns

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

    vlookup only grabbing certain columns

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

    vlookup only grabbing certain columns

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

    grouping issues

    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!
  11. ksbrace

    grouping issues

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

    grouping issues

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

    grouping issues

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

    grouping issues

    r937, can you give me an example?
  15. ksbrace

    grouping issues

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

    filling/replacing text

    let me try and play around with that. Thanks!
  17. ksbrace

    filling/replacing text

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

    filling/replacing text

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

    filling/replacing text

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

    filling/replacing text

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

Part and Inventory Search

Back
Top