Useful regular expressions (Regex) - Revision history

John: added FR regex to move currency symbol arround

2023-05-03T11:24:56Z

added FR regex to move currency symbol arround

John: Added currency conversion regex

2023-04-05T08:06:41Z

Added currency conversion regex

Cheeseus at 16:55, 2 June 2021

2021-06-02T16:55:54Z

Jamie: Reorganized page and added major section regarding numbers in a specific format

2021-05-14T22:54:40Z

Reorganized page and added major section regarding numbers in a specific format

Show changes

John at 10:21, 11 May 2021

2021-05-11T10:21:22Z

John at 10:12, 11 May 2021

2021-05-11T10:12:43Z

John: added (1,000s)

2021-04-22T19:23:08Z

added (1,000s)

David Daduč at 20:58, 16 April 2021

2021-04-16T20:58:37Z

John: /* Show only number-only segments */

2019-07-12T14:57:36Z

‎Show only number-only segments

John at 13:44, 17 May 2019

2019-05-17T13:44:52Z

@@ Line 232: / Line 232: @@
 Note that this regular expression assumes that the input string always has the same format with three groups of digits separated by spaces and followed by the Euro symbol.
 ==References==
 [[Category:Wordfast Pro]]

@@ Line 212: / Line 212: @@
 '''NOTE''': This only works for values up to 999. Values in the thousands will need another regex operation to replace comma/space/decimal with comma/space/decimal.
 ==References==
 [[Category:Wordfast Pro]]

