Sanitize Form Position

[RockwareTRT]

HI, I am very new to this, but oh so excited this exists as it has been a need at the company for awhile.

I have 3 large files that used to be one project. I now have to merge them back together smoothing over their variations, so I am looking to see which objects have altered versions.

308 forms are coming up as modified, but it looks like most of them may be position information. I was hoping the sanitize option might remove these items so I can compare form objects existence and vba code, but I did not manage to achieve this. Is this a feature that exists or on the Road Map?

I may be able to update the sanitize feature if it is not an option, but as I said I am new to this. Would setting these values to 0 still allow them to be built from? Our files always dynamically places the form location on open, so it would not be an issue for us and I do not plan to build from text files at this point.

Note, the following since the only difference is the Left property i would like these to be considered the unmodified.

Version =20
VersionRequired =20
Begin Form
PopUp = NotDefault
RecordSelectors = NotDefault
AutoCenter = NotDefault
NavigationButtons = NotDefault
AllowDeletions = NotDefault
DividingLines = NotDefault
AllowAdditions = NotDefault
AllowDesignChanges = NotDefault
DefaultView =0
AllowUpdating =4
ScrollBars =0
TabularFamily =0
PictureAlignment =2
DatasheetGridlinesBehavior =3
GridX =24
GridY =24
Width =5730
DatasheetFontHeight =10
ItemSuffix =43
Left =3225
Top =3030
Right =28545
Bottom =15015
AfterInsert ="[Event Procedure]"
ShortcutMenuBar ="Form Popup1"
RecSrcDt = Begin
0x76f04d4092eae540
End
Caption ="Scrap Summary [frmDataMaintRC]"

---VS --

Version =20

VersionRequired =20
Begin Form
PopUp = NotDefault
RecordSelectors = NotDefault
AutoCenter = NotDefault
NavigationButtons = NotDefault
AllowDeletions = NotDefault
DividingLines = NotDefault
AllowAdditions = NotDefault
AllowDesignChanges = NotDefault
DefaultView =0
AllowUpdating =4
ScrollBars =0
TabularFamily =0
PictureAlignment =2
DatasheetGridlinesBehavior =3
GridX =24
GridY =24
Width =5730
DatasheetFontHeight =10
ItemSuffix =43
Left =5730
Top =3030
Right =28545
Bottom =15015
AfterInsert ="[Event Procedure]"
ShortcutMenuBar ="Form Popup1"
RecSrcDt = Begin
0x76f04d4092eae540
End
Caption ="Scrap Summary [frmDataMaintRC]"

[RockwareTRT]

I created a function for my uses. Maybe it will help?

    ' Build the final output
    strContent = BuildOutput(varLines)
''Call New Sanitize function
   strContent = ReplaceProperties(strContent)

Public Function ReplaceProperties(inputText As String) As String
    Dim regex As Object
    Dim matches As Object
    Dim match As Variant
    Dim formSection As String
    Dim formMod As String
    
    ' Initialize the regex object
    Set regex = CreateObject("VBScript.RegExp")
    regex.Global = True
    regex.IgnoreCase = True
    
    ' Check if the "Begin Report|Form" section exists
    regex.Pattern = "Begin (Report|Form)[\s\S]*?End"
    If regex.Test(inputText) Then
        formSection = regex.Execute(inputText)(0).Value
		formMod=formSection
        
        ' Replace the matched properties within the "Begin Report|Form" section
        regex.Pattern = "\b(Left|Top|Right|Bottom)\s*=\s*-?\d+"
        Set matches = regex.Execute(formSection)
        For Each match In matches
            formMod = Replace(formMod, match.Value, match.SubMatches(0) & " =0")
        Next match
        
        ' Replace the original "Begin Report|Form" section with the modified one
        inputText = Replace(inputText, formSection, formMod)
    End If
    
    ReplaceProperties = inputText
    Set regex = Nothing
End Function