Check Position of My Word and Delete Lines before and after it's related line

[Dave (David Wiebelhaus)]

Sounds good - although the issue is solved, I’d still recommend taking a look at the .xaml I uploaded for the reasons I mentioned in the previous comment

[hsendel]

@Dave, I use it unfortunately it’s not working, no changes for the input file !!!

[Dave (David Wiebelhaus)]

My uploaded file isn’t changing the input file. It is using a write line activity to output the string selected. Feel free to add a ‘write text file’ activity to save it back to a text file if that’s the desired output. I would recommend NOT changing the input file though, and instead creating a separate output file

[hsendel]

I know what you mean, but there is not output even in “Write Line”:

[Dave (David Wiebelhaus)]

Did you make sure to change the file name so it matches your file? Make sure to include the full file path instead of relative path if needed (E.g. “C:\temp\myfolder\myfile.txt” instead of just “myfile.txt”)

Did you also make sure to update the if statement so it matches the word you’re looking for? Make sure it is written in all CAPS in your if statement since it is using str.ToUpper() on the input text

Everything worked perfectly when I tested it. See the below 2 areas where you have to make sure it matches your file name & word

[hsendel]

@hsendel

I know what you mean, but there is not output even in “Write Line”:

Of course I did those changes , otherwise it will report an error instead of not showing anything:

[Dave (David Wiebelhaus)]

In the if statement, change to “ABERKAN”

It is not catching it because it is checking the input string.ToUpper() so all are upper case characters. The .Contains() method is case-sensitive in it’s comparison, so i always recommnd converting both the input string and the string you want to check to upper case to ensure you find the words.

The .ToUpper() portion is a trick to keep in mind for this project & future projects as it will help prevent some troubleshooting headaches, especially if your input is a free-form text

[hsendel]

Excellent idea @Dave, YES definitely, when removing this ToUpper, I’m able to get output

[NIVED_NAMBIAR (NIVED N)]

Great @Dave​:clap:

[hsendel]

Thanks both for your efforts and ideas, I appreciate