How to merge data

ABC.xaml (13.7 KB)
I am not able to merge these highlighted two lines data in a single line on the basis of if the string starts with “ABC” and Ends With “ABC”. How to apply this condition

You can use Regular Expressions.

RegEX Condition= New RegEx(“ABC(.*?)ABC”,RegExOptions.Singleline)
Condition.Match("Your TXT file locaion).Groups(0)

The above code should fetch you the highlighted part, in which you can later remove the NewLine

This might be useful ABC.xaml (8.1 KB)

thanks Rajeev it helped me to solve my problem