ComparePlus - improve alignment of similar lines
-
Could the similar line alignment be improved?
File 1:Changed database context to 'TcEng'. INDEX_NAME TABLE_NAME avg_fragmentation_in_percent ---------- ---------- ---------------------------- ACCT_TABLE_INDEX ACCT_TABLE 100.0 ACCT_TABLE_INDEX ACCT_TABLE 62.148458872879807 ACCT_TABLE_INDEX2 ACCT_TABLE 100.0 ACCT_TABLE_INDEX2 ACCT_TABLE 39.810607669115463 ACCT_TABLE_INDEX3 ACCT_TABLE 100.0 ACCT_TABLE_INDEX3 ACCT_TABLE 59.226190476190474 ACCT_TABLE_INDEX4 ACCT_TABLE 52.72727272727272 ACCT_TABLE_INDEX4 ACCT_TABLE 10.735930735930737 PIPABSOCCDATA PABSOCCDATA 88.099315068493155 PIPABSOCCDATA_0 PABSOCCDATA 100.0 PIPABSOCCDATA_0 PABSOCCDATA 16.308868157806003 PIPABSOCCDATA_1 PABSOCCDATA 100.0 PIPABSOCCDATA_1 PABSOCCDATA 18.891488213064601 PIPABSOCCDATA_2 PABSOCCDATA 27.108433734939759 PIPABSOCCDATA_3 PABSOCCDATA 100.0 PIPABSOCCDATA_3 PABSOCCDATA 16.308868157806003 PIPABSOCCURRENCE PABSOCCURRENCE 100.0 PIPABSOCCURRENCE PABSOCCURRENCE 18.972656651038637 PIPABSOCCURRENC_0 PABSOCCURRENCE 100.0 PIPABSOCCURRENC_0 PABSOCCURRENCE 22.343792386291707 PIPANCHOR PANCHOR 100.0 PIPAWB0BOOKMARKPR PAWB0BOOKMARKPRODUCTDATA 86.36363636363636 PIPBOM_VIEW_TAGS PBOM_VIEW_TAGS 10.158572844400396 PIPBOM_VIEW_TAG_0 PBOM_VIEW_TAGS 100.0 PIPBOM_VIEW_TAG_0 PBOM_VIEW_TAGS 11.677160847166572 PIPBVRSYNCINFOSTO PBVRSYNCINFOSTORAGE 33.468559837728193 PIPCOMPONENTRELAT PCOMPONENTRELATION 70.769230769230774 PIPCONFIGURATIONC PCONFIGURATIONCONTEXT 30.275229357798167 PIPCONTENTS PCONTENTS 72.549019607843135 PIPCONTENTS_0 PCONTENTS 98.888888888888886 PIPDATASET PDATASET 99.562937062937067 PIPDATASET PDATASET 10.581832803626609 PIPDATASET_0 PDATASET 97.680412371134011 PIPDATASET_0 PDATASET 34.140778956225226 PIPDATASET_1 PDATASET 100.0 PIPDATASET_1 PDATASET 35.913163486604304 PIPDISPATCHERREQU PDISPATCHERREQUEST 96.875 PIPDOUBLE_ATTRS PDOUBLE_ATTRS 92.43421052631578 PIPDOUBLE_ATTRS_0 PDOUBLE_ATTRS 98.014888337468989 PIPDOUBLE_KEYS PDOUBLE_KEYS 91.129883843716996 PIPDOUBLE_KEYS_0 PDOUBLE_KEYS 99.926578560939788 PIPEPMJOB PEPMJOB 100.0 PIPEPMJOB_0 PEPMJOB 88.235294117647058 PIPEPMJOB_0 PEPMJOB 11.084765856550089 PIPEPMJOB_1 PEPMJOB 100.0 PIPEPMJOB_1 PEPMJOB 13.901869158878505 PIPEPMTASK PEPMTASK 86.666666666666671 PIPEPMTASK_0 PEPMTASK 100.0 PIPEPMTASK_1 PEPMTASK 100.0 PIPEPMTASK_1 PEPMTASK 10.943223443223443 PIPEPMTASK_2 PEPMTASK 92.592592592592595 PIPEPMTASK_3 PEPMTASK 88.461538461538453 PIPEPMTASK_4 PEPMTASK 79.166666666666657 PIPFERTIGUNGSTEIL PFERTIGUNGSTEIL 10.7981220657277 PIPFND0COLUMNORDE PFND0COLUMNORDERREL 14.285714285714285 PIPFND0DETAILEDME PFND0DETAILEDMESSAGE 10.334346504559271 PIPFND0DETAILED_0 PFND0DETAILEDMESSAGES 86.956521739130437 PIPFND0DETAILED_1 PFND0DETAILEDMESSAGES 85.714285714285708 PIPFND0EPMRELEASESTATUS PFND0EPMRELEASESTATUS 27.543859649122808 PIPFND0EPMTARGET PFND0EPMTARGET 100.0 PIPFND0EPMTARGET PFND0EPMTARGET 19.604679306171843 PIPFND0GENERALAUD PFND0GENERALAUDIT 100.0 PIPFND0GENERALAUD PFND0GENERALAUDIT 93.144132653061234 PIPFND0GENERALA_1 PFND0GENERALAUDIT 94.819020581973035 PIPFND0GENERALA_2 PFND0GENERALAUDIT 27.871939736346519 PIPFND0GENERALA_4 PFND0GENERALAUDIT 99.750623441396513 PIPFND0GENERALA_4 PFND0GENERALAUDIT 22.779854066559885 PIPFND0PREFERENCEVALUE PFND0PREFERENCEVALUE 15.098468271334792 PIPFND0STRINGVALUES PFND0STRINGVALUES 26.048284625158828 PIPFND0SYNC_CHE_1 PFND0SYNC_CHECKSUMS_0 14.399999999999999 PIPFND0SYNC_CHE_2 PFND0SYNC_CHECKSUMS_0 99.082568807339456 PIPFND0SYNC_CHE_2 PFND0SYNC_CHECKSUMS_0 33.799454297407912 PIPFND0TABLEROW PFND0TABLEROW 70.588235294117652 PIPFND0TABLEROW_0 PFND0TABLEROW 92.5 PIPFND0TABLEROW_1 PFND0TABLEROW 97.560975609756099 PIPFND0WORKFLOWAU PFND0WORKFLOWAUDIT 84.732052578361987 PIPFND0WORKFLOW_2 PFND0WORKFLOWAUDIT 58.103975535168196 PIPFND0WORKFLOW_3 PFND0WORKFLOWAUDIT 53.627760252365931 PIPFND0WORKFLOW_4 PFND0WORKFLOWAUDIT 50.279329608938554 PIPFND0WORKFLOW_5 PFND0WORKFLOWAUDIT 88.461538461538453 PIPFND0WORKFLOW_5 PFND0WORKFLOWAUDIT 12.838492858527758 PIPFND0WORKFLOW_6 PFND0WORKFLOWAUDIT 85.534591194968556 PIPFND0WORKFLOW_6 PFND0WORKFLOWAUDIT 19.25112529059702 PIPFND0WORKFLOW_7 PFND0WORKFLOWAUDIT 87.2340425531915 PIPFND0WORKFLOW_7 PFND0WORKFLOWAUDIT 14.521224445332074 PIPFND0WORKFLOW_8 PFND0WORKFLOWAUDIT 99.680511182108617 PIPFND0WORKFLOW_8 PFND0WORKFLOWAUDIT 14.127559888158391 PIPFND0WORKFLOW_9 PFND0WORKFLOWAUDIT 76.422764227642276 PIPFND0WORKFLOW_9 PFND0WORKFLOWAUDIT 14.726827942375644 PIPFND0WORKFLO_10 PFND0WORKFLOWAUDIT 84.126984126984127 PIPFND0WORKFLO_10 PFND0WORKFLOWAUDIT 10.677808727948005 PIPFOLDER PFOLDER 17.356321839080461 PIPFORM PFORM 99.724517906336089 PIPFORM PFORM 10.393827246700649 PIPFORM_0 PFORM 96.986301369863014 PIPFORM_0 PFORM 13.184079601990051 PIPFORM_1 PFORM 98.709677419354833 PIPFORM_1 PFORM 14.228241585247009 PIPGDEBVR_0 PGDEBVR 16.216216216216218 PIPGDEOCCURRENCE PGDEOCCURRENCE 66.037735849056602 PIPGDEOCCURRENC_0 PGDEOCCURRENCE 93.333333333333329 PIPGDEOCCURRENC_1 PGDEOCCURRENCE 69.565217391304344 PIPGDE_BVR_LIST PGDE_BVR_LIST 12.923076923076923 PIPGDE_BVR_LIST_0 PGDE_BVR_LIST 19.587628865979383 PIPGENERALDESIGNE PGENERALDESIGNELEMENT 99.200000000000003 PIPHISTORYDATES PHISTORYDATES 98.214285714285708 PIPHISTORYDATES_0 PHISTORYDATES 56.410256410256409 PIPHISTORYSTATES PHISTORYSTATES 96.491228070175438 PIPHISTORYSTATE_0 PHISTORYSTATES 94.117647058823522 PIPIMANFILE PIMANFILE 99.851301115241625 PIPIMANFILE PIMANFILE 16.196216642578047 PIPIMANFILE_0 PIMANFILE 75.490196078431367 PIPIMANFILE_0 PIMANFILE 27.883565797453002 PIPIMANFILE_1 PIMANFILE 99.238578680203048 PIPIMANFILE_1 PIMANFILE 58.788244766505635 PIPIMANRELATION PIMANRELATION 99.908172635445354 PIPIMANRELATION PIMANRELATION 19.57794465915994 PIPIMANRELATION_0 PIMANRELATION 98.711340206185568 PIPIMANRELATION_0 PIMANRELATION 93.75 PIPIMANRELATION_1 PIMANRELATION 99.908172635445354 PIPIMANRELATION_1 PIMANRELATION 19.191821180953724 PIPIMANRELATION_2 PIMANRELATION 97.297297297297305 PIPIMANRELATION_2 PIMANRELATION 96.149217809867622 PIPIMANRELATION_3 PIMANRELATION 97.058823529411768 PIPIMANRELATION_3 PIMANRELATION 96.607431340872381 PIPIMANRELATION_4 PIMANRELATION 97.237196765498652 PIPIMANRELATION_4 PIMANRELATION 96.774193548387103 PIPIMANRELATION_5 PIMANRELATION 97.368421052631575 PIPIMANRELATION_5 PIMANRELATION 96.242861436729783 PIPIMANRELATION_6 PIMANRELATION 96.774193548387103 PIPIMANRELATION_6 PIMANRELATION 96.466093600764097 PIPIMANRELATION_7 PIMANRELATION 96.774193548387103 PIPIMANRELATION_7 PIMANRELATION 96.466093600764097 PIPIMANRELATION_8 PIMANRELATION 97.435897435897431 PIPIMANRELATION_8 PIMANRELATION 95.499134448932494 PIPIMANRELATION_9 PIMANRELATION 99.915469146238379 PIPIMANRELATION_9 PIMANRELATION 19.66985199655069 PIPIMANRESERVATIO PIMANRESERVATION 95.652173913043484 PIPINT_ATTRS PINT_ATTRS 92.818863879957121 PIPINT_ATTRS_0 PINT_ATTRS 99.550763701707098 PIPINT_KEYS PINT_KEYS 88.831168831168824 PIPINT_KEYS_0 PINT_KEYS 99.733333333333334 PIPINT_KEYS_0 PINT_KEYS 94.117647058823522 PIPITEM PITEM 99.047619047619051 PIPITEMREVISION PITEMREVISION 84.033613445378151 PIPITEMREVISION_0 PITEMREVISION 98.305084745762713 PIPITEMREVISION_1 PITEMREVISION 96.774193548387103 PIPITEMREVISION_1 PITEMREVISION 12.307692307692308 PIPITEMREVISION_2 PITEMREVISION 93.333333333333329 PIPITEMREVISION_3 PITEMREVISION 96.551724137931032 PIPITEMREVISION_4 PITEMREVISION 98.305084745762713 PIPITEM_0 PITEM 25.925925925925924 PIPITEM_1 PITEM 30.76923076923077 PIPJH4_EMAILFORMS PJH4_EMAILFORMSTORAGE 10.526315789473683 PIPMEAPPEARANCEPATHNODE PMEAPPEARANCEPATHNODE 99.376947040498436 PIPMEAPPEARANCEPATHNODE PMEAPPEARANCEPATHNODE 15.743427415809371 PIPMEAPPEARANCEPATHNODE_0 PMEAPPEARANCEPATHNODE 24.615384615384617 PIPMEAPPEARANCEPATHNODE_1 PMEAPPEARANCEPATHNODE 10.507246376811594 PIPMEAPPEARANCEPATHNODE_2 PMEAPPEARANCEPATHNODE 13.294797687861271 PIPMEAPPEARANCE_0 PMEAPPEARANCEPATHROOT 10.24390243902439 PIPMEAPPEARANCE_2 PMEAPPEARANCEPATHNODE 96.623376623376629 PIPMEAPPEARANCE_3 PMEAPPEARANCEPATHNODE 100.0 PIPMEAPPEARANCE_3 PMEAPPEARANCEPATHNODE 21.289956044613223 PIPMEAPPEARANCE_6 PMEAPPEARANCEPATHNODE 99.705882352941174 PIPMEAPPEARANCE_6 PMEAPPEARANCEPATHNODE 17.488775541370146 PIPMEAPPEARANCE_7 PMEAPPEARANCEPATHNODE 24.226804123711339 PIPMEAPPEARANCE_8 PMEAPPEARANCEPATHNODE 13.872832369942195 PIPMEAPPEARANCE_9 PMEAPPEARANCEPATHROOT 10.46228710462287 PIPMENXOBJECT PMENXOBJECT 100.0 PIPMEOP PMEOP 30.526315789473685 PIPMEOPREVISION PMEOPREVISION 18.326118326118326 PIPMEPROCESSMASTE PMEPROCESSMASTER 22.318339100346023 PIPMEPROCESSVERSI PMEPROCESSVERSIONMASTER 20.945945945945947 PIPNC_PROGRAMMS PNC_PROGRAMMS 23.809523809523807 PIPNC_PROGRAMMS_0 PNC_PROGRAMMS 41.666666666666671 PIPNOTE_TEXTS PNOTE_TEXTS 100.0 PIPNOTE_TEXTS_0 PNOTE_TEXTS 91.05263157894737 PIPNOTE_TEXTS_0 PNOTE_TEXTS 12.069124423963133 PIPNOTE_TEXTS_1 PNOTE_TEXTS 89.774236387782196 PIPNOTE_TEXTS_1 PNOTE_TEXTS 12.076856914664864 PIPNOTE_TYPES PNOTE_TYPES 100.0 PIPNOTE_TYPES_0 PNOTE_TYPES 99.876543209876544 PIPNOTE_TYPES_0 PNOTE_TYPES 14.790600048219426 PIPNX0APPLICATI_0 PNX0APPLICATIONINFOSTORAGE 15.652818991097922 PIPNX0MATERIALSSPECIFICATIONS PNX0MATERIALSSPECIFICATIONS 71.844660194174764 PIPNX0MATERIALSSPECIFICATION_0 PNX0MATERIALSSPECIFICATIONS 90.0 PIPNX0PARTINFOFLAGS_0_0 PNX0PARTINFOFLAGS_0 100.0 PIPNX0PARTINFOFLAGS_0_0 PNX0PARTINFOFLAGS_0 39.37912490833537 PIPNX0PARTINFOFLAGS_0_1 PNX0PARTINFOFLAGS_0 100.0 PIPNX0PARTINFOFLAGS_0_1 PNX0PARTINFOFLAGS_0 51.189885969261283 PIPNX0PARTINFOFLAGS_1 PNX0PARTINFOFLAGS_1 23.1622746185853 PIPNX0PARTINFOFLAGS_1_0 PNX0PARTINFOFLAGS_1 29.074889867841406 PIPOCCURRENCE_LIS POCCURRENCE_LIST 44.444444444444443 PIPOM_BACKPOINTER POM_BACKPOINTER 100.0 PIPOM_BACKPOINTER POM_BACKPOINTER 99.854073773814349 PIPOM_BACKPOINTER2 POM_BACKPOINTER 100.0 PIPOM_BACKPOINTER2 POM_BACKPOINTER 98.65960801982429 PIPOM_BACKPOINTER2 POM_BACKPOINTER 15.841266142809079 PIPOM_KEY POM_KEY 23.684210526315788 PIPOM_KEY_1 POM_KEY 23.684210526315788 PIPOM_KEY_2 POM_KEY 20.634920634920633 PIPOM_KEY_3 POM_KEY 20.0 PIPPOM_APPLICATION_OBJECT PPOM_APPLICATION_OBJECT 100.0 PIPPOM_APPLICATION_OBJECT PPOM_APPLICATION_OBJECT 99.805783340526546 PIPPOM_APPLICATION_OBJECT_0 PPOM_APPLICATION_OBJECT 100.0 PIPPOM_APPLICATION_OBJECT_0 PPOM_APPLICATION_OBJECT 27.59525124240751 PIPPOM_APPLICAT_1 PPOM_APPLICATION_OBJECT 80.83554376657824 PIPPOM_APPLICAT_1 PPOM_APPLICATION_OBJECT 23.949413091607838 PIPPOM_APPLICAT_2 PPOM_APPLICATION_OBJECT 94.684579439252332 PIPPOM_APPLICAT_2 PPOM_APPLICATION_OBJECT 31.035156543566156 PIPPOM_APPLICAT_3 PPOM_APPLICATION_OBJECT 19.444444444444446 PIPPOM_APPLICAT_4 PPOM_APPLICATION_OBJECT 87.358490566037744 PIPPOM_APPLICAT_4 PPOM_APPLICATION_OBJECT 26.36766220391349 PIPPOM_APPLICAT_5 PPOM_APPLICATION_OBJECT 13.44 PIPPOM_OBJECT PPOM_OBJECT 100.0 PIPPOM_OBJECT PPOM_OBJECT 100.0 PIPPOM_OBJECT PPOM_OBJECT 15.238634154603597 PIPPOM_OBJECT_1 PPOM_OBJECT 100.0 PIPPOM_OBJECT_1 PPOM_OBJECT 100.0 PIPPOM_OBJECT_2 PPOM_OBJECT 99.959563283461378 PIPPOM_OBJECT_2 PPOM_OBJECT 27.863678001081571 PIPPRIMARYOBJECTS PPRIMARYOBJECTS 94.444444444444443 PIPPRODUKT_0_REVISION_ALT0 PPRODUKT_0_REVISION_ALT0 27.777777777777779 PIPPROJECT_LIST PPROJECT_LIST 80.0 PIPPROJECT_LIST_0 PPROJECT_LIST 47.368421052631575 PIPPROPAGATION_OB PPROPAGATION_OBJ_LIST 62.5 PIPPROPAGATION__0 PPROPAGATION_OBJ_LIST 97.777777777777771 PIPPSBOMVIEW PPSBOMVIEW 94.73684210526315 PIPPSBOMVIEWREVIS PPSBOMVIEWREVISION 95.238095238095227 PIPPSBOMVIEWREV_0 PPSBOMVIEWREVISION 94.117647058823522 PIPPSBOMVIEWREV_0 PPSBOMVIEWREVISION 11.78909952606635 PIPPSBOMVIEW_0 PPSBOMVIEW 96.774193548387103 PIPPSBOMVIEW_1 PPSBOMVIEW 93.75 PIPPSBOMVIEW_1 PPSBOMVIEW 12.921348314606742 PIPPSOCCURRENCE PPSOCCURRENCE 91.48642429820525 PIPPSOCCURRENCENO PPSOCCURRENCENOTES 99.526066350710892 PIPPSOCCURRENCENO PPSOCCURRENCENOTES 19.769673704414586 PIPPSOCCURRENCETH PPSOCCURRENCETHREAD 99.601593625498012 PIPPSOCCURRENCETH PPSOCCURRENCETHREAD 16.024869142112895 PIPPSOCCURRENCE_1 PPSOCCURRENCE 76.223776223776213 PIPPSOCCURRENCE_2 PPSOCCURRENCE 99.716713881019828 PIPPSOCCURRENCE_2 PPSOCCURRENCE 16.018433691457762 PIPPSOCCURRENCE_3 PPSOCCURRENCE 99.716713881019828 PIPPSOCCURRENCE_3 PPSOCCURRENCE 16.768950074639243 PIPPSOCCURRENCE_4 PPSOCCURRENCE 99.716713881019828 PIPPSOCCURRENCE_4 PPSOCCURRENCE 16.803493932609118 PIPPSOCCURRENCE_5 PPSOCCURRENCE 99.716713881019828 PIPPSOCCURRENCE_5 PPSOCCURRENCE 16.789672996655334 PIPPSOCCURRENCE_6 PPSOCCURRENCE 99.259259259259252 PIPPSOCCURRENCE_6 PPSOCCURRENCE 11.691416300318066 PIPPSOCCURRENCE_7 PPSOCCURRENCE 99.259259259259252 PIPPSOCCURRENCE_7 PPSOCCURRENCE 12.408685474431932 PIPPSOCCURRENCE_8 PPSOCCURRENCE 98.95988112927192 PIPPSOCCURRENCE_8 PPSOCCURRENCE 12.348345681006116 PIPPSOCCURRENCE_9 PPSOCCURRENCE 99.716713881019828 PIPPSOCCURRENCE_9 PPSOCCURRENCE 16.808093092678071 PIPREF_LIST_0_0 PREF_LIST_0 99.833887043189378 PIPREF_LIST_0_0 PREF_LIST_0 14.904086395729596 PIPREF_LIST_0_1 PREF_LIST_0 99.940440738534846 PIPREF_LIST_0_1 PREF_LIST_0 93.75 PIPREF_LIST_0_1 PREF_LIST_0 29.075747046560114 PIPREF_NAMES_0_0 PREF_NAMES_0 99.908340971585702 PIPREF_NAMES_0_0 PREF_NAMES_0 16.341340695634223 PIPREF_NAMES_0_1 PREF_NAMES_0 99.143206854345166 PIPREF_NAMES_0_1 PREF_NAMES_0 37.913394687380247 PIPREF_TYPES PREF_TYPES 99.878787878787875 PIPREF_TYPES PREF_TYPES 24.669650122050449 PIPREF_TYPES_0 PREF_TYPES 99.891657638136508 PIPREF_TYPES_0 PREF_TYPES 26.811511272701662 PIPRELEASESTATUS PRELEASESTATUS 95.238095238095227 PIPRELEASESTATU_0 PRELEASESTATUS 95.238095238095227 PIPRELEASESTATU_0 PRELEASESTATUS 10.944340212632895 PIPRELEASE_STATUS PRELEASE_STATUS_LIST 99.481865284974091 PIPRELEASE_STATUS PRELEASE_STATUS_LIST 17.251919508023725 PIPRELEASE_STAT_0 PRELEASE_STATUS_LIST 74.178403755868544 (337 Zeilen betroffen)File 2:
Changed database context to 'TcEng'. INDEX_NAME TABLE_NAME avg_fragmentation_in_percent ---------- ---------- ---------------------------- ACCT_TABLE_INDEX ACCT_TABLE 89.86486486486487 ACCT_TABLE_INDEX2 ACCT_TABLE 70.634920634920633 ACCT_TABLE_INDEX3 ACCT_TABLE 100.0 PIPDATASET_0 PDATASET 10.952380952380953 PIPEPMJOB PEPMJOB 11.76470588235294 PIPEPMTASK_0 PEPMTASK 12.5 PIPEPMTASK_2 PEPMTASK 12.5 PIPEPMTASK_3 PEPMTASK 23.52941176470588 PIPEPMTASK_4 PEPMTASK 12.5 PIPFND0EPMTARGET PFND0EPMTARGET 12.5 PIPFND0WORKFLOW_6 PFND0WORKFLOWAUDIT 11.458333333333332 PIPFND0WORKFLOW_9 PFND0WORKFLOWAUDIT 11.25 PIPIMANFILE PIMANFILE 10.01410437235543 PIPIMANFILE_0 PIMANFILE 15.196078431372548 PIPIMANFILE_1 PIMANFILE 21.171171171171171 PIPIMANRELATION_2 PIMANRELATION 11.111111111111111 PIPIMANRELATION_5 PIMANRELATION 11.111111111111111 PIPIMANRELATION_8 PIMANRELATION 10.526315789473683 PIPOM_BACKPOINTER POM_BACKPOINTER 85.964912280701753 PIPOM_BACKPOINTER2 POM_BACKPOINTER 82.5 PIPPOM_OBJECT PPOM_OBJECT 82.608695652173907 PIPPOM_OBJECT_1 PPOM_OBJECT 82.608695652173907 PIPPOM_OBJECT_2 PPOM_OBJECT 13.920240782543267 PIPREF_LIST_0_1 PREF_LIST_0 12.192393736017896 PIPREF_NAMES_0_1 PREF_NAMES_0 12.400455062571103 PIPREF_TYPES PREF_TYPES 11.643835616438356 PIPREF_TYPES_0 PREF_TYPES 10.472279260780287 PIPREVISIONANCHOR PREVISIONANCHOR 34.0 PIPREVISIONS_0 PREVISIONS 25.085910652920962 PIPVALUES_0_1 PVALUES_0 42.105263157894733 PIPWORKSPACEOBJECT_1 PWORKSPACEOBJECT 13.398692810457517 PIPWORKSPACEOBJ_4 PWORKSPACEOBJECT 11.282051282051283 pipom_timestamp POM_TIMESTAMP 100.0 pipom_timestamp POM_TIMESTAMP 10.284167794316645 sipom_timestamp POM_TIMESTAMP 100.0 sipom_timestamp POM_TIMESTAMP 11.285846438482887 (36 Zeilen betroffen)The similar lines are often aligned without the numerical suffix, like PIPDATASET and PIPDATASET_0, even when there is PIPDATASET_0 on the next line.
Thanks in advance for a fix. -
@Stefan-Pendl
Have you submitted an issue in the repo? -
@Mark-Olson
no, I am not a github member.
Just wanted to check if it would be considered. -
@Stefan-Pendl
Without an official issue at github, the chances of it being considered are zero. (With an official issue at gihub, the chances are only slightly higher.) -
Yeah, after looking at your proposal again, I strongly suspect that this particular feature proposal would not be accepted. AFAIK, ComparePlus does not use its own algorithms to calculate alignments and diffs; I think it just uses external dependencies for that. I could be wrong, but if I’m right, changes like you propose would require the core devs to hack some dependencies, which tends to be rather hairy and error-prone.
-
Hello, @stefan-pendl, @mark-olson, @tbugreporter and All,
I’ve tried to understand what @stefan-pendl meant but, even with the help of the
Compare Plusplugin, I could not understand which kind of alignment was desired :-((@stefan-pendl, could you try to shorten your
File_1, to the approximative number of lines ofFile_2, in order to easily identify where alignments must occur, when running theCompare Plusplugin ?Best Regards,
guy038
-
@guy038
The problem is, that if I shorten the file, the issue is gone.
It only happens when the files are really different. -
@Stefan-Pendl said in ComparePlus - improve alignment of similar lines:
It only happens when the files are really different.
Well then, that’s the problem. Diff/alignment algorithms try their best, but if two files are really different, you shouldn’t be too surprised if it seems like the alignment is bad. Even Git’s diff algorithm, which is probably the best around, produces diffs/alignment that seem suboptimal when the diff is big.
-
@Stefan-Pendl said in ComparePlus - improve alignment of similar lines:
I am not completely sure I understand the right way you mean about Improve alignment but maybe these suggestions can be also useful:
replace spaces with tabs and install and activate the Elastic Tab Stop Plugin: with it is possible to get alignment like the following screenshot:
If you prefer you can use another plugin: CsvQuery to get alignment as the following screenshot:
Right click on CsvQuery plugin window and show the line numbers like the following screenshot is also possible:
with CsvQuery You can also query the database using SQL syntax to filter the rows using criteria you need.
-
@wonkawilly
Thanks for that, but I did not mean the alignment of columns, but the alignment of the diff result => lines starting with the same word should be aligned, not lines with a similar word. -
@Stefan-Pendl IMO, not the correct plugin for the job. Try PythonScript plugin.
- Open the 2 documents in separate views (view1 (main) and view2 (extra)).
- Run the script named
DBMergeReport.pyand it will open a new tab on the focused view with the merged report.
import re def db_merge_report(): def get_dic(text): dic = {} for m in re.finditer(r'^(\w+ \w+) ([\d.]+)\r{0,1}$', text, re.M): k = m.group(1) dic[k] = m.group(2) return dic text1 = editor1.getText() text2 = editor2.getText() dic_a = get_dic(text1) dic_b = get_dic(text2) names = set(dic_a) | set(dic_b) names = sorted(names) length = max(len(item) for item in names) text1 = '' for name in names: a, b = '', '' if name in dic_a: a = dic_a[name] if name in dic_b: b = dic_b[name] text1 += ('{:<' + str(length + 1) + '} {:<20} {}\n').format(name, a, b) if text1: notepad.new() editor.addText(text1) if __name__ == '__main__': db_merge_report()New document tab with just the 1st 5 lines as an example.
ACCT_TABLE_INDEX ACCT_TABLE 62.148458872879807 89.86486486486487 ACCT_TABLE_INDEX2 ACCT_TABLE 39.810607669115463 70.634920634920633 ACCT_TABLE_INDEX3 ACCT_TABLE 59.226190476190474 100.0 ACCT_TABLE_INDEX4 ACCT_TABLE 10.735930735930737 PIPABSOCCDATA PABSOCCDATA 88.099315068493155The spacing is quite wide for the 1st column as the largest value is 58 characters. This might make comparison of the data being in 1 document alittle easier as the float numbers are next to each other.
-
Hello @Stefan-Pendl ,
I will check your case and if some improvements could be made but it might take time.
Could you please in the meantime tell me which lines should be aligned according to your expectations (except lines PIPDATASET_0 - I already got that)?
Thanks.BR
-
@pnedev said in ComparePlus - improve alignment of similar lines:
Could you please in the meantime tell me which lines should be aligned according to your expectations
Hello again @Stefan-Pendl ,
I analyzed your example data and I understand what you would expect as a result of the comparison. Please disregard my request for further clarifications.
BR
-
@pnedev
Thanks for checking this issue.
If you need more data just ask. -
Hello @Stefan-Pendl ,
I have just released ComparePlus v1.2.0 - it has a bug-fix for and overall improved changed lines detection algo - your example files compare as expected now.
It doesn’t mean that now the plugin will always consider the most intuitive lines as changed in all cases (that is simply not possible because of the different scenarios and user expectations) but it does a much better job now.I am sorry about the long time it took for releasing this update - there were also other pending issues that required attention and I didn’t had enough spare time to work on ComparePlus.
