Products

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)"
    ]
]
            }]
        });
    }
}