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