Windows_Commands_Daily

/####################################################################\

Remove the text starting from a delemeter ( here it is comma) till end in MS Excel

=LEFT(B1,FIND(",",B1)-1)

/###################################################################\/###################################################################\

First, search with regular expression:

open the "Replace" dialog (Ctrl+h, or menu Search -> Replace).

select the "Regular expression" radio button in the bottom-left of the dialog.

Now, fill the following search fields:

Find what: @.*$

Replace with: (leave empty)

This will find the text @ followed by any number of characters .* to the end of the line $ (end of line part is optional).

The found text is then replaced by nothing (or whatever you want to put in the "Replace with" field).

Similarly to delete the text before a delemeter

Find what: .*@

Replace with: (leave empty)

Note: here delemeter is ' @ '

/###################################################################\/###################################################################\

I searched all around but couldn't find any solutions.

I have:

<option value="1">Advertising

<option value="11">Aerospace

<option value="12">Agriculture

<option value="13">Architecture/Urban Planning

<option value="14">Arts

<option value="15">Automotive

<option value="16">Banking

<option value="17">Biotech & Pharmaceuticals

<option value="18">Business Services

<option value="19">Chemicals

I want delete all of text before the "> so the unnecessary text like <option value="1"> will be gone, only the Job type name such as Advertising being kept. How can I do it?

Use a regular expression search.

Type ctrl-H to open the search-and-replace dialog.

Make sure that "Regular expression" is checked.

Put this in the "Find what" box: ^[^>]*>

Make sure that "Replace with" box is empty

Click on "Replace All"

Done!

Explanation: The regular expression can be broken down as follows:

^ — match the start of a line

[^>] — match any character that is not the > character

* — repeat the previous as many times as possible

> — match a > character