Hi all, i have find the specific text for bulk files which are complete dynamic

Help Activities
, ,
1

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

2

can you send the example of text file?

3

Yeah sure
00ae31ea81f1995946e0f7b7ecf50e8723f2736e456170858265850499c3e282-Branch PMG Houston.txt (2.0 KB)

4

what you need to extract from the file ?

5

Seven Meadows Community Assoc i have similar text like branch, asso and community

6

you can use a split method.

yourvariable.split({“30A”},stringsplitoptions.none)(1).tostring.split({“Account”},stringsplitoptions.none)(0).tostring.trim

7

can you explain how did you write it can actually help

8

@Lava_Salagala

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

9

image
you can check this

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.