I have a text in which I need to extract the total, Eg Total : $100 abc Else Total abc def # 234 Here the only static thing is total, I need to extract the number and i don’t know what will be the text between the total and the number, whose are excluded In 1st sentence i want 100 In 2nd sente…

@Sweety_Girl Give a try on (?<=Total)\D*([\d,,.]*) and take value from group1 from each match [grafik]

Extraction using regex

ppr (Peter Preuss) April 6, 2020, 10:22am 12

@Sweety_Girl
Example of accesing Group1 for the first match
grafik

Groups in Regular Expressions

Topic		Replies	Views
Help with Regex to get a value Studio studio , question , activities_panel	6	949	November 3, 2021
Extraction using the regex Learning Hub	14	1060	April 13, 2020
RegEx, convert to int, add Studio activities , regex , question	18	2171	March 23, 2020
Regex to extract a number between a dynamic number Studio studio , regex	12	2637	August 16, 2021
Can some one help me to extract the following text Studio studio , question , project_panel	5	533	November 23, 2022