<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:media="http://search.yahoo.com/mrss/">
<channel>
<title>ClipboardFusion RSS: Macro for Removing Text and Keep Only The Number and Vice Versa</title>
<atom:link href="https://www.clipboardfusion.com/Discussions/RSS/?TopicID=018f40cb-0f62-71c8-8abb-eab9bbaeb4d4" rel="self" type="application/rss+xml" />
<link>https://www.clipboardfusion.com/Discussions/RSS/?TopicID=018f40cb-0f62-71c8-8abb-eab9bbaeb4d4</link>
<description>ClipboardFusion RSS: Macro for Removing Text and Keep Only The Number and Vice Versa</description>
<lastBuildDate>Tue, 19 May 2026 07:58:40 GMT</lastBuildDate>
<language>en</language>
<sy:updatePeriod>hourly</sy:updatePeriod>
<sy:updateFrequency>1</sy:updateFrequency>
<generator>https://www.clipboardfusion.com/Discussions/RSS/?TopicID=018f40cb-0f62-71c8-8abb-eab9bbaeb4d4</generator>
<item>
<title>RE: Macro for Removing Text and Keep Only The Number and Vice Versa</title>
<link>https://www.clipboardfusion.com/Discussions/View/macro-for-removing-text-and-keep-only-the-number-and-vice-versa/?ID=018f40cb-0f62-71c8-8abb-eab9bbaeb4d4#3</link>
<pubDate>Tue, 07 May 2024 13:17:18 GMT</pubDate>
<dc:creator>Binary Fortress Software</dc:creator>
<guid isPermaLink="false">https://www.clipboardfusion.com/Discussions/View/macro-for-removing-text-and-keep-only-the-number-and-vice-versa/?ID=018f40cb-0f62-71c8-8abb-eab9bbaeb4d4#3</guid>
<category>ClipboardFusion</category>
<description><![CDATA[A good job Thomas. For use in countries where they use a comma as a decimal separator, you could add some text in the macro. The user has to change the dot in the middle (.\d+)?") of this line into a comma:
return Regex.Match(text, @"(\d+)(.\d+)?").ToString();
Even better would be a string vari...]]></description>
<content:encoded><![CDATA[<div class="CTDiscussions">
A good job Thomas. For use in countries where they use a comma as a decimal separator, you could add some text in the macro. The user has to change the dot in the middle (.\d+)?") of this line into a comma:<br/>
return Regex.Match(text, @"(\d+)(.\d+)?").ToString();<br/>
Even better would be a string variable at the top of the macro that can be set to "." or ",", but I do not know how to get the value of the string variable into the Regex-line.
</div>
]]></content:encoded>
</item>
<item>
<title>RE: Macro for Removing Text and Keep Only The Number and Vice Versa</title>
<link>https://www.clipboardfusion.com/Discussions/View/macro-for-removing-text-and-keep-only-the-number-and-vice-versa/?ID=018f40cb-0f62-71c8-8abb-eab9bbaeb4d4#2</link>
<pubDate>Mon, 06 May 2024 22:33:09 GMT</pubDate>
<dc:creator>Binary Fortress Software</dc:creator>
<guid isPermaLink="false">https://www.clipboardfusion.com/Discussions/View/macro-for-removing-text-and-keep-only-the-number-and-vice-versa/?ID=018f40cb-0f62-71c8-8abb-eab9bbaeb4d4#2</guid>
<category>ClipboardFusion</category>
<description><![CDATA[I put together a macro that should work for you. Here's how to get it into ClipboardFusion:
Download the file attached to this post
Open the ClipboardFusion Settings window
On the "Macros" tab, click the "Import" button
Select the file you downloaded in the first step
In the window that pops...]]></description>
<content:encoded><![CDATA[<div class="CTDiscussions">
I put together a macro that should work for you. Here's how to get it into ClipboardFusion:<br/>
<br/>
<ul class="ListBullet">
<li>Download the file attached to this post</li>
<li>Open the ClipboardFusion Settings window</li>
<li>On the "Macros" tab, click the "Import" button</li>
<li>Select the file you downloaded in the first step</li>
<li>In the window that pops up, you can review the code and assign the Macro a HotKey</li>
<li>Click OK to close the Macro Edit window, then OK again to save and apply your changes</li></ul>
</div>
]]></content:encoded>
</item>
<item>
<title>Macro for Removing Text and Keep Only The Number and Vice Versa</title>
<link>https://www.clipboardfusion.com/Discussions/View/macro-for-removing-text-and-keep-only-the-number-and-vice-versa/?ID=018f40cb-0f62-71c8-8abb-eab9bbaeb4d4</link>
<pubDate>Fri, 03 May 2024 23:30:01 GMT</pubDate>
<dc:creator>Binary Fortress Software</dc:creator>
<guid isPermaLink="false">https://www.clipboardfusion.com/Discussions/View/macro-for-removing-text-and-keep-only-the-number-and-vice-versa/?ID=018f40cb-0f62-71c8-8abb-eab9bbaeb4d4</guid>
<category>ClipboardFusion</category>
<description><![CDATA[Hello everyone! I often inputting only a number in a spreadsheet and it would be quicker if there is a faeture or macro perhaps, wondering if anyone would help creating it? Been searching in the available Macro in the ClipboardFusion but didn't find it yet.
Example : The text is "Purchasing on U...]]></description>
<content:encoded><![CDATA[<div class="CTDiscussions">
Hello everyone! I often inputting only a number in a spreadsheet and it would be quicker if there is a faeture or macro perhaps, wondering if anyone would help creating it? Been searching in the available Macro in the ClipboardFusion but didn't find it yet.<br/>
<br/>
Example : The text is "Purchasing on USD 950.54" and I want to copy only the number, ignoring the text to "950.54"<br/>
<br/>
Thank you in advance!
</div>
]]></content:encoded>
</item>
</channel>
</rss>