Monday, February 11, 2013

Best apparel websites india

Here are some good shopping website for clothes in India.

http://www.Jabong.com
http://www.Myantra.com
http://www.Yebhi.com
http://www.infibeam.com/Apparel/

If you have come across a good and trustworthy website for clothes in India, feel free to post in comments.

Wednesday, February 6, 2013

awk command in Unix

awk is a very useful and powerful command in Unix. It's used to work with columns in a text file.

Here is a simple awk command to list the data of 1st column in a text file.



awk '{print $1}'   file_name

We can specify the field-separator using -F option. Refer below example.
Here tab is the filed separator. Below command will print the content of Column 2 in text file.
awk -F'\t' '{print $2}' file_name

We can print the length of data in column 2 using below awk command.
awk -F'\t' '{print length($2)}' file_name

We can check conditions in awk command and print accordingly.
awk -F'\t' '{if(length($4) > 50 ) print $4} ' file_name

The above command will print all the data in Column 4 if length of data is greater than 50 characters.

For more Tips & Tricks in Unix, Click Here.






Group by and Count is Microsoft Excel

Sometimes, we may need to group data in a Column in Excel and take the distinct values and the count of their occurrence.

Refer below data.





















In the above data, if we need distinct values and the number of occurrences, follow the below steps:

1. First get the distinct values to another column. Refer detailed instructions here.
2. Then, use COUNTIF function to get the count of occurrence.


COUNTIF usage:

COUNTIF takes two parameters, 1st is a range where data is present multiple times, and 2nd is the value whose count needs to be found.

Syntax:

=COUNTIF(A1:A12, B1)

For more Tips & Tricks in Excel, Click Here.

How to get distinct records in Microsoft excel?


Follow the below steps to get distinct values from a column in excel sheet to a blank column.

1. Select Data-Filter-Advanced filter
2. Set your list range to the range containing data whose distinct to be retrieved
3. Check Copy to Another Location
4. Check Unique Records Only
5. Set Copy To range to an empty range on the same worksheet.




For more Tips & Tricks in Excel, Click Here.

How to alter a table in Oracle to modify multiple column definition


Oracle alter multiple columns
----------------

To alter a single column in Oracle, the syntax is as below:

alter table
   table_name
modify
   column_name  datatype;

If you want to modify multiple columns, use below syntax:

alter table
   table_name
modify
   (
   column1_name  column1_datatype,
   column2_name  column2_datatype,
   column3_name  column3_datatype,
   column4_name  column4_datatype
   );

The above command is really helpful and saves time while modifying multiple columns in Oracle.

For more tips and tricks on Oracle, click here.

Oracle sqlldr - how to load first few characters of a string to Database in sqlldr

Today I had a Unique challenge while loading Data from text files to Oracle Database using sqlldr.

Many records were getting discarded as bad records. After investigation, I found that, the data is getting rejected because of a specific column whose length is less compared to the length of data in text file. I was getting error as below:

Error on table tbl_test, column col2.
Field in data file exceeds maximum length

The size and datatype of column col2 is varchar2(100).

To load all the data to the Database without any bad records, there are two options.
1. Increase the column width to match the length of data
OR
2. Truncate the data to 100 chars before loading to DB

I preferred the second option for below reasons:
a) First 100 chars of the string is sufficient for my analytics
b) Less space consumption
c) I am not sure of the maximum length that can be for that column in text file.

Now I am decided to trim the data to first 100 chars before loading to DB.
Let's see how to load first few characters of a string to Database in sqlldr?

We have to modify the ctl file (control file) as below:

Old ctl file:

LOAD DATA
INFILE "INFILE_NAME"
BADFILE "BAD_FILE"
DISCARDFILE "DISCARD_FILE"
APPEND into table tbl_test
fields terminated by '\t'
trailing nullcols
(
col1,
col2,
col3,
col4 sysdate
)

Modified ctl file:

