Remove number

[Kuldeep_Pandey]

Hi Team I have Text
2023-04-03.xlsm (72.0KB)
How to remove (72.0KB) this from text

[Jithesh_R (Jithesh Karkera)]

Hey @Kuldeep_Pandey ,
Try this ,

YourOurputVaribale = Split("2023-04-03.xlsm (72.0KB)"," ")(0).ToString

Output :

Regards,

[Gokul_Jayakumar (Gokul Jai)]

@Kuldeep_Pandey

2023-04-03.xlsm (72.0KB)

Hello @Kuldeep_Pandey
Try regex,

system.text.regularexpressions.Regex.match(Yourstring,".*(?=\()").tostring.trim

[Gokul001 (Gokul Balaji)]

HI @Kuldeep_Pandey

How about this Regular expression

System.Text.RegularExpressions.Regex.Replace(YourString,"(?<=xlsm\s)\S.*","").Tostring

Regards
Gokul

[Pratik_Sutar]

Hey @Kuldeep_Pandey ,
Try this ,

OutputVaribale = Left(InputString,InputString.IndexOf(“(”))

Regards,
Pratik

[Kuldeep_Pandey]

Input Text = “\10.33.105.155\RPA-Bot\Development Files\Easy-HUNG\20230406_G_16_222540-k\23.04.03_RW1_DU.xlsm”
I want Output like this 222540 Only thisno
How to get this

[Jithesh_R (Jithesh Karkera)]

Hey @Kuldeep_Pandey ,
If your Input is always in this format
“\10.33.105.155\RPA-Bot\Development Files\Easy-HUNG\20230406_G_16_222540-k\23.04.03_RW1_DU.xlsm”
then you can use

Split(Split("\10.33.105.155\RPA-Bot\Development Files\Easy-HUNG\20230406_G_16_222540-k\23.04.03_RW1_DU.xlsm","16_")(1),"-k")(0)

Output :

Regards,

[Gokul001 (Gokul Balaji)]

HI @Kuldeep_Pandey

How about this Regular expression?

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=_)\d{6}").Tostring

Regards
Gokul