How to manipulate a string in a file Path

Help Studio
, ,
1

Hi,

I have this file path: C:\Users\carla-89\Downloads\convocatoria.xls (‘ExcelPath’ variable)

And I want to substract “convocatoria.xls” because each file i will wanna download will have a different name file. I try do:
StrExcelPath = ExcelPath.ToString
StrSplitExcelPath = StrExcelPath.split(""c).ToString

and then StrSplitExcelPath(4)

And only output and ‘e’.

What i need to do to extract only ‘convocatoria.xls’?

2

Hi @Carla_Munoz

Try this for without extension:
filename = System.IO.Path.GetFileNameWithoutExtension(“path”)

For with extension:
filename = path.GetFileName(“path”)
or
filename = System.IO.Path.GetFileName(“path”)

Regards,

1 Like
3

@Carla_Munoz
Try this

path.GetFileName(ExcelPath)

this will give you file name with extension

1 Like
4

HI @Carla_Munoz

How about this expression?

filename =Path.GetFileName(“C:\Users\carla-89\Downloads\convocatoria.xls ”)

Regards
Gokul

1 Like
5

@Carla_Munoz ,
If you want to get the filename with extension you can use

FileName= Path.GetFileName("FilePath")

Regards,

1 Like
6

hi @Carla_Munoz
Split(ExcelPath.tostring,“Downloads\”)(1)

1 Like
7

Hi @Carla_Munoz
Try this using split function

image
image929×530 18.7 KB

1 Like
8

Hello, what type of variable is FileName because is giving me an error

9

@Carla_Munoz

The filename variable is a “String” type

1 Like
10

@Carla_Munoz Its Type will be string type. It will return String

1 Like
11

Hi @Carla_Munoz

You can use the Split function to split the output. Split by using "".

- Assign -> StrFileName = StrExcelpath.Split("\").Last

Hope it helps!!

12

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