이클립스에서 대소문자 변환하기
변환할 단어를 블럭선택하고
1.소문자 변환은 블럭 지정후 ctrl + shift + y 2. 대문자 변환은 블럭 지정후 ctrl + shift + x
| [Web] 인증, 공용인증, OAuth - http://oauth.net/ (0) | 2012.11.06 |
|---|---|
| Firefox 기본폴더 (0) | 2012.10.22 |
| [HTML5] webQR - How to create QR code reader in HTML5 website (0) | 2012.10.08 |
| Chrome Dev Tools: Markup and Style (0) | 2012.10.05 |
| URI - The What, Why and How of Data URIs in Web Design (0) | 2012.10.02 |
http://woorkup.com/2010/02/19/10-useful-google-spreadsheet-formulas-you-must-know/
Google Spreadsheet is a powerful and free tool to manage complex spreadsheets. This tutorial illustrates ten useful formulas you must know to help you simplify the way you work in Google Spreadsheet.
This formula searches for value in the left-most column of array and returns the value in the same row based on the index.
=vlookup(search_criterion, array, index, sort_order)
For example, if you want to find the population of the value
contained in the cell C2, from all values contained in the range A2:B4,
copy and paste the following formula into the cell D2:
=vlookup(C2;A2:B4;2;false)
This formula returns a filtered version of the given source array.
=filter(range; condition1, condition2,...)
In this example I filtered all values contained in the column A (range A2:A12) greater than 37.
Copy and paste the following formula into the cell B2:
=filter(A2:A12;A2:A12>37)
You can also use multiple conditions to filter a source array:
=filter(A2:A12;A2:A12>37; A2:A12<60)
In this case the formula returns all values contained in the range A2:A12 greater than 37 AND less than 60.
This function concatenates several text strings, contained in different cells, into one string.
=concatenate(text1, text2, text3,...)
If you want to concatenate all values contained in the cells A2, A3,
A4 into one string, copy and paste this formula into the cell B2:
=concatenate(A2,A3,A4)
If you want to separate each single value with a space (cell B3), use this formula:
=concatenate(A2," ", A3," ", A4)
This formula looks for a string of text within another string and returns an integer.
=find(find_text, text, position)
For
example, if you want to find the "space" within the string contained in
the cell C2 (which contains this text: Jack Bauer), copy and paste the
following formula into the cell B2:
=find(" ", A2, 1)
This formula returns "5" that means the "space" is found within the source string after 4 characters.
Left extracts a substring from a string, starting from the left-most character.
=left(text, number)Right extracts a substring from a string, starting from the right-most character.
=right(text, number)
If you want to extract the name "Jack" from the cell A2, copy and paste the following formula into the cell B2:
=left(A2;4)
If you want to extract the surname "Bauer" from the cell A3, copy and paste the following formula into the cell B3:
=right(A3;5)
You can also use the following formula to extract dynamically the
name from an array of multiple values (Jack Bauer, Gregory House,
Christian Troy, ...):
=left(A2; find(" ", A2, 1)-1)
This formula splits text based on the given delimiter, putting each section into a separate column in the row.
=split(string, delimiter)
For example, if you want to split the values contained in the column A,
using the delimiter " " (space), copy the following formula into the
column B (the column C will be populated automatically):
=split(A2," ")
This formula substitutes new text for old text in a string.
=substitute(text, search_text, new text, occurrence)
If you want to substitute "Jack" with "Mike" from the text contained in
the cell A2, copy and paste this formula into the cell B2:
=substitute(A2, "Jack", "Mike",1)
Occurrence (optional, in this case "1") indicates how many occurrences of the search text are to be replaced.
This formula returns only the unique values in the source array, discarding duplicates.
=unique(array)
If you want to obtain an array of unique values from the values
contained in the column A, copy and paste the following formula into the
cell B2:
=unique(A2;A9)
As you can see, this formula returns only unique values in the column A, discarding all duplicates.
This function returns market information from Google Finance related to a specific company.
=GoogleFinance(symbol, attribute)
For example, if you want to know the Google stock price, copy and paste the following formula into the cell B2: =GoogleFinance(A2,"price")
You can use the same formula for the other companies in this example (NVidia, Intel, Cisco,...). Other attributes are volume, earning per share, opening price and so on (take a look at the official documentation for a full list).
This formula attempts to find the values for straightforward facts about specific things.
=GoogleLookup(entity, attribute)
For example if you want to find the countries of cities listed in the
column A, copy and paste the following formula into the column B:
=googleLookup(A2;"country")
You can access some types of entities such as countries and territories (population, largest city), rivers (origin, length), actors and musicians (date of birth, nationality), planets and so on. For a full list of popular entities, take a look at the official documentation.
| [UX/UI] 모바일 기기를 위한 UX/UI 기법 (0) | 2012.11.07 |
|---|---|
| [펌]data-p 의 세계에 오신 것을 환영합니다. http://www.data-p.org/kor/ (0) | 2012.10.26 |
| [보안] 로그인 보안 프로세스의 구성과 구축 (0) | 2012.10.17 |
| 법과 정책으로 본 정보보호의 현주소 - 마소 2012년 10월호 특집 (0) | 2012.10.17 |
| [SERI] 개도국 저소득층의 삶의 변화를 이끄는 모바일 (0) | 2012.09.28 |
최근 시행되는 정부 정책에 의해 개인정보 수집 시도는 줄어들지만, 계정이 가진 가치는 그대로 유지될 전망이다. 대부분 유저들은 사이트를 동일한 아이디와 비밀번호로 사용하기 때문에 특정 사이트의 아이디와 비밀번호가 노출되면 연쇄적으로 여러 사이트의 해당 계정이 취약해진다.
특정 횟수 이상 틀린 패스위드가 입력되면 실명인증이나 그림문자를 추가해 로그인 입력과정을 복잡하게 하는 방식은 이미 기본적으로 적용하고 있다. 하지만 동일한 아이디와 패스워드를 사용하거나 아이디는 달라도 패스워드가 동일한 경우가 많다. 그래서 아이디나 비밀번호를 유추해서 알아내면 이미 개인정보가 노출되었다고 볼수 있다.
보안을 하려면 무엇을 보호할 것인지, 보호할 대상이 어떻게 구성되어 있는지 잘 파악해야 할 것이다.
로그인에 사용되는 정보의 종류는
계정, 패스워드, 본인인증, 실명인증,
그림문자(CAPTCHA 라고 한다.), IP(공인/지정아이피),
2차인증(보안카드/OTP/지문인식/스마트카드)
등이 있다.
절대적인 안전은 보장할 수 없다. 예전 업체중엔 IP로 보안을 했는데, 내부 인사중에서 IP를 열어준 경우도 있어서 보안이란 데이터가 중요하지만, 보안에 대한 인식도 큰 부분이라는걸 명심하자.
| [펌]data-p 의 세계에 오신 것을 환영합니다. http://www.data-p.org/kor/ (0) | 2012.10.26 |
|---|---|
| [구글 문서도구] 10 Useful Google Spreadsheet Formulas You Must Know (0) | 2012.10.18 |
| 법과 정책으로 본 정보보호의 현주소 - 마소 2012년 10월호 특집 (0) | 2012.10.17 |
| [SERI] 개도국 저소득층의 삶의 변화를 이끄는 모바일 (0) | 2012.09.28 |
| 모바일서울 - 서울의 4대문 안 길 이야기 (0) | 2012.09.28 |
개인정보보호법이 제정 시행된 지 어느덧 1년이 지났다. 그리고 지난 8월 18일부터 정보통신 이용촉진 및 정보보호 등에 관한 법률이 개정돼 현재 시행되고 있다. 하지만 그 법이 얼마나 잘 지켜지고 있는지는 의문이다. 이제 정보보호는 기술적 측면 뿐 아니라 법과 제도적인 측면까지 고려해야 할 것들이 생겨났고, 법에서 요구하는 최소한의 수준까지 무조건 지켜야 하는 일종의 규범으로 인식되고 있다. 이에 정보보호를 둘러싼 법과 정책적 이슈는 무엇이고 특히 IT 업계가 주목해야 할 정보보호의 의미는 무엇인지 짚어본다.
http://www.imaso.co.kr/?doc=bbs/gnuboard.php&bo_table=article&wr_id=41193
<그림 3> 개인정보보호 종합지원 포털(www.privacy.go.kr)에서는 관련 정보 외에도 개인정보 침해 및 유출신고를 할 수 있다. 또한 정보통신망법 대상자는 www. privacy.kr을 권장한다.
| [구글 문서도구] 10 Useful Google Spreadsheet Formulas You Must Know (0) | 2012.10.18 |
|---|---|
| [보안] 로그인 보안 프로세스의 구성과 구축 (0) | 2012.10.17 |
| [SERI] 개도국 저소득층의 삶의 변화를 이끄는 모바일 (0) | 2012.09.28 |
| 모바일서울 - 서울의 4대문 안 길 이야기 (0) | 2012.09.28 |
| 디지털 교과서 (0) | 2012.09.28 |
| jquery event bind delegate live on 비교분석 (0) | 2012.11.14 |
|---|---|
| [WEB] 50+ Awesome Responsive HTML5 Templates (0) | 2012.11.14 |
| 30+ High Performing HTML5 Templates for Web Design (0) | 2012.10.16 |
| 20 New Essential jQuery Plugins (0) | 2012.10.16 |
| [Style] 15 Online HTML5 Tools for Web Designers (0) | 2012.10.11 |
HTML5 templates have become very popular and for a good reason. HTML5 is still a work in process standard, but it has brought a lot of new features to the table. Recent versions of the major browsers support many of them already, and they continue to add new features.
The new tags available in HTML5 includes the <canvas> element for 2D drawing, the <video> and <audio> elements for media playback, the new content-specific elements, like <article>, <footer>, <header>, <nav>, <section> and new form controls, like calendar, date, time, email, url, search. In addition, the arrival of CSS3 adds even more power in the hands of web designers.
The benefits of HTML5 are many and new tags will help web designers build stunning future proof websites without need for proprietary plugins like e.g. Flash.
In this article I share with you high quality HTML5 templates to provide inspiration and insights about HTML5 based web design. Hopefully, this collection will help in creating your own HTML5 powered website.
This is a professional theme with a clean and simple attitude. It is designed for portfolio or business websites. SmartStart has been crafted with the latest CSS3 and HTML5 techniques. It will easily adjust to any browsing device, including mobile phones and tablets, because of its responsive feature. You can also get this template in the WordPress version.
Perspective is a template that is ideal for all kinds of business websites. It is packed with plenty of HTML shortcodes and jQuery plugins like accordion, sliders and tabs. The design is responsive, and it can be edited easily.
This is a nice HTML5 template that is ideal for showcasing fashion, studios and creative. It can be customized easily with 13 pages and powerful full screen gallery that can showcase big sized works on the homepage directly. The customization process can be enhanced by the Serif and Sans Serif styles that are included with the template. In addition, the themes is mobile friendly.
VividPhoto is a stunning photography HTML5 and CSS3 template that is designed to showcase a portfolio of images.
Vega is a HTML5 template that is dynamic, stylish and creative. It is easy to customize and user friendly. Vega is a great way of showcasing your media.
This template was designed with HTML5 and CSS3, and has a corporate and agency appearance. It’s fully responsive feature is created with Bootstrap.
This is a creative template that can enhance your video or photography showcase. The complete page template set will provide the possibility to showcase your work and brand in a professional and refined manner.
Minimalism is an HTML5 and CSS3 template that is minimal and beautiful in its simplicity. Combines multiple-column groupings and newspaper style column.
Harmony is packed with easy to use and built in features that will make user experience an exciting, pleasant and intuitive one. The package includes 4 Home page sliders , 16 color schemes, a working contact form with validation and more. IT is not responsive though.
This is a professional and simple HTML5 template that can be used for both desktop and mobile devices. Chromatron has a lot of features and build in jQuery. There are 4 default colors available, each packed with popular and basic user interface widgets.
Folder is a free HTML5 portfolio theme with responsive design.
This HTML5 template is modern and clean. It is great for any portfolio or business website. It has jQuery features available and 12 page templates.
This is a modern and clean template that is best suited for business or portfolio websites. Easy and fast to set up, Retro also has a WordPress version.
NeoArts is a modern and elegant web template designed for Design/Studio websites. All-in-One page with an animated theme.
Almost anything can be changed in this template. You can make your own creative design and set up color for all site elements using CSS. It includes 5 preset Home page layouts, Google webfont directory support (320+ Fonts) and more.
Limitless HTML5 template is packed full of user friendly features and plenty of PSD and HTML files. Limitless was designed with SEO in mind.
An awesome free, responsive HTML5 template aimed at businesses and portfolios.
Clean, responsive and simple would be the perfect words to describe Simplex HTML5 template. Simplex has been designed with mobile devices in consideration and is well suited for studios and digital agencies. The template will adjust its size automatically on different devices, ensuring a nice experience for every visitor.
This template is entirely responsive and designed with an elegant and minimal look. The package includes CSS3 and HTML5 codes.
Manifest is a HTML5 template that is very flexible and clean. It has a minimalist and modern design that is ideal for galleries, creative blogs, portfolios and other types of websites. The package includes 6 predefined skins to customize your website easily.
Muro is a brilliantly designed web template that comes with 3 different skins, 7 page layouts as well as jQuery functionality.
This is a professional and clean template that is ideal for portfolio, business and hosting websites. It has a responsive design that was created with HTML5 and CSS3, making it compatible with all kinds of devices including iPhone, iPad and Androids.
This template is easy to customize and full of features. Show off your work with this easy-to-customize and fully featured Site Template.
This theme is easy to customize and use. Basix is a minimal HTML 5 template that is full of features like unlimited colors, jQuery, 960 grid system and working contact form. The portfolio section is filtered using Isotope. In addition, this theme is also well documented, with a lot of shortcodes and features for creating your own pages.
A clean and responsive HTML5 template. Moderna is ideal for both creative personal portfolio and professional business websites. The theme has two skins, which are stretched and boxed. The boxed version has 15 patterns so that you can have unlimited options in managing and organizing your contents.
![left[5]-hml5-template](http://cdn.tripwiremagazine.com/wp-content/uploads/2012/10/left5_thumb.jpg "left[5]")
LEFT web template is designed in HTML5 and offers more than 6 page layouts with a unique skin system.
If you are looking for a responsive and clean theme that is suitable for a wide variety of uses, Weiss HTML5 template would be a great choice.
This is a responsive HTML5 template that is ideal for business and portfolio websites. It was created using the best web design practices such as Microformats. Canopus is ideal for iPhone, iPad and other mobile devices.
Oreva is very minimal and clean HTML5 business template that can be used for all kinds of personal and business websites. The template has 2 color variations that can fulfill all the requirements of modern web development.
Classy and responsive, Impromptu HTML5 template is perfect for portfolio blog or business websites.
This minimalist and clean HTML5 template was created for WordPress. It is ideal for blogs, magazine, personal and news websites.
This responsive HTML5 template is most suited for creative agency and portfolio websites. The solid responsive layout is flexible and can scale down from 1170 pixels to 320 pixels.
‘
Simple yet packed with a lot of options, Mustach can be used for personal portfolio and small business sites. The template comes with a clean and neat code, making it easy to understand when making variations in the template.
| [WEB] 50+ Awesome Responsive HTML5 Templates (0) | 2012.11.14 |
|---|---|
| [javascript] HTML5 게임 - http://cocos2d-javascript.org/ (0) | 2012.10.17 |
| 20 New Essential jQuery Plugins (0) | 2012.10.16 |
| [Style] 15 Online HTML5 Tools for Web Designers (0) | 2012.10.11 |
| [jQuery] How to Turn jQuery Accordion into CSS3 Accordion (0) | 2012.10.08 |