DBCS function
The DBCS
function in Jspreadsheet Formulas Pro is a tool that allows you to verify if a text string includes double-byte characters. These types of characters are typically found in languages like Japanese and Chinese. When you use this function, it scans the provided text and returns TRUE if the string contains any double-byte characters, or FALSE otherwise. This can be particularly useful if you're working with multilingual data and need to identify specific language characters.
Documentation
Checks whether a text string contains double-byte characters, which are used in some languages such as Japanese and Chinese.
Category
Text
Syntax
DBCS(text)
Parameter | Description |
---|---|
text |
The text string to be checked for double-byte characters. |
Behavior
The DBCS
function is designed to assist with multilingual data processing within Jspreadsheet environments. It is usually associated with Double Byte Character Set (DBCS) in computing, which is used to encode languages with a large number of unique characters, such as Chinese, Japanese, and Korean. If you are referring to a specific function within a specific spreadsheet software, ensure that it supports the function and that it is properly documented.
- Empty strings: Return FALSE.
- Numeric values: Numbers return FALSE (no double-byte characters).
- Mixed text: Returns TRUE if at least one double-byte character is found.
- Single-byte characters only: Returns FALSE.
Common Errors
Since 'DBCS' is not a recognized function in standard spreadsheet software, attempting to use it as a function will likely result in an error. The table below lists some common errors that may occur:
Error Name | Description |
---|---|
#VALUE! | This error occurs when the wrong type of argument or operand is used. |
Best practices
- Use DBCS to validate if a dataset contains Asian characters before processing or exporting.
- Combine with ASC/JIS for character-width normalization.
- Always ensure the input cell is formatted as text to avoid unexpected results.
Usage
A few examples using the DBCS function.
DBCS("こんにちは") returns TRUE because the string contains double-byte characters
DBCS("Hello") returns FALSE because the string does not contain double-byte characters
DBCS("你好") returns TRUE because the string contains double-byte characters
Interactive Spreadsheet Demo
<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>
<div id="spreadsheet"></div>
<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('YmMwZDNiYWZhNTcyMWE3NTM5MjQyYzJmNTU5MTQ1NDRiZGQ0NDY1OTU5YTM2YTczMDFkZTA1MDlhYmFhZDdhNmViMDM1NTJmOTQ5Yjg2ZTUxZWM0Y2UzM2MxMWExNTZjODUyMzhhNmEzMDQyYzhiOWZlNTAwM2FjNjIzMDdjNGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01EY3pNekEyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
data: [
[
"Text Sample",
"Contains DBCS?"
],
[
"Hello World",
"=DBCS(A2)"
],
[
"\u3053\u3093\u306b\u3061\u306f",
"=DBCS(A3)"
],
[
"\u4f60\u597d\u670b\u53cb",
"=DBCS(A4)"
],
[
"Mixedtext\u6df7\u5408",
"=DBCS(A5)"
]
]
}]
});
</script>
</html>
import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
// Set license
jspreadsheet.setLicense('YmMwZDNiYWZhNTcyMWE3NTM5MjQyYzJmNTU5MTQ1NDRiZGQ0NDY1OTU5YTM2YTczMDFkZTA1MDlhYmFhZDdhNmViMDM1NTJmOTQ5Yjg2ZTUxZWM0Y2UzM2MxMWExNTZjODUyMzhhNmEzMDQyYzhiOWZlNTAwM2FjNjIzMDdjNGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01EY3pNekEyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default function App() {
// Spreadsheet array of worksheets
const spreadsheet = useRef();
// Worksheet data
const data = [
[
"Text Sample",
"Contains DBCS?"
],
[
"Hello World",
"=DBCS(A2)"
],
[
"\u3053\u3093\u306b\u3061\u306f",
"=DBCS(A3)"
],
[
"\u4f60\u597d\u670b\u53cb",
"=DBCS(A4)"
],
[
"Mixedtext\u6df7\u5408",
"=DBCS(A5)"
]
];
// Render component
return (
<Spreadsheet ref={spreadsheet}>
<Worksheet data={data} />
</Spreadsheet>
);
}
<template>
<Spreadsheet ref="spreadsheet">
<Worksheet :data="data" />
</Spreadsheet>
</template>
<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";
// Set license
jspreadsheet.setLicense('YmMwZDNiYWZhNTcyMWE3NTM5MjQyYzJmNTU5MTQ1NDRiZGQ0NDY1OTU5YTM2YTczMDFkZTA1MDlhYmFhZDdhNmViMDM1NTJmOTQ5Yjg2ZTUxZWM0Y2UzM2MxMWExNTZjODUyMzhhNmEzMDQyYzhiOWZlNTAwM2FjNjIzMDdjNGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01EY3pNekEyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default {
components: {
Spreadsheet,
Worksheet,
},
data() {
// Worksheet data
const data = [
[
"Text Sample",
"Contains DBCS?"
],
[
"Hello World",
"=DBCS(A2)"
],
[
"\u3053\u3093\u306b\u3061\u306f",
"=DBCS(A3)"
],
[
"\u4f60\u597d\u670b\u53cb",
"=DBCS(A4)"
],
[
"Mixedtext\u6df7\u5408",
"=DBCS(A5)"
]
]
return {
data
};
}
}
</script>
import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('YmMwZDNiYWZhNTcyMWE3NTM5MjQyYzJmNTU5MTQ1NDRiZGQ0NDY1OTU5YTM2YTczMDFkZTA1MDlhYmFhZDdhNmViMDM1NTJmOTQ5Yjg2ZTUxZWM0Y2UzM2MxMWExNTZjODUyMzhhNmEzMDQyYzhiOWZlNTAwM2FjNjIzMDdjNGEsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01EY3pNekEyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
@Component({
standalone: true,
selector: "app-root",
template: `<div #spreadsheet></div>`
})
export class AppComponent {
@ViewChild("spreadsheet") spreadsheet: ElementRef;
// Worksheets
worksheets: jspreadsheet.worksheetInstance[];
// Create a new data grid
ngAfterViewInit() {
// Create spreadsheet
this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
worksheets: [{
data: [
[
"Text Sample",
"Contains DBCS?"
],
[
"Hello World",
"=DBCS(A2)"
],
[
"\u3053\u3093\u306b\u3061\u306f",
"=DBCS(A3)"
],
[
"\u4f60\u597d\u670b\u53cb",
"=DBCS(A4)"
],
[
"Mixedtext\u6df7\u5408",
"=DBCS(A5)"
]
]
}]
});
}
}