Extract repeated string from text file

Help
1

Hi all,
I am trying to extract some data in a text file. I tried to use my data.Split({“special”,”good”},StringSplitOptions.None) to extract data between words special and good. However, these two words appear many times in the text file and I only want to extract the latest data. My logic is to count how many times they appear and only choose the last time to extract, but I dun know how to write it…

Anyone can help!

Many thanks.

2

Hi @raymondhui,

Use regular expression
write pattern for that & get the data

3

Hi @varunk

Pattern = “special”?
But I dun want to get all of the result but only the last one.

4

Hi @raymondhui,

You need to write pattern according to groups,then latest means from file starting or ending
According to that you can take that group

5

Hi @varunk

I am not familiar with regular expression, especially patterns, would you mind share more about it?

Many thanks

6 
data.Split({“special”,”good”},StringSplitOptions.None)(data.Split({“special”,”good”},StringSplitOptions.None).Length-2)

Simply take the second last item in your array.

7

Use

(?<=special)(.*?)(?=good)
in matches activity you will get an IEnumerable of Matches.
in that you can use Variable.LastOrDefault

8

Hi @Vijay_Tulsalkar

Thx bro but actually I need to extract data between first one and last one. Would u like to show me the steps?

Thanks

9

@raymondhui

can you explain with an example. can you share the TEXT here and the end result required?

10

@Vijay_Tulsalkar

Sorry mate can’t upload the text file right now and only can upload the image for your reference.

image
image2598×2020 2.56 MB
image
image2607×1996 2.35 MB

Attached you can find Identifier Report EL-888 and last pages TRANSATION TOTAL RECORD. Supposed this one is the result and these data are captured from a raw text files.

Many thanks

11

Have your tried this?

data.Split({“special”,”good”},StringSplitOptions.None)(data.Split({“special”,”good”},StringSplitOptions.None).Length-2)

12

Hi @HalmiNordin
Yes but it’s not returning value I want

13

What value do you actually want?

14

Would upload txt file later thx mate

15

@raymondhui.

I’m still confused, as per my understanding just try out this approach.

  1. Split with special then take the lastordefault index of it and store in variable.
  2. then split the variable with good and take the first index value.

the code might look something like this

variable1.Split({“special”},StringSplitOptions.RemoveEmptyEntries).Last.ToString.Split({“good”},StringSplitOptions.RemoveEmptyEntries)(0)