"함수 left()"의 두 판 사이의 차이

잔글 (봇: 자동으로 텍스트 교체 (-source +syntaxhighlight))
 
7번째 줄: 7번째 줄:
==Bash==
==Bash==
[[category: Bash]]
[[category: Bash]]
<source lang='bash'>
<syntaxhighlight lang='bash'>
input="Hello world"
input="Hello world"
output=${input:0:4}
output=${input:0:4}
echo $output
echo $output
# Hell
# Hell
</source>
</syntaxhighlight>


==POSIX Shell==
==POSIX Shell==
<source lang='bash'>
<syntaxhighlight lang='bash'>
input="Hello world"
input="Hello world"
output=`echo $input | cut -c 1-4`
output=`echo $input | cut -c 1-4`
echo $output
echo $output
# Hell
# Hell
</source>
</syntaxhighlight>


==EXCEL==
==EXCEL==
[[category: Excel]]
[[category: Excel]]
<source lang='php'>
<syntaxhighlight lang='php'>
=LEFT("abcde", 3)  
=LEFT("abcde", 3)  
// abc
// abc
36번째 줄: 36번째 줄:
=LEFT("안녕하세요")
=LEFT("안녕하세요")
// 안
// 안
</source>
</syntaxhighlight>


==Java==
==Java==
[[category: Java]]
[[category: Java]]
* [[StringUtils]]
* [[StringUtils]]
<source lang='java'>
<syntaxhighlight lang='java'>
String str = "Hello";
String str = "Hello";
String a = StringUtils.left(str, 2);
String a = StringUtils.left(str, 2);
</source>
</syntaxhighlight>


==JavaScript==
==JavaScript==
[[category: JavaScript]]
[[category: JavaScript]]
<source lang='javascript'>
<syntaxhighlight lang='javascript'>
str = "Hello";
str = "Hello";
console.log( str.substr( 0, 2 ) ); // He
console.log( str.substr( 0, 2 ) ); // He
console.log( str.substring( 0, 2 ) ); // He
console.log( str.substring( 0, 2 ) ); // He
</source>
</syntaxhighlight>
<source lang='javascript'>
<syntaxhighlight lang='javascript'>
String.prototype.left = function(n) {
String.prototype.left = function(n) {
return this.substring(0, n);
return this.substring(0, n);
}
}
document.write("hello".left(2)); // he
document.write("hello".left(2)); // he
</source>
</syntaxhighlight>


==PHP==
==PHP==
[[category: PHP]]
[[category: PHP]]
<source lang="php">
<syntaxhighlight lang="php">
substr("abcde", 0, 3)        // returns "abc"
substr("abcde", 0, 3)        // returns "abc"
substr("abcde", 0, 8)        // returns "abcde"
substr("abcde", 0, 8)        // returns "abcde"
</source>
</syntaxhighlight>


==Perl==
==Perl==
[[category:Perl]]
[[category:Perl]]
<source lang="perl">
<syntaxhighlight lang="perl">
print substr "abcde", 0, 3 . "\n"; # returns "abc"
print substr "abcde", 0, 3 . "\n"; # returns "abc"
print substr "abcde", 0, 8 . "\n"; # returns "abcde"
print substr "abcde", 0, 8 . "\n"; # returns "abcde"
</source>
</syntaxhighlight>


==Rexx==
==Rexx==
[[category: Rexx]]
[[category: Rexx]]
<source lang="php">
<syntaxhighlight lang="php">
left("abcde", 3)        /* returns "abc"      */
left("abcde", 3)        /* returns "abc"      */
left("abcde", 8)        /* returns "abcde  " */
left("abcde", 8)        /* returns "abcde  " */
left("abcde", 8, "*")    /* returns "abcde***" */
left("abcde", 8, "*")    /* returns "abcde***" */
</source>
</syntaxhighlight>


==Scheme==
==Scheme==
[[category: Scheme]]
[[category: Scheme]]
<source lang="scheme">
<syntaxhighlight lang="scheme">
(use-modules (srfi srfi-13))
(use-modules (srfi srfi-13))
(string-take "abcde", 3) ;  returns "abc"  
(string-take "abcde", 3) ;  returns "abc"  
(string-take "abcde", 8) ;  error
(string-take "abcde", 8) ;  error
</source>
</syntaxhighlight>


== Windows Batch ==
== Windows Batch ==
<source lang='batch'>
<syntaxhighlight lang='batch'>
set input=Hello World
set input=Hello World
set output=%input:~0,4%
set output=%input:~0,4%
echo %output%
echo %output%
REM Hell
REM Hell
</source>
</syntaxhighlight>


