i have a bulk txt files in that file i have to scrap some specific text like branch,Association,INC and COMMUNITY, these find text are complete dynamic by using these text i wanted to get before two words of find text and after two two words of find text the whole text is Bank name Please help me with this
can you send the example of text file?
Yeah sure
00ae31ea81f1995946e0f7b7ecf50e8723f2736e456170858265850499c3e282-Branch PMG Houston.txt (2.0 KB)
what you need to extract from the file ?
Seven Meadows Community Assoc i have similar text like branch, asso and community
you can use a split method.
yourvariable.split({“30A”},stringsplitoptions.none)(1).tostring.split({“Account”},stringsplitoptions.none)(0).tostring.trim
can you explain how did you write it can actually help
hi you can aslo try with this below function
outputtxt=outputstr.split({“30A”,“Account”},stringsplitoptions.none)(1)
outputstr is the output of your text file
this function is to extract the words between the two strings
cheers
you can check this
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.