Hi all,
I've been trying to remove duplicate data from a file. What I need is for the data on the left side to only show one occurance, and list itself below any of the data on the right side it originally matched. My before and after examples probably makes more sense. I tried modifying DelDupLineInfo- but just keep hitting a wall.
Any help is appreciated.
Thanks, Max
Here is what my data looks like:
This is what I'm trying to get:
I've been trying to remove duplicate data from a file. What I need is for the data on the left side to only show one occurance, and list itself below any of the data on the right side it originally matched. My before and after examples probably makes more sense. I tried modifying DelDupLineInfo- but just keep hitting a wall.
Any help is appreciated.
Thanks, Max
Here is what my data looks like:
Code: Select all
G10002-XXX-01785-REV-IR.xml <?FRAME ID='50' TITLE='xx' TOCLEVEL='1'>
G10003-XXX-01785-REV-IR.xml <?FRAME ID='150' TITLE='ttttttttt bbbbbbbbbb' TOCLEVEL='1'>
G10003-XXX-01785-REV-IR.xml <?FRAME ID='200' TITLE='xxxxxxxxx xxxxxxxx' TOCLEVEL='1'>
G10003-XXX-01785-REV-IR.xml <?FRAME ID='200' TITLE='xxxxxxxxx xxxxxxxx' TOCLEVEL='1'>
G10008-XXX-01785-REV-IR.xml <?FRAME ID='100' TITLE='xxxxxxxx' TOCLEVEL='1'>
G10009-XXX-01785-REV-IR.xml <?FRAME ID='150' TITLE='ttttttttt bbbbbbbbbb' TOCLEVEL='1'>
G10004-XXX-01785-REV-IR.xml <?FRAME ID='200' TITLE='xxxxxxxxx xxxxxxxx' TOCLEVEL='1'>
G10004-XXX-01785-REV-IR.xml <?FRAME ID='250' TITLE='dveg xxx ts' TOCLEVEL='1'>
G10004-XXX-01785-REV-IR.xml <?FRAME ID='150' TITLE='ttttttttt bbbbbbbbbb' TOCLEVEL='1'>
G10001-XXX-01785-REV-IR.xml <?FRAME ID='200' TITLE='xxxxxxxxx xxxxxxxx' TOCLEVEL='1'>
G10001-XXX-01785-REV-IR.xml <?FRAME ID='300' TITLE='wwwwwwwwwwww' TOCLEVEL='2'>
G10001-XXX-01785-REV-IR.xml <?FRAME ID='350' TITLE='draft' TOCLEVEL='2'>
Code: Select all
<?FRAME ID='50' TITLE='xx' TOCLEVEL='1'>
G10002-XXX-01785-REV-IR.xml
<?FRAME ID='150' TITLE='ttttttttt bbbbbbbbbb' TOCLEVEL='1'>
<?FRAME ID='200' TITLE='xxxxxxxxx xxxxxxxx' TOCLEVEL='1'>
G10003-XXX-01785-REV-IR.xml
<?FRAME ID='200' TITLE='xxxxxxxxx xxxxxxxx' TOCLEVEL='1'>
G10008-XXX-01785-REV-IR.xml
<?FRAME ID='100' TITLE='xxxxxxxx' TOCLEVEL='1'>
G10009-XXX-01785-REV-IR.xml
<?FRAME ID='150' TITLE='ttttttttt bbbbbbbbbb' TOCLEVEL='1'>
<?FRAME ID='200' TITLE='xxxxxxxxx xxxxxxxx' TOCLEVEL='1'>
<?FRAME ID='250' TITLE='dveg xxx ts' TOCLEVEL='1'>
G10004-XXX-01785-REV-IR.xml
<?FRAME ID='150' TITLE='ttttttttt bbbbbbbbbb' TOCLEVEL='1'>
<?FRAME ID='200' TITLE='xxxxxxxxx xxxxxxxx' TOCLEVEL='1'>
<?FRAME ID='300' TITLE='wwwwwwwwwwww' TOCLEVEL='2'>
<?FRAME ID='350' TITLE='draft' TOCLEVEL='2'>
G10001-XXX-01785-REV-IR.xml