Concatenate strings: Difference between revisions
Jump to navigation
Jump to search
(Created page with "String Concatenation == Excel == * Using {{kbd | key=<nowiki>&</nowiki>}} symbol to concatenate different cells such as {{kbd | key=<nowiki>A1&B1</nowiki>}}. * Using the [ht...") |
m (Text replacement - "Category:Text file processing" to "Category:String manipulation") |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 4: | Line 4: | ||
* Using {{kbd | key=<nowiki>&</nowiki>}} symbol to concatenate different cells such as {{kbd | key=<nowiki>A1&B1</nowiki>}}. | * Using {{kbd | key=<nowiki>&</nowiki>}} symbol to concatenate different cells such as {{kbd | key=<nowiki>A1&B1</nowiki>}}. | ||
* Using the [https://support.office.com/zh-hk/article/concat-%E5%87%BD%E6%95%B8-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2 CONCAT] or [https://support.office.com/zh-hk/article/concatenate-%E5%87%BD%E6%95%B8-8f8ae884-2ca8-4f7a-b093-75d702bea31d CONCATENATE] function. | * Using the [https://support.office.com/zh-hk/article/concat-%E5%87%BD%E6%95%B8-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2 CONCAT] or [https://support.office.com/zh-hk/article/concatenate-%E5%87%BD%E6%95%B8-8f8ae884-2ca8-4f7a-b093-75d702bea31d CONCATENATE] function. | ||
* Using the [https://support.office.com/zh-hk/article/textjoin-%E5%87%BD%E6%95%B8-357b449a-ec91-49d0-80c3-0e8fc845691c TEXTJOIN] function. {{Gd}} Easy to defined the separator of different cells. | * Using the [https://support.office.com/zh-hk/article/textjoin-%E5%87%BD%E6%95%B8-357b449a-ec91-49d0-80c3-0e8fc845691c TEXTJOIN] function. {{Gd}} Easy to defined the separator of different cells <ref>[https://stackoverflow.com/questions/41125877/concatenate-a-range-of-cells-with-a-comma google sheets - Concatenate a range of cells with a comma - Stack Overflow]</ref>. | ||
== MySQL == | == MySQL == | ||
| Line 15: | Line 15: | ||
* Using {{kbd | key=<nowiki>+</nowiki>}} symbol to concatenate different strings | * Using {{kbd | key=<nowiki>+</nowiki>}} symbol to concatenate different strings | ||
[[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category: | == References == | ||
<references /> | |||
[[Category:Software]] [[Category:Programming]] [[Category:Data Science]] [[Category:String manipulation]] | |||
Latest revision as of 19:31, 9 March 2021
String Concatenation
Excel[edit]
- Using & symbol to concatenate different cells such as A1&B1.
- Using the CONCAT or CONCATENATE function.
- Using the TEXTJOIN function.
Easy to defined the separator of different cells [1].
MySQL[edit]
- Using the CONCAT function
PHP[edit]
- Using . symbol to concatenate different strings
Javascript[edit]
- Using + symbol to concatenate different strings