Hi , i have different File names– like—HDFC_ 57500000634417.xlsx,HDFC_ 57500000637417.xlsx i want to split file name like–> HDFC 4417, HDFC 7417. this split file name i have to create sheet name in excel. How to Split ?

@Anand_Designer You can take first four character and last four character from file name Assign str_variable = sampleData.Substring(0,4) + " " + sampleData.Substring(sampleData.Length - 4) [image]

Split File Name of Excel File to create sheet name

Help Studio

ppr (Peter Preuss) February 18, 2022, 9:44am 5

grafik

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

1 Like

Topic		Replies	Views
Split String \| Compare Two Excel File Name Help	11	1267	August 17, 2019
How to split characters Help	7	2082	July 4, 2019
How to split character Help	9	1213	July 4, 2019
Spilt Name Help	2	1176	July 19, 2019
Split file name from the String Help	9	4294	December 7, 2018

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

Split File Name of Excel File to create sheet name

Related Topics