Formular takes out one character

[Inactive User]

Hi all,

by running this workflow, the formula tool is cutting off one character ")":

From

$excelObj.Workbooks.Open("C:\Users\Desktop\Papierkorb\Test\test2.xlsx")

 I expected to receive:

$excelObj.Workbooks.Open(\"C:\Desktop\Papierkorb\Test\test2.xlsx\")

Instead I received:

$excelObj.Workbooks.Open((\"C:\Desktop\Papierkorb\Test\test2.xlsx\"

--> the character ")" is missing

It worked with a different line in the array.

From $excelWorkSheet = $excelObj.WorkSheets.item("Sheet1")

The workflow produced:

$excelWorkSheet = $excelObj.WorkSheets.item(\"Sheet1\")

Thanks for your help

[Jonathan-Sherman · Accepted solution]

Hi @Inactive User,

Could you attach your workflow? It looks as though it could be the size of the field which is limiting the string and therefore removing the character.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[DiganP]

@Inactive User It could be the string length or you can just use another formula tool to add the parenthesis to the end of the string. Would you be able to share an example?