String Dynamically Change The Valus And Extension

imran shaik

New Member
EX: 123.QWE.234.ABC.XLSX OR 234.677.DDD.CVH.PDF OR 786.GDU.783.DHD.CSV

This Type Of String Dynamically change the Numeric Values And Alphabetic Then Finally Extension Will add In One Variable And Other Values Will Add In One Variable

Thise is The Scenario Can u Please Any One Solution But Clearly Explain


Regards,
Your Friend
 

duynd9

New Member
i think can use regular expression then use spit. or first use spit then use regular expression add to one variable

good luck ! sr my english is not good
 

Sachin_Kharmale

Active Member
EX: 123.QWE.234.ABC.XLSX OR 234.677.DDD.CVH.PDF OR 786.GDU.783.DHD.CSV
This Type Of String Dynamically change the Numeric Values And Alphabetic Then Finally Extension Will add In One Variable And Other Values Will Add In One Variable

Thise is The Scenario Can u Please Any One Solution But Clearly Explain


Regards,
Your Friend

Hi Imaran,

To stored the text in two data items just follow the following steps so you can store the extension in 1 data item and remaining string in another data item,

1.Use split text of Utility String to get the extension separate like .pdf .csv it will give split values collection as output.
2. Count the row of the input collection and store in Row Count data item.
3.Read the filed value from the collection of input collection and give field name and index as a input.

4. Delete the characters from string and it will return text and then store in second data item named as Data item 2.

Design flow like bellow so you can get the data in two data item
File extension in one data item and remaining text in one data item.


View attachment 1563265645373.png

I hope it will help you.
 
Last edited:
Top