Jack P

Hello,

I have several thousand product images (JPG format) with a white background and a logo on the lower left corner. I need to remove this logo. We no longer have the originals. All images are the same size and the logos are all in the same place.

I tried creating an action on Phoshop. I opened one of the images, start recording, select the eraser tool and go ahead and erase the logo. But the action recorded the selection of the eraser tool and that's it. It doesn't record the erasing action.

Jack

There are 3 reasons why I want to do this: Sometimes I find Yahoo Mail's rich text editor to be annoying, I sometimes when I'm applying for a job or gig I want to impress a potential employer/client with my email coding skills and also for practice.

So, is there a way to put my own HTML in Yahoo mail?

I work for a small company of about 15 employees. We don't have an IT guy or system admin.

We have been keeping our passwords stored in an .rtf file on a networked drive, which is not very safe. As it was bound to happen, one of the computers in the network got infected with a trojan horse and the hackers gained access to the file and got on our hosting accounts and started sending out spam. We were notified by the host. I changed all the passwords and deleted the getter files they installed.

My question is: What is the proper way to store passwords safely, in a way in which everyone in the company will have access to them? Maybe a software solution?

I'm trying to use Go To > Special > Blanks in Excell, the problem is that the cells I'm targeting are not blanks. They are just empty.

If I test them with IF(ISBLANK(A2),"True","False"), they return false.

So, how can I turn these into blanks?

I work a lot with very large worksheets. Some have hundreds of thousands of rows.

It happens quite that I have a column that I have to autofill a column from row 2 through row 279,495 (for example) and the columns around it have lots of empty cells so double-clicking the corner of the cell won't do it. So, I have been clicking and dragging and dragging and dragging and dragging... And it takes a really not time.

Do you know any tricks to do this faster?

I have an Excel sheet with information about auto parts.

Part number is on A2. First Vehicle it fits is on B3. Second Vehicle it fits is on B4. Third vehicle it fits is on B5. And so on and so forth until the next Part Number for the next part. Some parts have hundreds of vehicles they fit. Some have 0 (parts for non-US cars).

I need to have the part number on A3, A4, A5, etc.

This is for my sister in law and her husband.

They have a 2007 Macbook Pro Intel Core 2 Duo 2.2Ghz with DVI output.

The TV has the Red, Yellow and White plugs and S Video Plug

I'm trying to find a problem with a site's XML sitemap. I would like to download it and open it on a text-editing program to try to find the errors and what might be causing them.

I don't have FTP access to this part of the site.

When I try going to the URL on my browser, the browser page crashes because the file is too large.

I have an old @mac.com email account I want to access.

I have Mac OSX 10.5.8

I have built a few ecommerce websites at this point using Magento, BigCommerce and Volusion

I have run into a couple of clients that want to sell completely custom products (t-shirts with user-submitted images on them, stickers with custom designs, people who sell engraved products, etc).

I don't have any idea of how to even get started on something like that.

Do you any CMS, ecommerce platforms, etc that could do something like that?

I'm using Excel 2007. The maximum number of characters in a cell is a little over 32,000

I'm having an issue with this because it is not enough for some of the stuff I'm currently doing.

I have searched online for the specs for Excel 2010, the newly announced version of Excel (Excel 2012?) and OpenOffice, but I have not found any information about this.

I have a few hundred thousand of cell values that look like this:

2001ChevroletBlazerLS Sport Utility 2-Door4.3L 262Cu. In. V6 GAS OHV Naturally Aspirated

I need to convert them into this:

Chevrolet/Blazer/2001/4.3L 262Cu.In. V6 GAS OHV Naturally Aspirated.

The year is always 4 digits and always at the beginning of the the string. All of the engines start with the engine displacement in liters in [number].[number]L. Such as 2.0L or 2.3L or 1.5L.

The first question: How to select for Uppercase letter?

The second question: How do I select for the [number].[number]L.?

My formula would probably end up looking like

=MID(A2,5,[find the second uppercase letter in the string]-1)

&"/"&MID(A2,[find second uppercase letter in the string],[find third uppercase letter in the string])

&"/"&LEFT(A2,4)

&"/"&RIGHT(A2,LEN(A2)-[find engine displacement])

I'm very new to javascript. I'm trying to write a simple script to order alphabetically on load a series of UL's. Not the LI's inside of the UL's, but the UL's themselves.

Here is what the HTML looks like:

<div class="FindByCategory">

<ul>

<li>This is the first list item in the first unordered list</li>

<li>This is the second list item in the first unordered list</li>

</ul>

<ul>

<li>This is the first list item in the second unordered list</li>

<li>This is the second list item in the second unordered list</li>

</ul>

</div>

This is what I have so far:

<script>

