RegexPattern

Help Studio
, ,
1

Text_str=
"Basic 27563 330750
HRA 13781 165375
Lunch Allowance 2500 30000
Transport Allowance 1600 19200
Medical Allowance 2085 25020
Special Allowance 23588 283056
Flexi Benefits Plan* 3000 36000
Monthly Gross (A) 74117 889401
Statutory Benefits ©

Employer PF 3308 39690
Gratuity (As per Act) 1326 15909
Total CTC (A+C) 78750 ‘945000
Medical Insurance ™! 5000

950000"

This is my text
I taken all digit values expect Total CTC since it have 'symbol before digit How to resolve it?

2

HI @sathya_auto

How about this expression? Correct me if im wrong Based on my understanding you need the CTC number Right?

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=\+\S\)\s)\S.+").Tostring

image
image397×526 27.7 KB

Regards
Gokul

3

grafik
grafik448×520 29.1 KB

\d[\d\s\S]+?$
4

Anchoring on total:

grafik
grafik514×597 28.3 KB 

(?<=Total CTC.*?)\d[\d\s\S]+?$
5

Not resolved
Total CTC (A+C) 78750 ‘945000 i have to extract

6

Not resolved
Total CTC (A+C) 78750 ‘945000 i have to extract

7

is different from

maybe you are looking for the following or you will resharp your requirement description

grafik
grafik459×523 28 KB

grafik

8

Text_str=
"Basic 27563 330750
HRA 13781 165375
Lunch Allowance 2500 30000
Transport Allowance 1600 19200
Medical Allowance 2085 25020
Special Allowance 23588 283056
Flexi Benefits Plan* 3000 36000
Monthly Gross (A) 74117 889401
Statutory Benefits ©

Employer PF 3308 39690
Gratuity (As per Act) 1326 15909
Total CTC (A+C) 78750 ‘945000
Medical Insurance ™! 5000

950000"

I have to extract Total CTC (A+C) 78750 ‘945000

9

see above:

10

Thankyou ppr

11

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