This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
So hopefully this is a really simple one, thanks in advance! So i've pulled the directory for a given share drive which is \\smb.waunas21f..... etc. Now it is then being passed to a macro where it is going to update a formula. But it gives the error attached:
I'm sorry, but it is not possible to determine what is wrong based on the information provided. We need to see the data that is going into the macro, what is the tool that is being updated within the macro, how it is being updated, and what operation is being performed with that data within the macro. What it looks like is that you are trying to get the date from the file name and do something with it, and the format or type of the data does not match what you are trying to do.
looks like my company blocked the screenshots. I am passing the directory field from the directory tool. it goes into a macro where it updates the assigned formula. what that formula is doing is creating a new field called "keydir" and basically filling down the records with the value in quotes "\\smb.waunas21f....." with the new row of data being passed to it. In the macro, it is using action tool and control tool on the formula, replacing the text in the formula to the new directory value. It is a V_WString
The issue is probably on the formula, the value that is coming from the control parameter is not what the expression is expecting to receive. Maybe the data type. I would only be able to fix this by seeing the actual data.
the error is Apply Keydir (28) Record#1: Tool#6: Parse Error at char(0): Parse Error (Expression #1) and it continues through all the records. the confusing thing is that the workflow passes "Directory" field from directory tool and character "0" is "\" from the string \\smb.waunas21f.hcsc... etc.
It is a bit trickier to troubleshoot without the data. One option to test would be changing your double quotations to single quotations in the expression of the formula that sits in the batch macro for the "KeyDir"