User Tools

Site Tools


perseus:user:activities:matrixprocessing:rearrange:processtextcolumns

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
perseus:user:activities:matrixprocessing:rearrange:processtextcolumns [2015/11/23 14:47]
127.0.0.1 external edit
perseus:user:activities:matrixprocessing:rearrange:processtextcolumns [2017/07/12 11:24] (current)
rudolph
Line 16: Line 16:
  
 Here are a few examples. Here are a few examples.
-regex effect ​^+Regular expression ​Effect ​^
 | ''​^([^;​]+)''​ | Select all the characters from the beginning of the line, up to but not including the first semicolon. This is the default. | | ''​^([^;​]+)''​ | Select all the characters from the beginning of the line, up to but not including the first semicolon. This is the default. |
 | ''​TAG *= *([^,; ]*)''​ | Look for the first instance of "TAG = ", with any amount of whitespace (or none) around the equal sign, and return what follows after the whitespace until a comma or semicolon is reached. | | ''​TAG *= *([^,; ]*)''​ | Look for the first instance of "TAG = ", with any amount of whitespace (or none) around the equal sign, and return what follows after the whitespace until a comma or semicolon is reached. |
 | ''​([ACTG]+)''​ | return the first string consisting only of the letters A, C, T, and G. | | ''​([ACTG]+)''​ | return the first string consisting only of the letters A, C, T, and G. |
 | ''​(20[01][0-9]-[01][0-9]-[0-3][0-9])''​ | Select a date between 2000 and 2019 of the form 2014-08-19. | | ''​(20[01][0-9]-[01][0-9]-[0-3][0-9])''​ | Select a date between 2000 and 2019 of the form 2014-08-19. |
 +
 +==== Replacement string ====
 +You can provide a replacement string here for more flexibility. Leave empty if unsure.
 +
 +Examples
 +^ Replacement ^ Effect ^
 +| ''​$1''​ | Replace the original string with the first capture group, i.e. the part of the original string inside the first parentheses ''​(..)''​. |
  
 ==== Keep original columns ==== ==== Keep original columns ====
perseus/user/activities/matrixprocessing/rearrange/processtextcolumns.txt · Last modified: 2017/07/12 11:24 by rudolph