Foxtable(狐表)用户栏目专家坐堂 → [求助]:英文金额大写问题


  共有24102人关注过本帖树形打印复制链接

主题:[求助]:英文金额大写问题

帅哥哟,离线,有人找我吗?
andy
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:童狐 帖子:215 积分:1855 威望:0 精华:0 注册:2011/4/19 9:49:00
[求助]:英文金额大写问题  发帖心情 Post By:2011/5/13 17:21:00 [只看该作者]

英文金额大写问题,例如:USD12345.45,我利用表达式计算,转换成大写后是:Twelve Thousand Three Hundred Forty Five Dollars And Forty Five Cents,但是正常的应该是:Twelve Thousand Three Hundred And Forty Five Dollars Forty Five Cents。

想请问各位高手,能否指导一下,解决这个问题。先谢谢了!!

[此贴子已经被作者于2011-5-13 17:48:08编辑过]

 回到顶部
帅哥哟,离线,有人找我吗?
狐狸爸爸
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:管理员 帖子:47497 积分:251403 威望:0 精华:91 注册:2008/6/17 17:14:00
  发帖心情 Post By:2011/5/13 17:51:00 [只看该作者]

呵呵, 给你一个思路,找出转换后的最后一个Hundred,替换为Hundred  And

 回到顶部
帅哥哟,离线,有人找我吗?
狐狸爸爸
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:管理员 帖子:47497 积分:251403 威望:0 精华:91 注册:2008/6/17 17:14:00
  发帖心情 Post By:2011/5/13 17:57:00 [只看该作者]

Dim s1 As String  = "Twelve Thousand Three Hundred Forty Five Dollars And Forty Five Cents"
Dim n As Integer = s1.LastIndexOf("Hundred")
Dim s2 As String  = s1.Remove(n,7)
s2 = s2.Insert(n,"Hundred And")
Output.Show(s2)

 回到顶部
帅哥哟,离线,有人找我吗?
blackzhu
  4楼 | QQ | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 一级勋章
等级:狐仙 帖子:9879 积分:57634 威望:0 精华:15 注册:2008/9/1 9:45:00
  发帖心情 Post By:2011/5/13 19:47:00 [只看该作者]

这个做法好像有问题,因为做外贸的要打fa piao,金额要转换成英文的.所以只是用于替换有问题的.

 回到顶部
帅哥哟,离线,有人找我吗?
andy
  5楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:童狐 帖子:215 积分:1855 威望:0 精华:0 注册:2011/4/19 9:49:00
  发帖心情 Post By:2011/5/13 23:16:00 [只看该作者]

谢谢两位的帮忙。谢谢!

 回到顶部
帅哥哟,离线,有人找我吗?
e-png
  6楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:七尾狐 帖子:1695 积分:10725 威望:0 精华:0 注册:2009/10/25 16:45:00
  发帖心情 Post By:2011/5/14 8:41:00 [只看该作者]

Twelve Thousand Three Hundred Forty Five Dollars And Forty Five Cents,

Twelve Thousand Three Hundred And Forty Five Dollars Forty Five Cents。

 

这两句都有问题,英文金额大写必须 用类似:Say US Dollars .......而且 多少Cents 前面必须加 And(如;... and forty five cents)


 回到顶部
帅哥哟,离线,有人找我吗?
blackzhu
  7楼 | QQ | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 一级勋章
等级:狐仙 帖子:9879 积分:57634 威望:0 精华:15 注册:2008/9/1 9:45:00
  发帖心情 Post By:2011/5/14 8:46:00 [只看该作者]

这个LXL版主不知道能不能搞定,这个做外贸很用的着?

 回到顶部
帅哥哟,离线,有人找我吗?
lxl
  8楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 一级勋章
等级:MVP荣誉狐 帖子:858 积分:6071 威望:0 精华:19 注册:2008/9/1 9:13:00
  发帖心情 Post By:2011/5/14 14:17:00 [只看该作者]

英语不太好,看看这个有没有问题,没问题我才改成VB的

 

