Data exploration - Revision history

Planetoid at 03:32, 15 July 2025

2025-07-15T03:32:16Z

← Older revision		Revision as of 11:32, 15 July 2025
Line 1:		Line 1:

			{{Template:Draft}}

	== Maximum length of characters in a column ==		== Maximum length of characters in a column ==
Line 9:		Line 11:
	<references/>		<references/>

	{{Template:~~Draft~~}}		{{Template:Data factory flow}}

	[[Category:Spreadsheet]]		[[Category:Spreadsheet]]

Unknown user: Text replacement - "== references ==" to "== References =="

2022-07-10T09:11:29Z

Text replacement - "== references ==" to "== References =="

← Older revision		Revision as of 17:11, 10 July 2022
Line 6:		Line 6:
	More details on [[PHP_and_MySQL_syntax#Length_of_characters \| length of characters]] page.		More details on [[PHP_and_MySQL_syntax#Length_of_characters \| length of characters]] page.

	== ~~references~~ ==		== References ==
	<references/>		<references/>

Planetoid: /* Maximum length of characters in a column */

2018-06-07T12:03:47Z

Maximum length of characters in a column

← Older revision		Revision as of 20:03, 7 June 2018
Line 2:		Line 2:
	== Maximum length of characters in a column ==		== Maximum length of characters in a column ==
	* Excel<ref>[https://bensullins.com/excel-tip-identifying-the-max-length-of-values-in-a-column/ Excel Tip: Identifying the max length of values in a column - Ben Sullins \| Data Geek]</ref>: {{kbd \| key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadsheet<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>.		* Excel<ref>[https://bensullins.com/excel-tip-identifying-the-max-length-of-values-in-a-column/ Excel Tip: Identifying the max length of values in a column - Ben Sullins \| Data Geek]</ref>: {{kbd \| key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadsheet<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>.
	* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php ~~MySQL~~ CHAR_LENGTH() function - w3resource] e.g. {{kbd \| key=<nowiki>=SELECT MAX(CHAR_LENGTH(`my_column`)) FROM `my_table`</nowiki>}} cf:		* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php CHAR_LENGTH() function - w3resource] e.g. {{kbd \| key=<nowiki>=SELECT MAX(CHAR_LENGTH(`my_column`)) FROM `my_table`</nowiki>}} {{exclaim}} Not using [https://www.w3resource.com/mysql/string-functions/mysql-length-function.php LENGTH() function].

	More details on [[PHP_and_MySQL_syntax#Length_of_characters \| length of characters]] page.		More details on [[PHP_and_MySQL_syntax#Length_of_characters \| length of characters]] page.

Planetoid: /* Maximum length of characters in a column */

2018-06-07T12:02:11Z

Maximum length of characters in a column

← Older revision		Revision as of 20:02, 7 June 2018
Line 4:		Line 4:
	* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php MySQL CHAR_LENGTH() function - w3resource] e.g. {{kbd \| key=<nowiki>=SELECT MAX(CHAR_LENGTH(`my_column`)) FROM `my_table`</nowiki>}} cf:		* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php MySQL CHAR_LENGTH() function - w3resource] e.g. {{kbd \| key=<nowiki>=SELECT MAX(CHAR_LENGTH(`my_column`)) FROM `my_table`</nowiki>}} cf:

	More details on [[PHP_and_MySQL_syntax#Length_of_characters \| ~~Length~~ of characters]]		More details on [[PHP_and_MySQL_syntax#Length_of_characters \| length of characters]] page.

	== references ==		== references ==

Planetoid: /* Maximum length of characters in a column */

2018-06-07T12:00:45Z

Maximum length of characters in a column

← Older revision		Revision as of 20:00, 7 June 2018
Line 2:		Line 2:
	== Maximum length of characters in a column ==		== Maximum length of characters in a column ==
	* Excel<ref>[https://bensullins.com/excel-tip-identifying-the-max-length-of-values-in-a-column/ Excel Tip: Identifying the max length of values in a column - Ben Sullins \| Data Geek]</ref>: {{kbd \| key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadsheet<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>.		* Excel<ref>[https://bensullins.com/excel-tip-identifying-the-max-length-of-values-in-a-column/ Excel Tip: Identifying the max length of values in a column - Ben Sullins \| Data Geek]</ref>: {{kbd \| key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadsheet<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>.
	* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-~~length~~-function.php ~~LENGTH~~() function] e.g. {{kbd \| key=<nowiki=SELECT MAX(~~LENGTH~~(`my_column`)) FROM `my_table`</nowiki>}} cf: [~~https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php MySQL CHAR_LENGTH() function - w3resource~~]		* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php MySQL CHAR_LENGTH() function - w3resource] e.g. {{kbd \| key=<nowiki>=SELECT MAX(CHAR_LENGTH(`my_column`)) FROM `my_table`</nowiki>}} cf:

			More details on [[PHP_and_MySQL_syntax#Length_of_characters \| Length of characters]]

	== references ==		== references ==

Planetoid: /* Maximum length of characters in a column */

2018-06-07T07:39:09Z

Maximum length of characters in a column

← Older revision		Revision as of 15:39, 7 June 2018
Line 1:		Line 1:

	== Maximum length of characters in a column ==		== Maximum length of characters in a column ==
	* Excel: {{kbd \| key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadsheet<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>.		* Excel<ref>[https://bensullins.com/excel-tip-identifying-the-max-length-of-values-in-a-column/ Excel Tip: Identifying the max length of values in a column - Ben Sullins \| Data Geek]</ref>: {{kbd \| key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadsheet<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>.
	* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-length-function.php LENGTH() function] e.g. {{kbd \| key=<nowiki=SELECT MAX(LENGTH(`my_column`)) FROM `my_table`</nowiki>}} cf: [https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php MySQL CHAR_LENGTH() function - w3resource]		* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-length-function.php LENGTH() function] e.g. {{kbd \| key=<nowiki=SELECT MAX(LENGTH(`my_column`)) FROM `my_table`</nowiki>}} cf: [https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php MySQL CHAR_LENGTH() function - w3resource]

Planetoid: Created page with " == Maximum length of characters in a column == * Excel: {{kbd | key==MAX(LEN(Sheet1!A2:Sheet1!A1048576))}} where 1048576 is the rows limit of Excel spreadshe..."

2018-06-07T07:36:17Z

Created page with " == Maximum length of characters in a column == * Excel: {{kbd | key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadshe..."

New page

== Maximum length of characters in a column ==
* Excel: {{kbd | key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadsheet<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>.
* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-length-function.php LENGTH() function] e.g. {{kbd | key=<nowiki=SELECT MAX(LENGTH(`my_column`)) FROM `my_table`</nowiki>}} cf: [https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php MySQL CHAR_LENGTH() function - w3resource]

== references ==
<references/>

{{Template:Draft}}

[[Category:Spreadsheet]]
[[Category:Excel]]
[[Category:Data Science]]
[[Category:MySQL]]