Formular takes out one character

unknown

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

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