Jump to content

Substitutes and fmLog - AKA data validation


This topic is 2152 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Firstly, sorry if this is the wrong section of the forum but this was the best fit I could find.

I am currently using fmLog (https://app.works/tag/fmlog/) to keep an audit list for our dbs. It works great, except with certain characters. 

 

I believe this is the part that should be validating (removing) some chars that will break the script except it doesn't seem to be working. 

Let ( [
  n = Substitute ( Get (ScriptParameter) ; "¶" ; "\¶" );
  prefix = "$" ;
  e = PatternCount ( n ; " = " ) = 0 ;
  string = Substitute ( n ; 
    [ " ; " ; "\"; " & prefix ] ;
    [ " = " ; "= \"" ] 
) 
] ;
"Let ( [ " & prefix & string & "\" ] ; \"\" )" 

)

 

I know that a semicolon and equal sign will break it, but isn't this exactly what the above substitute is accounting for? Or am I missing something?

Thanks.

Link to comment
Share on other sites

This topic is 2152 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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