How to extract a substring from a "/" to "." ?

[EvoticTalend]

Hello everyone, I've had a difficult day searching how to extract a string from a "/" to a ".".

Example: https://ilursei.com/photos/1943/161317/077666rtryfggghvbvnfggfh46546rtrtrg4_123.jpg

I want to extract only the large series of numbers "

077666rtryfggghvbvnfggfh46546rtrtrg4_123" to before ".jpg"

I tried tExtractRegexFields, some StringHandlings functions like CHANGE or eExtract but none result.

[EvoticTalend]

Hi again Prakhar! Thank you for the response.

--I have already this flow:

--In the JavaFlex I have your code with the correct name of the column.

int first,second; String text;

first = (row5.url_video).lastIndexOf("/");

second = (row5.url_video).lastIndexOf(".");

text = (row5.url_video).substring(first+1, second);

--In the tMap this is the view:

 

The problem now is this row6.url_video isn't the code I extracted in the JavaFlex, is the entire column (the link).

I think Im doing something wrong in the process from JavaFlex to tMap. What is the column in the tMap transformed in the JavaFlex?

Sorry for the questions, but I never worked in a process like this, extracting and sending to a DDBB, thanks.

[Prakhar1]

You have to goto edit schema of tJavaFlex and add a column as "text".

Now add one more line in the code

first = (row5.url_video).lastIndexOf("/");

second = (row5.url_video).lastIndexOf(".");

text = (row5.url_video).substring(first+1, second);

row6.text = text; ##new_line

Remember to write this code in the main part of tJavaFlex

Now after that you will see a new column "text" in tMap, use it to join with the other file column

[EvoticTalend]

Thank You Prakhar, seems working.! Resolved.