Open main menu

Changes

MetaData - Processing Rules - String Management

797 bytes added, 22:07, 7 February 2017
no edit summary
# Field that contains the string to prepend the new string to
# New string to append
 
Example:
  <ttsyntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination field[[-SEP-]]Filed containing live value[[-SEP-]]String to prepend[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</ttsyntaxhighlight> 
Example (with replacement values):
 <syntaxhighlight lang="xml">
Prepend[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]]Add This String To The Start[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
== Encapsulate ==
 
The encapsulate rule allows for any string to be to be added to and surround the contents of an existing string stored in a Database field.
# Field that contains the string to encapsulate the new string with
# New string to append
 
Example:
  <ttsyntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination field[[-SEP-]]Filed containing live value[[-SEP-]]String to encapsulate[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</ttsyntaxhighlight> 
Example (with replacement values):
<syntaxhighlight lang="xml">
Encapsulate[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]]Surround With This[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
<tt>
Encapsulate[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]]Surround With This[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</tt>
 
== Remove Numbers ==
# Field that contains the string to remove number from
# New string to append
 
Example:
  <ttsyntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination field[[-SEP-]]Filed containing live value[[-SEP-]] [[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</ttsyntaxhighlight> 
Example (with replacement values):
  <ttsyntaxhighlight lang="xml">
RemoveNumbers[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</ttsyntaxhighlight>
== Strip Tags ==
 
The strip tags rule simply removes all HTML tags (<br/>, <b>, <table>, </table> etc.) from the contents of an existing string stored in a Database field.
 
Required fields to execute rule:
1) # Rule Name2) # Form id (the same as the current sequence)3) # Field to store the end result4) # Field that contains the string to remove HTML tags from5) # New string to append  
Example:
<syntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination field[[-SEP-]]Filed containing live value[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
Example (with replacement values):
<syntaxhighlight lang="xml">
StripTags[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
9.7  == Replace== 
The replace rule simply allows for the replacement of a string with another from the contents of an existing string stored in a Database field.
 
Required fields to execute rule:
1) # Rule Name2) # Form id (the same as the current sequence)3) # Field to store the end result4) # Field that contains the string to attempt the replacement on5) # Value to search for6) # Value to replace with  
Example:
<syntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination field[[-SEP-]]Filed containing live value[[-SEP-]]Field to attempt replacement on[[-SEP-]]Value to search for[[-SEP-]]Value to Replace with[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
Example (with replacement values):
<syntaxhighlight lang="xml">
Replace[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]] strCDA_1_field_0_3[[-SEP-]]Find This[[-SEP-]]Replace With This[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
9.8  == Concatenation== 
The concatenation rule simply allows for the combining of the contents of one database field with another within the same record of the same database
 
Required fields to execute rule:
1) # Rule Name2) # Form id (the same as the current sequence)3) # Field to store the end result4) # Form id (the same as the current sequence)5) # First field to be concatenated6) # Form id (the same as the current sequence)7) # Spacer (string to separate the two fields)8) # Form id (the same as the current sequence)9) # Second filed to be concatenated 
Example:
<syntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination Field[[-SEP-]]Form Id[[-SEP-]]First Field[[-SEP-]][[-SEP-]]Form Id[[-SEP-]][[-SEP-]]Spacer[[-SEP-]]Form Id[[-SEP-]]Second Field[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
Example (with replacement values):
<syntaxhighlight lang="xml">
Concat[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]][[-SEP-]]1[[-SEP-]][[-SEP-]] - [[-SEP-]]1[[-SEP-]]strCDA_1_field_0_3[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
 
 
9.9 == Read From== 
The read from rule simply allows for the for the searching of a string for a search sting and if found remove every character before and including the search string
 
Required fields to execute rule:
1) # Rule Name2) # Form id (the same as the current sequence)3) # Field to store the end result4) # Form id (the same as the current sequence)5) # Field to perform the searching on6) # Value to search with 
Example:
<syntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination field[[-SEP-]]Form ID[[-SEP-]]Field To Search [[-SEP-]]Value To Search For[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
Example (with replacement values):
<syntaxhighlight lang="xml">
ReadFrom[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]1[[-SEP-]]strCDA_428_field_0_2[[-SEP-]]Find This[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]] 
9.10 </syntaxhighlight>   == Read Until== 
The read until rule simply allows for the for the searching of a string for a search sting and if found remove every character after and including the search string
 
Required fields to execute rule:
1) # Rule Name2) # Form id (the same as the current sequence)3) # Field to store the end result4) # Form id (the same as the current sequence)5) # Field to perform the searching on6) # Value to search with 
Example:
<syntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination field[[-SEP-]]Form ID[[-SEP-]]Field To Search [[-SEP-]]Value To Search For[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
Example (with replacement values):
<syntaxhighlight lang="xml">
ReadUntil[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]1[[-SEP-]]strCDA_428_field_0_2[[-SEP-]]Find This[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]] 
9.11 </syntaxhighlight>   == Set Value== 
The set value rule simply allows for a database field to be updated with a new string, defined in the MetaData Program.
 
Required fields to execute rule:
1) # Rule Name2) # Form id (the same as the current sequence)3) # Field to store the end result4) # Form id (the same as the current sequence)5) # Value to insert 
Example:
<syntaxhighlight lang="xml">
Rule Name[[-SEP-]]Form ID[[-SEP-]]Destination Field[[-SEP-]]Form Id[[-SEP-]][[-SEP-]]Value To Insert[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
 
Example (with replacement values):
<syntaxhighlight lang="xml">
SetValue[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]1[[-SEP-]][[-SEP-]]Add This Value[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
</syntaxhighlight>
Philip Lacey
Anonymous, bureaucrat, administrator
7,528
edits
Retrieved from ‘https://www.bxpsoftware.com/wixi/index.php/Special:MobileDiff/7371’