How to replace the "C;" to "C:" for excel save

Help Activities
, ,
1

UIPath Error

Hi Everyone,

Can you please help to replace the highlighted string with “:” string.
I have used replace function in the text but it woun’t work.

Thank you !

2

Hi @Karampuri_Sathish1 ,

The syntax is yourstring.Replace(“C;”,“C:”)

Could you please provide more details about your workflow or about what exactly isn’t working? Perhaps the issue is somewhere else

Best regards,
Marius

3

Hi Marius,

When the insert image in excel It give error. below is workflow.

UIPath Error

Function i am using is : Environment.CurrentDirectory+“"+row.Item(1).ToString+”.png".ToString.Replace(“;”,“:”)

4

I think you want to replace earlier, not to the PNG part. Anyway it looks like a workaround, why you have semikolon after drive letter?

5

Hi Moenk,

I am always getting “;” character when i insert image. i want to insert “:” character instead of “;”.

6

Hi @Karampuri_Sathish1 ,

It seems to be enough:
Environment.CurrentDirectory+"\"+row.Item(1).ToString+".png"

7

Hi Marius,

Initially i have enter this one only but when try to insert image in excel. Then i got “;” instead of “:”.

I want like this "c:" instead of "c;" or “c;|” i got these error.

8

UIPath Error

This is the error i have recieved.

9

Hi @Karampuri_Sathish1 ,

Environment.CurrentDirectory will return the path where your .xaml file is located, and I’m not sure that your images are there

I would replace Environment.CurrentDirectory with some kind of a constant, the directory where your images are

Best regards,
Marius

10

Hi @Marius_Puscasu Yes i have store same place where .xaml file stored.

11

@Karampuri_Sathish1

IF you are still getting as C; then follow as below

image
image1112×549 22.3 KB

I’m getting C: as required, but in your case you are saying it is displaying as C;

Then as above assign entire path to a variable and try to replace as you required

Hope this helps you

Thanks

1 Like
12

Hi @Srini84 I am getting same error still. Can you please suggest another solution.

13

Try with this:

(Environment.CurrentDirectory+"\"+row.Item(1).ToString+".png").Replace(";",":")
14

I have tried this but still i am getting same error.

16

It seems like it’s a bug with the Type Into activity. Have you tested to change the input method to SimulateType or SendWindowMessages?

image

1 Like
17

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