By a simple drag and drop we drop the icon ''.String of charactersto the desired location in the column ''.Properties''. Or ''Double click'' on the icon ''.String of characters''.

This type of property allows you to retrieve a part of a property (unlike the type ''Concatenation'').

For example get the first 3 characters etc...


 


You can also start the search at the beginning or at the end of the property value and specify the number of characters to retrieve or the character to search.

Let's take the case of the property ''Ref'' to be filled in :

If the value of the property ''.Supplier'' is equal to : ''DMS-PowerFull-'', in the area ''Retrieve characters up to n starting''.

  • "Retrieve the first n characters" :

 


    • By checking ''From the beginning'' and asking  3   this indicates that the first 3 characters will be retrieved.

This gives ''Ref'' equal to ''DMS''.


    • By checking ''From the end'' and asking 5   this indicates that the last 5 characters will be retrieved.

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


    • By checking ''Between the'' 5 ''and the'' 10   this indicates that the string between the 5th and the 10th character will be retrieved.

This gives ''Ref'' equal to ''Power''.


  • ''Retrieve the first characters up to n by starting the search'' :

Another example, in a Windows path if we want to retrieve 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 asking for the character ''/'' this indicates that we will recover all the characters from the beginning to the first character ''./''.

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


    • By checking ''at the end'' :

By checking ''at the end'' and asking for the character ''/'' this indicates that we will recover all the characters from the end to the first character ''./''.

This gives ''Ref'' equal to ''SmartProperties/310-122-Cover''.


    • By checking ''Split'' :

This is a special case that will allow to treat the properties filled following a special syntax. For example if the property ''.Supplier'' indicates 3 available suppliers coming from 3 different countries, a separator character will be used (example '':'') to separate the values.

''Supplier'' = Visiativ Switzerland:Visiativ:Aliativ


  


This gives ''Ref'' equal to ''Visiativ''.


  • "Retrieve characters from n by starting the search":

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

    • By checking "at the beginning" :

 

The value retrieved from the beginning of the string to the "-", which gives "Ref"equal to"300".


    • By checking "at the end" :

 

The value retrieved from the end of the string to the "-", which gives "Ref"equal to"1000".

If you want to retrieve the value between the characters "-"If you want to use the previous option by checking "Split".


  • "Replace:

You can also replace characters of an existing property value: Example replace the character "-"by the character "space".