==SQL==
==SQL==
102번째 줄: 102번째 줄:
===MySQL===
===MySQL===
[[category: MySQL]]
[[category: MySQL]]
<source lang='sql'>
<syntaxhighlight lang='sql'>
SELECT LEFT("hello world", 3);
SELECT LEFT("hello world", 3);
-- hel
-- hel
</source>
</syntaxhighlight>


===Oracle===
===Oracle===
[[category: Oracle]]
[[category: Oracle]]
* Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
* Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
<source lang="sql">
<syntaxhighlight lang="sql">
rpad('hello', 7);  
rpad('hello', 7);  
--returns 'hello  '
--returns 'hello  '
122번째 줄: 122번째 줄:
rpad('hello', 4, 'x');  
rpad('hello', 4, 'x');  
--returns 'hell'
--returns 'hell'
</source>
</syntaxhighlight>
<source lang="sql">
<syntaxhighlight lang="sql">
select rpad('hello', 10, 'abc') from dual;  
select rpad('hello', 10, 'abc') from dual;  
--returns 'helloabcab'
--returns 'helloabcab'
</source>
</syntaxhighlight>


==VB==
==VB==
[[category: VB]]
[[category: VB]]
<source lang="vb">
<syntaxhighlight lang="vb">
Left("sandroguidi", 3)   
Left("sandroguidi", 3)   
'  returns "san"  
'  returns "san"  
136번째 줄: 136번째 줄:
Left("sandroguidi", 100)  
Left("sandroguidi", 100)  
'  returns "sandroguidi"
'  returns "sandroguidi"
</source>
</syntaxhighlight>


==같이 보기==
==같이 보기==

2020년 11월 2일 (월) 02:36 기준 최신판

1 Overview[ | ]

left
  • Definition: left(string,n) returns string
  • Description: Returns the left n part of a string. If n is greater than the length of the string then most implementations return the whole string (exceptions exist - see code examples).

2 Bash[ | ]

Bash
Copy
input="Hello world"
output=${input:0:4}
echo $output
# Hell

3 POSIX Shell[ | ]

Bash
Copy
input="Hello world"
output=`echo $input | cut -c 1-4`
echo $output
# Hell

4 EXCEL[ | ]

PHP
Copy
=LEFT("abcde", 3) 
// abc

=LEFT("abcde", 8) 
// abcde

=LEFT("안녕하세요", 2)
// 안녕

=LEFT("안녕하세요")
// 안

5 Java[ | ]

Java
Copy
String str = "Hello";
String a = StringUtils.left(str, 2);

6 JavaScript[ | ]

JavaScript
Copy
str = "Hello";
console.log( str.substr( 0, 2 ) ); // He
console.log( str.substring( 0, 2 ) ); // He
JavaScript
Copy
String.prototype.left = function(n) {
	return this.substring(0, n);
}
document.write("hello".left(2)); // he

7 PHP[ | ]

PHP
Copy
substr("abcde", 0, 3)         // returns "abc"
substr("abcde", 0, 8)         // returns "abcde"

8 Perl[ | ]

Perl
Copy
print substr "abcde", 0, 3 . "\n"; # returns "abc"
print substr "abcde", 0, 8 . "\n"; # returns "abcde"

9 Rexx[ | ]

PHP
Copy
left("abcde", 3)         /* returns "abc"      */
left("abcde", 8)         /* returns "abcde   " */
left("abcde", 8, "*")    /* returns "abcde***" */

10 Scheme[ | ]

scheme
Copy
(use-modules (srfi srfi-13))
(string-take "abcde", 3) ;  returns "abc" 
(string-take "abcde", 8) ;  error

11 Windows Batch[ | ]

batch
Copy
set input=Hello World
set output=%input:~0,4%
echo %output%
REM Hell

12 SQL[ | ]

12.1 MySQL[ | ]

sql
Copy
SELECT LEFT("hello world", 3);
-- hel

12.2 Oracle[ | ]

  • Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
sql
Copy
rpad('hello', 7); 
--returns 'hello  '
 
rpad('hello', 4); 
--returns 'hell' 

rpad('hello', 7, 'x'); 
--returns 'helloxx' 

rpad('hello', 4, 'x'); 
--returns 'hell'
sql
Copy
select rpad('hello', 10, 'abc') from dual; 
--returns 'helloabcab'

13 VB[ | ]

vbnet
Copy
Left("sandroguidi", 3)   
'  returns "san" 

Left("sandroguidi", 100) 
'  returns "sandroguidi"

14 같이 보기[ | ]

15 References[ | ]