Substring in microflow

0
How can I fetch the file name from the front end substring to get  substring(length(string) -7, length(string)-4 ). This means I want characters from 7 element from last till 5 element from last. Ex: intelligent.csv Here I want to only fetch ‘ent’   This is what I have done: [DocumentType= 'Meta_Data_File'][Name= substring('$Document/Name',6,3)] I am checking whether the document type = meta is present and than to take the substring of document name from the front end text box.  
asked
2 answers
1

Create a string variable before the retrieve activity.

Value of the string variable => substring($Document/Name,6,3)

Use the output string variable a constraint in your retrieve

[DocumentType= 'Meta_Data_File']

[Name= $StringVariable]

 

and if you are searching for all documents containing these 3 characters:

[DocumentType= 'Meta_Data_File']

[contains(Name= $StringVariable)]

 

answered
0

I don’t think this works in XPath statements. Use a Microflow instead. 

answered