function sortUnorderedList (div.FindByCategory, sortDescending) {

if(typeof div.FindByCategory == "string")

div = document.getElementById(div.FindByCategory);

var uls = ul.getElementsByTagName("UL");

var vals = [];

for(var i = 0, l = uls.length; i < l; i++)

vals.push(uls[i].innerHTML);

vals.sort();

for(var i = 0, l = uls.length; i < l; i++)

uls[i].innerHTML = vals[i];

}

</script>

I have a products CSV export I'm working on.

Each product goes to many, many categories. And there are 4 tiers of categories. My "category" column entries look like this:

"Ford/Ranger/2011/2.3L 140Cu. In. l4 GAS DOHC NA;Ford/Ranger/2010/2.3L 140Cu. In. l4 GAS DOHC NA;Ford/Ranger/2009/2.3L 140Cu. In. l4 GAS DOHC NA;Mazda/B2300/2009/2.3L 2300CC l4 GAS DOHC NA;Ford/Ranger/2008/2.3L 140Cu. In. l4 GAS DOHC NA;Mazda/B2300/2008/2.3L 2300CC l4 GAS DOHC NA;Ford/Ranger/2007/3.0L 182Cu. In. V6 GAS OHV NA;Ford/Ranger/2007/2.3L 140Cu. In. l4 GAS DOHC NA;Mazda/B2300/2007/2.3L 2300CC l4 GAS DOHC NA;Mazda/B3000/2007/3.0L 2954CC V6 GAS OHV NA;Ford/Ranger/2006/3.0L 182Cu. In. V6 GAS OHV NA;Ford/Ranger/2006/2.3L 140Cu. In. l4 GAS DOHC NA;Mazda/B2300/2006/2.3L 2300CC l4 GAS DOHC NA;Mazda/B3000/2006/3.0L 2954CC V6 GAS OHV NA;Ford/Ranger/2005/3.0L 182Cu. In. V6 GAS OHV NA;Ford/Ranger/2005/2.3L 140Cu. In. l4 GAS DOHC NA;Mazda/B2300/2005/2.3L 2300CC l4 GAS DOHC NA;Mazda/B3000/2005/3.0L 2954CC V6 GAS OHV NA;Ford/Ranger/2004/3.0L 182Cu. In. V6 FLEX OHV NA"

Category tiers are separated by slashes("/") and category entries are separated by semicolons (";")

What I need is I need to alphabetize the entries.

Step 1: Text to Columns by the semicolon to separate the category entries.

Step 2: There are 3 options a) Copy and Paste to transpose and create a macro to sort alphabetically through every column independently of the other columns. But I don't know the VBA code to get the itiration right. 2) Make a long logical formula using the comparison operators < and >. It would have to be quite long. Some products have up to 20 category entries. 3) Something else I haven't thought of.

I'm new to javascript and jquery.

What does this selector mean: " #LayoutColumn2 > div > div > div > ul"

Context(the function it is in) :

$("#placeholderForLoad").load(changedItemValue + " #LayoutColumn2 > div > div > div > ul", function(){

$("#placeholderForLoad li").each(function(){

var itemName = $(this).children("a").text();

var itemValue = $(this).children("a").attr("href");

linkArray.push(itemValue+";"+itemName);

});

if (tierID == "tier1") {

tierID = "tier2";

}

else if (tierID == "tier2"){

tierID = "tier3";

}

else if (tierID == "tier3") {

tierID = "tier4";

}

resetTiers(tierID);

fillMyList(linkArray, tierID);

});

I can't search it on a search engine because they won't read the special characters

I'm having trouble getting the website I'm building to look right. Here is the website:

http://projectgtr.mybigcommerce.com/

I'm trying to get the search bar (div id="SearchForm") to go higher and be in line with the bottom of the logo image, below the Order Status, View Cart, Sign in, Create an account. The div's size is 240px width and there are 292 pixels between the image and the the end of the div.

Thanks in advance

Its 7 columns and 930,000 lines and 14.1 gigs. It won't open on Excel, OpenOffice, or Numbers.

I then tried using the UNIX split command in terminal and got the error message: "split too many files". Maybe I did it wrong? way I did it

split -l 100000 /users/myusername/Desktop/foldername\ file/filename.csv

I thought that would split it into 9 files of 100,000 lines each and one with 30,000

I have a buncho of year fields. They correspond to which years of car a certain auto part fits. For example:

88-91

97-98

04-07

I need to turn these into searchable keywors. In the examples above:

88,89,90,91,1988,1989,1990,1991

97,98,1997,1998

04,05,06,2004,2005,2006

I have normally done this with the Replace function but it can take several hours to put in every combination of years.

Thanks

I was denied an application to a rental property. They said there was an eviction on my record. I was never notified of anything prior to this.

I PULLED MY CREDIT REPORT from ALL 3 CREDIT BUREAUS: nothing about an eviction.

I see from the credit enquiries that they used a company called SafeRent to create a report for them. I'm assuming SafeRent pulled the eviction from the county records? Is there a way to contest this?