How to delete all Un-Excluded Lines in ISPF
Generally you would have used :
x all; find all <criteria>; del x all
It deletes all lines you have excluded (and don’t need any more) in your dataset.
Here we have different scenario:
We want to exclude all lines that meets a <criteria> and then delete all lines that don’t meet the <criteria> …
steps :
[1] x all <criteria>
It will exclude all lines having the <criteria>
Now read carefully
Now you want to delete all visible lines and keep all excluded lines (which meets your <criteria>)…………..
and unwanted lines are now visible to you.
you want to delete these all visible (unwanted) lines.
the command you have to issue is :
[2] del all nx
it will keep all excluded lines and delete all visible lines.
You will see all the lines are excluded in your dataset,
Just issue reset command and view the result..
Got it ??? !!!!
Orkut has disabled the right-click feature on the photo album pages.
As a result you are currently being unable to download photos from friend’s orkut album.
If you try Right Click >> Save Picture As………………. Sorry to say it won’t work.
You can’t save your friend’s picture on your computer…..
But a very simple trick is available:
Logon to Orkut. Open your friend’s album. Choose the photo you like the most.
Resize the browser window in such a way that it will not occupy full screen of your monitor, still you are able to see a part of your friend’s photo.
Drag that photo to your desktop’s empty area.
The photo will be saved on your desktop.
You are saving 3 mouse click efforts !!!
Just count
[1] Right click
[2] click on “save picture as”
[3] choose location (say desktop)
[4] click the “ok” or “save” button
Now your friend doesn’t need to send the same pitures attaching them into a mail.
How to Lock a column MS Excel
some time we need to lock a column from the end user protecting from accidental changes.
scenario:
A B
1 data1 =fun(A1)
2 data2 =fun(A2)
3 data3 =fun(A3)
We want the user to allow key in data in column ‘A’
Function given in column ‘B’ will produce result and user will be able to view the result.
we don’t want the user to select/edit the cells of column ‘B’
steps how to achieve this:
[1] Select the columns (or rows/cells) the user should be able to to TYPE data into.
[2] Format menu / Cells / protection tab
[3] Remove the tick-mark from ‘locked’
[4] Tools menu / protection / protect sheet and apply protection
You will find that you can only type data in the cells that you selected and then removed the ‘locked’ tick-mark from.
This is applicable for cells, columns or rows..
One trick in MS OFFICE for Find and Replace
MS Office 2003 allows find and replacing dependent vowel symbols like hrswa i deergha ee hrswa u deergha oo etc.
I had discovered this trick at the time when I was doing all data corrections after converting the lexicon-data to Unicode.
For example if you want to convert a document typed in SARTH to UNZA…
You can replace all hrswa i to deergha ee as well as all deergha oo to hrswa u
We have to type the dependant i vowel symbol in a notepad and then copy and paste to find and replace window like shown below
Then only the buttons (replace/replace all and find next) will be activated.
If you click replace all, it will replace all hrswa I with deergha ee…..
Similarly for hrswa u and deergha oo
See the picture below
all the best
तुण्डे तुण्डे मतिर्भिन्ना । (tunde tunde martirbhinna ) : –
Every one has their own choice(/mind-set/opinion/thought process).
“Times New Roman” is the default font in Microsoft word.
everyone may not like that font and they want to use another font each time they open msword for creating a new document.
Being a Gujarati, and habituated typing in Gujarati using Vijaya-Kalapi-Gurjari font on a PC; I would like to set “Vijaya” Font in MS Word.
steps:
- Open Microsoft word
- Click Tools menu >> Fonts
It will open below shown window:
- Select font of your choice from “Font:”
- Then click on Default button given at bottom left corner
save that document and close ms word.
Now whenever you open ms word; your favourite font will be set for typing.
If you type documents in Multiple languages in Unicode encoding then You might want to set “Arial Unicode MS” font as default.. it supports almost all languages of the world.
at the same time your system becomes slow as the Arial Unicode font is around 21MB in size.
Please feel free to comment.