LOAD DATA
INFILE "INFILE_NAME"
BADFILE "BAD_FILE"
DISCARDFILE "DISCARD_FILE"
APPEND into table tbl_test
fields terminated by '\t'
trailing nullcols
(
col1,
col2 CHAR(1000) "substr(:col2,1,100)",
col3,
col4 sysdate
)

Change Details:

1. We are using substring function to load first 100 chars
2. If you don't specify length of the input character data, sqlldr uses default of 255 characters. Hence by explicitly mentioning CHAR(1000), we are instructing sqlldr to read all data where col2 length is less than or equal to 1000 chars. We have to increase this number if we see data having higher length.

For more Oracle Tips, Click here

Monday, February 4, 2013

Excel Lookup function - Search a name and show it's vaue

This article will explain what is Lookup function in Microsoft excel and how to use Lookup function with example.

LOOKUP function is a very useful function in Microsoft Excel which returns  a value from a range of values(a row or a column) or from an array.

There are two forms of the function.

1. Vector form
2. Array Form

1. Vector Form
-------------------

In this form, the function searches for the lookup_value in a range, i.e. a row or a column and when a match is found, it takes the corresponding result_value from another range specified (row or column).

Note: The data in lookup_range must be in sorted order. Otherwise Lookup function will give incorrect result.

Syntax:

=LOOKUP(lookup_value, lookup_range,[result_range])

result_range is optional.

Example:



Here are some more examples and the corresponding result:

=LOOKUP(104,A2:A5)              returns 104
=LOOKUP(103,A2:A5,B2:B5)     returns Binay

2. Array Form

The array form, the LOOKUP function searches for the value in the first row or column of the array and returns the corresponding value in the last row or column of the array.

Syntax:

=LOOKUP(lookup_value,array)

Example:

=LOOKUP("B", {"A","B","C","D";10,11,12,13})    returns 11 =LOOKUP("B", {"a","b","c","d";10,11,12,13})   returns 11
=LOOKUP("b", {"A","B","C","D";10,11,12,13})   returns 11
=LOOKUP("E", {"A","B","C","D";10,11,12,13})   returns 13
=LOOKUP("Back", {"A","B","C","D";10,11,12,13})   returns 11
=LOOKUP("0", {"A","B","C","D";10,11,12,13})   returns #N/A

For more Tips & Tricks in Excel, Click Here.
Related Posts with Thumbnails

Labels

