By a simple Drag and drop one deposits the icon ''Character string'' with the site desired in the column ''Properties“. Or '' Double to click” on the icon ''Character string''.

This kind of property makes it possible to recover part of a property (contrary to the '' typeConcatenation'').

For example to recover the first 3 characters etc…


 


One can also begin research at the beginning or at the end of the value of the property and one specifies the number of characters to be recovered or the character to be searched.

Let us take the case of the property ''Ref.'' to be informed:

If the value of the property ''Supplier'' is equal to: ''DMS-PowerFull-'', in the zone ''To recover the characters to N starting''.

  • To recover N first characters“:

 


    • By checking ''Beginning'' and while asking 3 that indicates that the first 3 characters will be recovered.

What gives ''Ref.'' equal to ''DMS''.


    • By checking ''End'' and while asking 5 that indicates that the last 5 characters will be recovered.

What gives ''Ref.'' equal to ''Full-''.


    • By checking ''Between'' 5 ''and it'' 10 that indicates that one will recover the character string ranging between 5th and 10th character.

What gives ''Ref.'' equal to ''Power''.


  • ''To recover the first characters to N by beginning research'':

Another example, in a Windows way if one wishes to recover the characters according to the position of the character ''/''.

''310/SmartProperties/310-122-Couvercle''


 


    • By checking ''at the beginning'' :

By checking ''at the beginning'' and by asking the character ''/'' that indicates that one will recover all the characters since the beginning and until the first character ''/''.

What gives ''Ref.'' equal to ''310'' (corresponding to the number of project for example).


    • By checking ''at the end'' :

By checking ''at the end'' and by asking the character ''/'' that indicates that one will recover all the characters since the beginning and until the last character ''/''.

What gives ''Ref.'' equal to ''310/SmartProperties''.


    • By checking ''Split'' :

It is a typical case which will make it possible to process the properties indicated according to a special syntax. For example if the property ''Supplier'' informs 3 suppliers available coming from 3 different countries one will use a separating character ('' example:'') in order to separate the values.

“Supplier” = Visiativ Switzerland: Visiativ: Aliativ


  


What gives ''Ref.'' equal to ''Visiativ''.


  • “To recover the characters starting from N by beginning research”:

If the value of the property ''Supplier'' is equal to: ''300-PowerFull-1000''

    • While checking “at the beginning :


 

The value recovered since the beginning of the chain until the character “-“, which gives”Ref.“equal to”300“.


    • While checking “at the end :


 

The value recovered since the end of the chain until the character “-“, which gives”Ref.“equal to”1000“.

If one wishes to recover the value located between the characters “-“, one will use the preceding option while checking”Split“.


  • “Replace”:

One can also replace characters of a value of existing property: Example to replace the character “-“by the character”space“.