← Older revision		Revision as of 16:55, 2 June 2021
Line 1:		Line 1:
−	A '''regular expression (regex or regexp)''' is a sequence of characters that define a search pattern.<ref>Check out [https://en.wikipedia.org/wiki/Regular_expression#Basic_concepts this article] for a more detailed explanation of the history of regular expressions and how they work.</ref> They can be very helpful in the Editor View for both the filter bar (used to show/hide specific segments) and the Find/Replace dialog. Below are a few examples of useful regexes. In order to use them in [[Wordfast Pro]], make sure any available '''regex''' option is enabled accordingly.	+	A '''regular expression (regex''' or '''regexp)''' is a sequence of characters that define a search pattern.<ref>Check out [https://en.wikipedia.org/wiki/Regular_expression#Basic_concepts this article] for a more detailed explanation of the history of regular expressions and how they work.</ref> They can be very helpful in the Editor View for both the filter bar (used to show/hide specific segments) and the Find/Replace dialog. Below are a few examples of useful regexes. In order to use them in [[Wordfast Pro]], make sure any available '''regex''' option is enabled accordingly.

	==Filter Bar: Showing/Hiding Certain Segments==		==Filter Bar: Showing/Hiding Certain Segments==

← Older revision		Revision as of 10:21, 11 May 2021
Line 46:		Line 46:
	$1,$2		$1,$2

−	Make sure to search ~~Target~~ segments only ~~and~~ test on a few segments before replacing all.	+	Make sure to search target segments only, test on a few segments before replacing all, and run this operation twice to account for numbers in the millions.

← Older revision		Revision as of 10:12, 11 May 2021
Line 36:		Line 36:


		+	==Find thousands separated by a non-breaking space and replace NBSP with a comma==
		+
		+	Find:
		+
		+	(\d{1,3})∘(\d{3})
		+
		+	Replace with:
		+
		+	$1,$2
		+
		+	Make sure to search Target segments only and test on a few segments before replacing all.
		+
		+
	==Invert currency symbols==		==Invert currency symbols==

← Older revision		Revision as of 19:23, 22 April 2021
Line 20:		Line 20:
	# Find '''DUMMY''' and replace with ''','''		# Find '''DUMMY''' and replace with ''','''

		+
		+	==Show only thousands, ten thousands or hundred thousands surrounded by parentheses==
		+
		+	If you negative monetary figures in a financial report, they are generally surrounded by parentheses like this (1,234) or (10,123) or (100,123).
		+
		+	Use the following regex in the segment filtering bar to filter out these segments when the divider is a non-breaking space:
		+
		+	\(\d{1,3}∘\d{3}\)
		+
		+	And this one if the divider is a comma:
		+
		+	\(\d{1,3},\d{3}\)
		+
		+	With the filter in place, copy all sources, then find ∘ and replace with , or vice versa. (∘ represents a non-breaking space).
		+
		+
	==Invert currency symbols==		==Invert currency symbols==

@@ Line 1: / Line 1: @@
-A regular expression (regex or regexp) is a sequence of characters that define a search pattern. They can be very helpful for filtering out segments in the TXLF Editor or for find/replace operations. Check out [https://en.wikipedia.org/wiki/Regular_expression#Basic_concepts this article] for a more detailed explanation of the history of regular expressions and how they work.
+A '''regular expression (regex or regexp)''' is a sequence of characters that define a search pattern.<ref>Check out [https://en.wikipedia.org/wiki/Regular_expression#Basic_concepts this article] for a more detailed explanation of the history of regular expressions and how they work.</ref> They can be very helpful for filtering out segments in the TXLF Editor or for find/replace operations. Below are a few examples of useful regex. When you use them in [[Wordfast Pro]], make sure to tick the '''regex''' box accordingly.
 ==Hide all number-only segments==
@@ Line 12: / Line 5: @@
 Use the following regex in the segment filtering bar:
-^(([0-9][^\n]*[^0-9])|([^0-9][^\n]*[0-9])|([^0-9]?[^\n]*[^0-9]))$
+ ^(([0-9][^\n]*[^0-9])|([^0-9][^\n]*[0-9])|([^0-9]?[^\n]*[^0-9]))$
 This regex will also hide numbers with punctuation (decimals, etc.)
 ==Show only number-only segments==
@@ Line 21: / Line 13: @@
 Use the following regex in the segment filtering bar:
-^(?:(?:-|–|(?:(?:\$|€|£)(?:\h)?))?(?:\d{1,3})(?:\h|,|\.|(?:(?:\h)?(?:%|\$|€|£)))?)+$
+ ^(?:(?:-|–|(?:(?:\$|€|£)(?:\h)?))?(?:\d{1,3})(?:\h|,|\.|(?:(?:\h)?(?:%|\$|€|£)))?)+$
 If you have numbers like 8,675,309.00 that need to be replaced with 8.675.309,00, you can copy all sources to target with the filter applied, then apply a 3-step find and replace:
@@ Line 36: / Line 28: @@
 Type the following regex in the ''Find what'' field:
-(^[^,]+?)(,)([^€]+?)(€)
+ (^[^,]+?)(,)([^€]+?)(€)
 Type the following regex in the ''Replace with'' field:
-\€$1\.$3
+ \€$1\.$3
-----
+'''NOTE''': This only works for values up to 999. Values in the thousands will need another regex operation to replace comma/space/decimal with comma/space/decimal.
---[[User:John|John]], 17 May 2019
+==References==
-[[Category:Wordfast Pro 5]]
+[[Category:Wordfast Pro]]

@@ Line 24: / Line 24: @@
 If you have numbers like 8,675,309.00 that need to be replaced with 8.675.309,00, you can copy all sources to target with the filter applied, then apply a 3-step find and replace:
-. Find . and replace with DUMMY
+# Find '''.''' and replace with '''DUMMY'''
-. Find , and replace with .
+# Find ''',''' and replace with '''.'''
-. Find DUMMY and replace with ,
+# Find '''DUMMY''' and replace with ''','''
 ==Invert currency symbols==

← Older revision		Revision as of 13:44, 17 May 2019
Line 44:		Line 44:

	'''NOTE''': This only works for values up to 999. Values in the thousands will need another regex operation to replace comma/space/decimal with comma/space/decimal.		'''NOTE''': This only works for values up to 999. Values in the thousands will need another regex operation to replace comma/space/decimal with comma/space/decimal.
		+

	----		----