Macro Error

[bilalkhan01]

Ran into an issue with a macro “a field was missing a closing quote in record 70381” does anyone know how to amend this?

Thanks :)

[abacon]

It depends on what the macro is doing. It sounds like you are doing something with csv files but it is hard to tell with the information given.

[OTrieger]

@bilalkhan01 

It seems that you are processing a formatted text file, can be csv, xml or any other delaminated format.

Now in these files the quotes marks are indicating the beginning and ending of text holder, or in other words the text for that specific.

You are getting this error as something is violating this rule, Alteryx is expecting to have "nnnnn","kkkkkkkk","lllllll" etc. but if you have a forbidden character or symbol in the text one or more of these text holders will be broken and then Alteryx cannot find the beginning and end.

Another reason for it can be that you transformed the data and then delete some part of the place holders or added additional ones that violating the structure.

In the error message you should have a number, that should indicate for you where the error is. 

[bilalkhan01]

Sorry didn't see this earlier didn't get any notification for some reason. But thanks for the reply appreciate it. i changed the configuration in the macro before it had 'ignore delimiters in quotes' and i changed it to 'ignore delimiters in none' and that seemed to fix it. i'm not sure why though lol

[abacon]

@bilalkhan01 All good, most likely, the field was a free text field and someone typed in the character that was being used as the delimiter. I have had that happen many times, it's a pain.