Jump to content
Sign in to follow this  

Find and Replace script step failure

Recommended Posts

I apologize if i am in the wrong group for this question........

I have a script which has been running fine for years (every 15 minutes), suddenly it has quit working properly - no code changes were made. Basically the script imports a tab delimited file (each field has double quote marks around the data) into a table. Once the data is in the table a 'Replace all' is used to strip off all the double quotes from the data.

The issue now is approximately the top half of the fields in the table get the quote marks removed and in the bottom half they remain. What is interesting is this issue does not present itself when running the script using FM Pro Advanced (11v2) only when running FM pro (11v2). While the two instances of FM are running on different servers both are running Windows Server 2008R2.

I have tried re-writing the script, running multiple steps of find/replace, exporting/importing the semi-completed data and trying another find/replace on it, and various other work-arounds within FM all to no avail. I also do not see any type of special characters in the data which would cause this to occur.

Does any one have any suggestions or ideas of what might have happened to cause this to occur or how to work around it.



Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.