2012 (3) 2012-13 (1) Aakash tablet (1) Abhinav Bindra (1) Abhishek Bachhan (1) About Google Wave (1) account hacked (1) Actor (1) addthis (1) ads (2) Adsense (4) adsense and money making (4) Adsense check (1) adsense really pays (1) Adsense revenue sharing (1) Adsense revenue sharing sites (1) AIDS Awareness (1) AIDS Cure (1) AIDS Prevention (1) Airtel (1) Airtel Digital TV (1) Aishwarya Rai (1) al-qaeda (1) Allahabad Bank (1) alter command (2) alter table (2) american ascent (1) anchor tag in html (1) Another Google Innovation (1) anti-biotics (1) Anti-Virus (1) Arts (2) Atlanta Olympics (1) auto commit (1) awk command (1) Back up registry key (1) bacteria (1) Baithe Jeeto jackpot Question (23) Bajaj Allianz (1) Bajaj Allianz Home Insurance (1) Bank Clerical Exam (1) Bank PO Online Test (1) Banking jobs (1) BCECE (1) BCECE 2011 result (1) Beez 20 (1) best moments (1) Best Performing Ads (1) Bharti Airtel (1) Bhulekh (1) Bhulekh.ori.nic.in (1) big bazaar (1) Big Boss 5 (2) Big Boss 5 Contestants (2) Big Boss 5 House Inmates (2) Big Boss 5 Videos (1) Birth Day (1) blank space above table in blog (1) block a sender (3) Blog (1) Blog's Stats (1) Blogger Tips (17) Bluedart courier (1) BMI (1) Body Mass Index (1) Bollywood (2) bookmarks (1) Books (1) bronze (1) Browser (2) Bruce Jenner (1) BSE (1) bse odisha 2013 result (1) bseodisha.nic.in (1) BSNL (1) bulk (1) Cable Operator (1) call center (1) Campus interview (1) Causes and Prevention of Infant Diarrhea (1) cctv (1) celebration (1) celebrity (1) change mouse sensitivity (1) Chat messengers (1) Check Number for DND (1) cheque book (1) Cheque Fraud (1) Child Immunization chedule (1) Children Projects (1) chip tablet (1) Clear Browsing History (1) comment (1) Company Deposits (1) Compare auto insurance (1) Compare Strings (1) Computer Tips (45) Confident English (2) Crafts (2) create a batch file to delete files (1) create PDF (1) Credit Card (3) Credit Card issuers (1) credit card types (1) Credit Card usage (1) credit history (1) Cricket (4) Cricket Live score (2) criminals (1) Cron (2) Crowd (1) Currency conversion (1) custom domain (1) DC Avanti (2) DC Design (1) death (1) decathlon (1) Delhi Auto Expo 2012 (2) department of Telecom (1) disk partition (1) Distinct in Excel (2) DLL Definition (1) DLL File (1) dll or application file through gmail (1) DND (2) domain name (1) Domain names (2) domain redirection (1) Doodle (1) Door Chain (1) DOS Command (1) DoT India (1) dotnet interview questions (1) Download (1) Download movies online (1) download NCERT e-Books (1) download youtube videos (1) drop (1) drop multiple column (1) DropBox (2) DTH Service India (1) duplicate file (1) earn 100 dollars a day (1) earn 1000 dollars a day (1) Earn Money Online (4) earn online by creating rich content (1) earn through google adsense (3) Electricity Bill Payment online in Odisha (1) email (1) Email Extractor (1) email scavenger (1) email whitelist (1) EMS (1) engineering (1) English Grammar (1) eodissa (2) EPF India (1) EPF Online (1) Event (1) Excel 2007 (3) Excel Tips (4) expert answer (2) expert answer blog (2) expertanswer blog (9) expiry date of a LPG Gas cylinder (1) Express Parcle (1) facebook (4) Facts about AIDS (1) Family Budgeting (2) fathers day (1) fear and greed (1) File Sharing (2) filter (1) finance (19) Financial Decision (1) Financial Goal (1) financial planner (2) Find IP Address (1) Find IP of your computer (1) Fixed deposit (1) Flixya Alternatives (1) FloJo (1) Florence Griffith (1) Fluent English (1) Font Size (1) fontself (1) foreign clients (1) Fred Willard (1) Free Dotnet Projects (1) fresher (1) full snap shot (1) Gagan Narang (1) GAS Cylinder safety (1) gastroenteritis (1) gbjj (26) GBJJ Answer (25) GBJJ Question 2013 (25) GBJJ Question KBC 7 (2) get more from google search (1) get out of debt (1) get rich (1) Get Richer (1) Ghar Baithe Jeeto Jackpot (50) Ghar Baithe Jeeto jackpot Question (2) GIF Image (1) gmail (5) godaddy (3) Gold (1) Google (18) Google Adsense (3) Google Calculator (1) Google Chrome browser (1) Google Help Forum (1) google labs (1) google listing (1) google page rank (2) Google Search (2) google search tips (1) google tool (1) google transliteration (1) Google Wave (1) Govt Jobs (1) Govt of India (1) Gregorian calender (1) grep example (1) grep in linux (1) grep in unix (1) Gsm phone emergency call (1) Gymnastics (2) Hacking (1) Happy New Year 2016 (1) Happy teachers day (1) HDFC Standard Life (1) health insurance (1) Health Tips (5) Hit Counter (2) Hollywood (1) Home insurance in India (1) Home Safety Tips (1) HostGator (3) hosting (3) hotmail (1) How much we can earn through Google Adsense (1) how to (1) How to make an emergency call from mobile phone (1) how to send exe file with gmail (1) how to show odia text in bhulekh (1) href (1) HSBC (1) HSBC Home Insurance (1) HTML (2) HTML Symbols (1) IANA (1) ibnlive (1) ICC World Cup 2011 final match (1) ICC World cup final (1) ICC World cup final pics (2) ICC World cup semifinal schedule (1) ICICI Lombard (2) IE8 (2) IIS (1) images (1) images not displaying in gmail (1) imint (1) immunizational chart (1) income tax slab (1) Increase google rank (1) Increase Traffic to Blog (1) Increase your website popularity (1) India (8) India Immunization Chart (1) India Spells 2009 Champion (1) Indian Premier League (1) Indian States (1) Indian Super car (2) Information (1) Infosys (1) ini file (1) insurance (1) Internet (13) internet calculator (1) Internet Explorer (1) Internet Explorer provided by (1) Internet Explorer provided by Dell (1) Internet Protocol (1) Internet Speed (1) Investment (10) investment option (1) investor (1) IP of your machine (1) IP of your PC (1) IPL (4) IPL Teams (1) ixwebhosting (1) Jackpot question today (32) Job Portals (1) Job seekers (1) Job Sites (1) joomla (1) joomla 2.5 (1) Joomla hosting (4) June 19 (1) Karnam Malleswari (1) KBC 5 (22) KBC 6 (28) KBC GBJJ Winner (25) KBC Online (25) KBC Sony (19) keepvid (1) killed (1) know your bandwidth (1) kontera (1) large whitespace in my blog (1) Leap Year (1) learn (2) Learn proper pronunciation of english words (1) Learning (1) licence key (1) linkwithin (1) lipikar (1) Login (1) London Olympics (6) London Olympics logo (1) Long term investor (2) long URL (1) lower (1) Mail signature (2) make emergency phone call (1) Mary Lou Retton (1) MCA (1) Medal Count (1) mediclaim policy (1) Mental Accounting (1) menu item (1) merriam webster dictionary (1) Merry Christma (1) mGinger (1) Michael Johnson (1) Microsoft (3) Microsoft name.dll (1) Microsoft Virtual PC (4) mobile Bill (1) mobile emergency response support (1) mobile number (1) Mobile number change to 11 digits in India (1) mobile phone emergency number (1) money management (1) Money Mistake (1) most viewed (1) mouse pointer (1) mouse sensitivity (1) mouse speed (1) Mozilla (1) msi.dll (1) MSN Messenger (1) mutual fund (2) Mutual fund ELSS (1) Mutual Funds (2) Nadia Comaneci (1) national anthem of India (1) National immunization schedule (1) ncert website (1) NDM-1 (1) New York (1) Newly weds (1) NSE (1) Nylon Rose (1) obama speech (1) Obese (1) Odia Calender 2010 (1) odia font not displaying (1) odia literature (1) odia magazine (1) Odia Panji (1) Odia panjika (1) odisha board 10th result (1) Olympics (8) Olympics 2012 (3) online frauds (1) Online Security (1) Online Test (2) Opera Browser (1) Operating System (5) optimize google search (1) Oracle (8) Origami (2) Orissa Online (1) Oriya calender (1) oriya magazine (1) oriya poems (1) oriya stories (1) Orphan file (1) Orphaned file finder (1) ORS (1) Osama bin Laden (2) Over weight (1) own handwriting (1) Page Title (1) Page view (1) Paraskevi Papachristou (1) Partition magic (1) partition wizard (1) payback (1) Payment (1) PeepHole (1) Pentagon (1) Personal Finance (17) PF transfer (1) PF Withdrawal (1) Phishing Scams (1) photo (1) PhotoBucket (1) phpbb (1) PIN Code (1) PING (1) post a comment problem in blogger (1) Postal Index Number (1) pound in indian rupees (1) Pound in rupees (1) pound to rupee (1) pound to rupee conversion (1) prefix 9 with all mobile numbers (1) President Obama speech (1) primary key (4) Prince William and Kate Middleton Wedding (2) print as PDF (1) print screen (1) productivity tool (1) Puzzles (1) question 4 kbc blogspot (19) quick install (1) QuickInstall (1) Quilling (1) Rabindranath Tagore (1) Rajesh Khanna (1) read ncert books online (1) Read SMS (1) Real Estate (1) Really Tough Movie Quiz (1) Received 100$ from google adsense (1) Received my first google adsense cheque (1) recover gmail account (1) related posts in blog (1) Reliance Big TV (1) Reliance India (1) remove mother tongue influence (1) remove SQM files from computer (1) remove white space in blogspot (1) Retire Early (2) retire sooner (1) retirement (2) Retirement Planning (1) Return to Buckingham Palace (1) reward points (1) RIP (1) RockMelt (1) Ronjan Sodhi (1) Royal Couple (1) Royal Wedding (2) Royal Wedding Kiss Video (1) Royal Wedding Pictures (1) Rupee Symbol (1) safe banking (1) safe online (1) safety (1) sarvapalli radhakrishnan (1) save money (2) Save password (1) savevid (1) Schedule (1) Screen capture software (1) scrolling web page (1) Search engine spider (1) Security (1) See through Hole (1) sell mutual fund (1) Send SMS to KBC (20) Senior Citizens (1) Seo (9) Service Pack (1) set nameserver (1) share file publicly (1) Shooting (1) Show Desktop (2) Show Line Numbers (1) simulator (1) SIP (1) Site Statstics (1) Slow Internet Connection (1) SMS Tracking (1) Social networking sites (1) Software Product (1) sony kbc (19) sp (1) spam (1) speak influential english (1) Speed Post (1) Spell Bee Contest (1) spend smartly (3) spend wisely (2) Spoken English (1) Spouse (1) sql developer (1) SQL Server (3) sqlldr example (1) States in India (1) stay out of debt (1) Stock market (6) Stock Tips (3) subdomain (1) Submit to google (1) Submit to msn (1) Submit to yahoo (1) Submit your website or blog to major search engines (1) Submit your website to Google (1) substring (1) Sun Direct (1) Super Bug (1) Survey (1) Synchronizing (1) Tata Sky (1) Tax Planning (1) technology (2) Telecom (2) Telecom service (1) telecom service in India (1) terrorist (2) text advertisements (1) Thanksgiving (1) The Balcony Kiss Video (2) THE GOLDEN SHOES (1) The New India Assurance (1) time zone (1) TNSPING command (1) Todays GBJJ Question Of KBC 7 (25) top 10 tips (1) Top DTH Services in India (1) Top ten (2) Top ten Telecom service providers (1) Track Online (1) track your Speed Post (1) tracking (1) Trading (1) traffic to blog website (1) TRAI (1) twitter (2) under weight (1) UNICEF (1) Union Territories (1) United India Insurance (1) unix commands (1) Unix Tips (3) upper (1) URL Shortener (1) Urszula Radwanska (1) Use forums (1) use google search effectively (1) Vaccination schedule in India (1) Vedic maths (1) vedic science (1) Verbs (1) Version Control Tools (1) Videocon D2H (1) Visual Studio (1) watch movies online (1) Water Polo (1) wealth management (1) Web site page rank (1) Web technology (4) website (3) Wedding Pics (1) What are .SQM files (1) What is Google Adsense (1) when to use Google Wave (1) why google adsense (1) Why my site not coming in google (1) Will and Kate (1) Windows 7 (2) Windows Live (1) Windows Live Messenger (1) windows OS (2) Women (1) wordpress (1) World AIDS Day 2009 (1) World Trade Centre (1) WPA_KILL (1) write in Odia (1) write in web (1) Yahoo (3) Yahoo answers (1) yahoo mail (1) yahoo rank (1) youtube video (2) youtube video download (1)

  © Blogger templates Palm by Ourblogtemplates.com 2008

Back to TOP