Number:110200012.10   Word: One Hundred And Ten Million Two Hundred Thousand and Twelve Dollars And Ten Cents
Number:200012105.42   Word: Two Hundred Million Twelve Thousand One Hundred And Five Dollars And Forty Two Cents
Number:110105001.11   Word: One Hundred And Ten Million One Hundred And Five Thousand and One Dollars And Eleven Cents
Number:100001001.42   Word: One Hundred Million One Thousand and One Dollars And Forty Two Cents
Number:12020110.10    Word: Twelve Million Twenty Thousand One Hundred And Ten Dollars And Ten Cents
Number:146010146.42   Word: One Hundred And Forty Six Million Ten Thousand One Hundred And Forty Six Dollars And Forty Two Cents
Number:20120105.2     Word: Twenty Million One Hundred And Twenty Thousand One Hundred And Five Dollars And Twenty Cents
Number:120105110      Word: One Hundred And Twenty Million One Hundred And Five Thousand One Hundred And Ten Dollars
Number:105000005.2    Word: One Hundred And Five Million and Five Dollars And Twenty Cents
Number:20020005       Word: Twenty Million Twenty Thousand and Five Dollars
Number:146120105.11   Word: One Hundred And Forty Six Million One Hundred And Twenty Thousand One Hundred And Five Dollars And Eleven Cents
Number:105120100.10   Word: One Hundred And Five Million One Hundred And Twenty Thousand One Hundred Dollars And Ten Cents
Number:305305146.05   Word: Three Hundred And Five Million Three Hundred And Five Thousand One Hundred And Forty Six Dollars And Five Cents
Number:105146305.10   Word: One Hundred And Five Million One Hundred And Forty Six Thousand Three Hundred And Five Dollars And Ten Cents
Number:12305.05       Word: Twelve Thousand Three Hundred And Five Dollars And Five Cents
Number:146146005      Word: One Hundred And Forty Six Million One Hundred And Forty Six Thousand and Five Dollars
Number:305305000.10   Word: Three Hundred And Five Million Three Hundred And Five Thousand Dollars And Ten Cents
Number:305012100.42   Word: Three Hundred And Five Million Twelve Thousand One Hundred Dollars And Forty Two Cents
Number:10105110       Word: Ten Million One Hundred And Five Thousand One Hundred And Ten Dollars
Number:110010020.2    Word: One Hundred And Ten Million Ten Thousand and Twenty Dollars And Twenty Cents
Number:5005200.2      Word: Five Million Five Thousand Two Hundred Dollars And Twenty Cents
Number:120020105.2    Word: One Hundred And Twenty Million Twenty Thousand One Hundred And Five Dollars And Twenty Cents
Number:1146120        Word: One Million One Hundred And Forty Six Thousand One Hundred And Twenty Dollars
Number:20305010       Word: Twenty Million Three Hundred And Five Thousand and Ten Dollars
Number:100100105.11   Word: One Hundred Million One Hundred Thousand One Hundred And Five Dollars And Eleven Cents
Number:120000020.11   Word: One Hundred And Twenty Million and Twenty Dollars And Eleven Cents
Number:20200305       Word: Twenty Million Two Hundred Thousand Three Hundred And Five Dollars
Number:1200120.2      Word: One Million Two Hundred Thousand One Hundred And Twenty Dollars And Twenty Cents
Number:305010305.11   Word: Three Hundred And Five Million Ten Thousand Three Hundred And Five Dollars And Eleven Cents
Number:305020012.11   Word: Three Hundred And Five Million Twenty Thousand and Twelve Dollars And Eleven Cents
Number:10000001       Word: Ten Million and One Dollars

[此贴子已经被作者于2011-5-14 14:20:59编辑过]

 回到顶部
帅哥哟,离线,有人找我吗?
lxl
  9楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 一级勋章
等级:MVP荣誉狐 帖子:858 积分:6071 威望:0 精华:19 注册:2008/9/1 9:13:00
  发帖心情 Post By:2011/5/14 14:48:00 [只看该作者]

 下载信息  [文件大小:   下载次数: ]
图片点击可在新窗口打开查看点击浏览该文件:管理项目3.table


 回到顶部
帅哥哟,离线,有人找我吗?
狐狸爸爸
  10楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:管理员 帖子:47497 积分:251403 威望:0 精华:91 注册:2008/6/17 17:14:00
  发帖心情 Post By:2011/5/14 15:15:00 [只看该作者]

呵呵,收藏,单价确定lxl版主的正确的话,我找这个修改foxtable的代码。

 回到顶部
总数 48 1 2 3 4 5 下一页