解决了

如何删除特殊字符在托斯卡吗?

  • 2023年7月31日
  • 2回答
  • 10的观点
凯特
Userlevel 5
徽章 + 2
  • 凯特
  • 社区经理
  • 72回复

1)我要把美元从“90000美元”的价值。字符串替换,它不工作。

2)我要把十进制值从“90000.00”

(最初要求和解决支持中心)

图标

最佳答案社区管理员2023年7月31日,15分45秒

kindly use the regular expression with action mode verify to remove $ from the value \"$90000\".\u00a0<\/p>

{REGEX[\"(?<Buffer>[$]*)(?<Buffer2>[0-9]*)\"]}<\/p>

it will store $ in Buffer and 9000 in Buffer2<\/p>

And if you want to capture only 9000 kindly use the regular expression below<\/p>

{REGEX[\"(?<Buffer>[0-9]*)\"]}<\/p>

which will store 9000 in Buffer.\u00a0<\/p>

Thanks,<\/p>","className":"post__content__best_answer"}">

查看原始
质量问题,凯特
1) I have to remove $ from the value \"$90000\". Tried String replace, it is not working.<\/p>

2) I have to remove decimal value from \"90000.00\"<\/p>

\u00a0<\/p>

[Originally asked and solved on Support Hub]<\/p>","quoteUsername":"Kat","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote & Reply","Share":"Share"}}}">

2回答

C
Userlevel 3
徽章 + 2

请使用正则表达式与行动模式验证将美元从“90000美元”的价值。

{正则表达式["(? <缓冲区>[美元]*)(? < Buffer2 > [0 - 9] *) ")}

它将在Buffer2存储在缓冲区和9000美元

如果你想捕捉只有9000请使用下面的正则表达式

{正则表达式["(? <缓冲区> [0 - 9]*)")}

将缓冲区中存储9000。

谢谢,

kindly use the regular expression with action mode verify to remove $ from the value \"$90000\".\u00a0<\/p>

{REGEX[\"(?<Buffer>[$]*)(?<Buffer2>[0-9]*)\"]}<\/p>

it will store $ in Buffer and 9000 in Buffer2<\/p>

And if you want to capture only 9000 kindly use the regular expression below<\/p>

{REGEX[\"(?<Buffer>[0-9]*)\"]}<\/p>

which will store 9000 in Buffer.\u00a0<\/p>

Thanks,<\/p>","quoteUsername":"Community Administrator","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote & Reply","Share":"Share"}}}">

凯特
Userlevel 5
徽章 + 2

你好,

或者,您也可以使用EXCEL的文本公式改变任何数字格式(使用钙)。

如。

Tbox设置缓冲值= 90000.00美元

Tbox设置缓冲值= {CALC[文本(“”“{B(价值)}”“”“”“”“00000”“”“)]}

质量问题,凯特
Hi All,<\/p>

Alternatively, you can also use TEXT formula of EXCEL (using CALC) to change any number format.\u00a0<\/p>

for e.g.\u00a0<\/p>

Tbox Set Buffer Value=$90000.00<\/p>

Tbox Set Buffer Value={CALC[TEXT(\"//m.cfsri.com/shiftsync/product-forum-50/\"\"//m.cfsri.com/shiftsync/product-forum-50/\"{B[Value]}\"//m.cfsri.com/shiftsync/product-forum-50/\"\"//m.cfsri.com/shiftsync/product-forum-50/\",\"//m.cfsri.com/shiftsync/product-forum-50/\"\"//m.cfsri.com/shiftsync/product-forum-50/\"00000\"//m.cfsri.com/shiftsync/product-forum-50/\"\"//m.cfsri.com/shiftsync/product-forum-50/\")]}<\/p>","quoteUsername":"Kat","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote & Reply","Share":"Share"}}}">

回复


ShiftSync条款和条件
Learn more about our cookies.<\/a>","cookiepolicy.button":"Accept cookies","cookiepolicy.button.deny":"Deny all","cookiepolicy.link":"Cookie settings","cookiepolicy.modal.title":"Cookie settings","cookiepolicy.modal.content":"We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.<\/a>","cookiepolicy.modal.level1":"Basic
Functional","cookiepolicy.modal.level2":"Normal
Functional + analytics","cookiepolicy.modal.level3":"Complete
Functional + analytics + social media + embedded videos"}}}">

金宝搏app官网下载
Baidu
map