If you want to use the conversion of the amount, the processing of the decimal part should be modified
function Ch_num ($num, $mode =true) {
$char = Array ("0", "one", "II", "three", "the", "WU", "Lu", "Qi", "ba", "JIU");
$DW = Array ("", "Pick", "
Create Procedure ATOC
@ChangeMoney Money
As
Set Nocount on
Declare @String1 Char (20)
Declare @String2 Char (30)
Declare @String4 Varchar (100)
Declare @String3 Varchar (100)--value removed from the original a value
Declare @i INT--loop
Method 1:
Function dx (n) {// converts the amount in uppercase.If(! /^ (0 | [1-9] \ D *) (\. \ D + )? $/. Test (n ))Return "invalid data ";VaR unit ="Hundreds of thousands of yuan corner points", STR = "";N + = "00 ";VaR P = n. indexof ('.');If (P>
Main functions
Code :
Copy code The Code is as follows: function Chinese (Num)
{
If (! /^ \ D * (\. \ D *)? $/. Test (Num ))
{
Alert ("You did not enter a number. Please try again! ");
Return false;
}
VaR AA = new array ("zero", "one", "two",
Package cn.edu. bjfu. test;
Public class Divert {
/*** It only supports trillion levels and is absolutely able to meet daily needs.** @ Param src* @ Return*/Public static double divert (String src ){String temp = src. replaceAll ("whole", ""). split
In an Excel report submitted by an enterprise, such numbers are used for accounting.① (3) (4) (6) (7)(1) (2) (4) when there are too many threads in each segment)You can easily pick up80 or 90
How can I find data greater than XXX?
Copy the data
CREATE FUNCTION Changebigsmall
(@ChangeMoney money)
RETURNS VarChar (M) as
BEGIN
Declare @String1 Char (20)
Declare @String2 Char (30)
Declare @String4 Varchar (100)
Declare @String3 Varchar (100)--value removed from the original a value
Declare @i
If you want to use the conversion of the amount, the processing of the decimal part should be modified
function Ch_num ($num, $mode =true) {
$char = Array ("0", "one", "II", "three", "Restaurant", "WU", "Lu", "Qi", "ba", "Nine");
$DW = Array ("",
First Type:
As shown in the figure, you need to convert the numbers in the table to uppercase
As shown in the figure
As shown in the figure, right-click the mouse, select the Format cell, click Open
A window appears, choosing
Main function Code:
Copy Code code as follows:
function Chinese (num)
{
if (!/^\d* (\.\d*) $/.test (num))
{
Alert ("You are not entering a number, please re-enter!");
return false;
}
var AA = new Array ("0", "one", "II", "three", "
Copy Code code as follows:
function Notochinese (num) {
if (!/^\d* (\.\d*)? $/.test (num)) {alert (' number is wrong! '); return ' number is wrong! ';}
var AA = new Array ("0", "one", "II", "three", "Restaurant", "WU", "Lu", "Qi", "ba",
Write it down for later use!
///amount to uppercase amount/// public class Moneyconvertchinese {///////// public string Moneytochinese (string Lowermoney) {string functionreturnvalue = null; BOOL isnegative = false; is a negative number
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.