Changes

MetaData - Processing Rules - String Management

91 bytes added, 21:57, 7 February 2017

no edit summary

The append rule allows for any string to be appended to the end of an existing string stored in a Database field.

 

Required fields to execute rule:

# Field that contains the string to append the new string to

# New string to append

 

 

Example:

 

 

<tt>

Rule Name[[-SEP-]]Form Id[[-SEP-]]Destination field[[-SEP-]]Filed containing live value[[-SEP-]]String to append[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]

</tt>

 

 

Example (with replacement values):

 

 

<tt>

Append[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]]strCDA_1_field_0_2[[-SEP-]]Add This String To The End[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]

</tt>

 

 

== Prepend ==

 

The prepend rule allows for any string to be appended to the start 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 prepend the new string to5) # New string to append   

Example:

 

 

<tt>

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-]]

</tt>

 

 

Example (with replacement values):

 

 

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-]]

 9.4  == 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.

 

 

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 encapsulate the new string with5) # New string to append   

Example:

 

 

<tt>

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-]]

</tt>

 

 

Example (with replacement values):

 

 

<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>

 

 

 

9.5 == Remove Numbers== 

The remove numbers rule simply removes all numbers 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 number from5) # New string to append   

Example:

 

 

<tt>

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-]]

</tt>

 

 

Example (with replacement values):

 

 

<tt>

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-]]

 </tt>9.6   == 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.

• ← Older edit
• Newer edit →

Philip Lacey

Anonymous, bureaucrat, administrator

7,528

edits