Recent Posts

701

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on September 23, 2018, 03:39 AM »

Input

File 1: xml-test.xml
<?xml version="1.0" encoding="ISO8859-1" ?>
<html:products>
    <html:prod id="prod1">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD</html:classificationType>
          <html:productType>PRD_XE</html:productType>
          <html:productId>10004</html:productId>
          <html:assignedDate>2018-07-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS</html:name>
          <html:Entity>REP_XE</html:legalEntity>
          <html:location>ED</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod2">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD2</html:classificationType>
          <html:productType>PRD_XE2</html:productType>
          <html:productId>10005</html:productId>
          <html:assignedDate>2018-12-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS2</html:name>
          <html:Entity>REP_XE2</html:legalEntity>
          <html:location>ED2</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod3">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD</html:classificationType>
          <html:productType>PRD_XE</html:productType>
          <html:productId>10004</html:productId>
          <html:assignedDate>2013-07-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS3</html:name>
          <html:Entity>REP_XE3</html:legalEntity>
          <html:location>ED3</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod1">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD4</html:classificationType>
          <html:productType>PRD_XE4</html:productType>
          <html:productId>10567</html:productId>
          <html:assignedDate>2010-07-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS4</html:name>
          <html:Entity>REP_XE4</html:legalEntity>
          <html:location>ED4</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod5">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD5</html:classificationType>
          <html:productType>PRD_XE5</html:productType>
          <html:productId>10004890</html:productId>
          <html:assignedDate>2015-05-15</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS5</html:name>
          <html:Entity>REP_XE5</html:legalEntity>
          <html:location>ED5</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
</html:products>

File2: xml test2.xml
<?xml version="1.0" encoding="ISO8859-1" ?>
<html:products>
    <html:prod id="prod1">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD</html:classificationType>
          <html:productType>PRD_XE</html:productType>
          <html:productId>10004</html:productId>
          <html:assignedDate>2018-03-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REFUNDS</html:name>
          <html:Entity>REP_XE</html:legalEntity>
          <html:location>ED</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod2">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD2</html:classificationType>
          <html:productType>PRD_XE2</html:productType>
          <html:productId>10005</html:productId>
          <html:assignedDate>2015-12-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS2k12</html:name>
          <html:Entity>REP_XE2</html:legalEntity>
          <html:location>ED57</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod3">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD4</html:classificationType>
          <html:productType>PRD_XER3</html:productType>
          <html:productId>10014</html:productId>
          <html:assignedDate>2010-07-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>DESTRUCTION</html:name>
          <html:Entity>REP_XE3</html:legalEntity>
          <html:location>ED43</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod4">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD4</html:classificationType>
          <html:productType>PRD_XE4</html:productType>
          <html:productId>10567</html:productId>
          <html:assignedDate>1999-07-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>WHORU</html:name>
          <html:Entity>REP_XS4</html:legalEntity>
          <html:location>ED4</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod5">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD5</html:classificationType>
          <html:productType>PRD_XE5</html:productType>
          <html:productId>10004890</html:productId>
          <html:assignedDate>2115-12-15</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>SCREW_THIS</html:name>
          <html:Entity>REP_XE5</html:legalEntity>
          <html:location>ED5</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
</html:products>

Output

10004890.csv

Code: Text [Select]

1. prod5,PRD5,PRD_XE5,10004890,2115-12-15,SCREW_THIS,REP_XE5,ED5
2. prod5,PRD5,PRD_XE5,10004890,2015-05-15,REPAIRS5,REP_XE5,ED5

10004890.xml

Code: Text [Select]

1. <html:prod id="prod5">
2.       <html:referenceData>
3.         <html:product>
4.           <html:classificationType>PRD5</html:classificationType>
5.           <html:productType>PRD_XE5</html:productType>
6.           <html:productId>10004890</html:productId>
7.           <html:assignedDate>2115-12-15</html:assignedDate>
8.         </html:product>
9.         <html:book>
10.           <html:name>SCREW_THIS</html:name>
11.           <html:Entity>REP_XE5</html:legalEntity>
12.           <html:location>ED5</html:location>
13.         </html:book>
14.       </html:referenceData>
15.    </html:prod>
16. <html:prod id="prod5">
17.       <html:referenceData>
18.         <html:product>
19.           <html:classificationType>PRD5</html:classificationType>
20.           <html:productType>PRD_XE5</html:productType>
21.           <html:productId>10004890</html:productId>
22.           <html:assignedDate>2015-05-15</html:assignedDate>
23.         </html:product>
24.         <html:book>
25.           <html:name>REPAIRS5</html:name>
26.           <html:Entity>REP_XE5</html:legalEntity>
27.           <html:location>ED5</html:location>
28.         </html:book>
29.       </html:referenceData>
30.    </html:prod>

Code: PowerShell [Select]

1. <#
2. .NAME
3.     XML-GUI.ps1
4. #>
5.  
6. Add-Type -AssemblyName System.Windows.Forms
7. [System.Windows.Forms.Application]::EnableVisualStyles()
8.  
9. #region begin GUI{
10.  
11. $Form                            = New-Object system.Windows.Forms.Form
12. $Form.ClientSize                 = '246,178'
13. $Form.text                       = "XML Mulcher"
14. $Form.BackColor                  = "#cccccc"
15. $Form.TopMost                    = $false
16. $Form.FormBorderStyle            = 'Fixed3D'
17. $Form.MaximizeBox                = $false
18.  
19. $TextBox1                        = New-Object system.Windows.Forms.TextBox
20. $TextBox1.Text                   = ""
21. $TextBox1.multiline              = $false
22. $TextBox1.ReadOnly               = $true
23. $TextBox1.Width                  = 185
24. $TextBox1.height                 = 20
25. $TextBox1.Location               = New-Object System.Drawing.Point(16,20)
26. $TextBox1.Font                   = 'Microsoft Sans Serif,10'
27.  
28. $ListBox1                        = New-Object system.Windows.Forms.ListBox
29. $ListBox1.text                   = ""
30. $ListBox1.width                  = 100
31. $ListBox1.height                 = 56
32. @('Classification','ProductType','ProductID') | ForEach-Object {[void] $ListBox1.Items.Add($_)}
33. $ListBox1.location               = New-Object System.Drawing.Point(16,50)
34.  
35. $Label1                          = New-Object system.Windows.Forms.Label
36. $Label1.Text                     = "Processing:"
37. $Label1.width                    = 68
38. $Label1.height                   = 16
39. $Label1.location                 = New-Object System.Drawing.Point(16,146)
40. $Label1.Font                     = 'Microsoft Sans Serif,8'
41.  
42. $TextBox2                        = New-Object system.Windows.Forms.TextBox
43. $TextBox2.multiline              = $false
44. $TextBox2.ReadOnly               = $true
45. $TextBox2.Width                  = 140
46. $TextBox2.height                 = 16
47. $TextBox2.Location               = New-Object System.Drawing.Point(88,144)
48. $TextBox2.Font                   = 'Microsoft Sans Serif,8'
49.  
50. $Button1                         = New-Object system.Windows.Forms.Button
51. $Button1.text                    = "Go"
52. $Button1.width                   = 60
53. $Button1.height                  = 30
54. $Button1.location                = New-Object System.Drawing.Point(171,65)
55. $Button1.Font                    = 'Microsoft Sans Serif,10'
56.  
57. $Button2                         = New-Object system.Windows.Forms.Button
58. $Button2.text                    = "..."
59. $Button2.width                   = 25
60. $Button2.height                  = 25
61. $Button2.location                = New-Object System.Drawing.Point(206,19)
62. $Button2.Font                    = 'Microsoft Sans Serif,10'
63.  
64. $Label2                          = New-Object system.Windows.Forms.Label
65. $Label2.Text                     = "Output:"
66. $Label2.width                    = 60
67. $Label2.height                   = 16
68. $Label2.location                 = New-Object System.Drawing.Point(16,120)
69. $Label2.Font                     = 'Microsoft Sans Serif,8'
70.  
71. $RadioButton1                    = New-Object system.Windows.Forms.RadioButton
72. $RadioButton1.text               = "XML"
73. $RadioButton1.AutoSize           = $true
74. $RadioButton1.width              = 40
75. $RadioButton1.height             = 16
76. $RadioButton1.location           = New-Object System.Drawing.Point(88,118)
77. $RadioButton1.Font               = 'Microsoft Sans Serif,8'
78.  
79. $RadioButton2                    = New-Object system.Windows.Forms.RadioButton
80. $RadioButton2.text               = "CSV"
81. $RadioButton2.Checked            = $true
82. $RadioButton2.AutoSize           = $true
83. $RadioButton2.width              = 40
84. $RadioButton2.height             = 16
85. $RadioButton2.location           = New-Object System.Drawing.Point(148,118)
86. $RadioButton2.Font               = 'Microsoft Sans Serif,8'
87.  
88. $Form.controls.AddRange(@($ListBox1,$TextBox1,$Button1,$Button2,$Label1,$TextBox2,$Label2,$RadioButton1,$RadioButton2))
89.  
90. #region gui events {
91. $Button1.Add_Click({
92.   if ($TextBox1.Text -ne "") {
93.     if ($ListBox1.SelectedItem -ne $null) {
94.       Clear-Host
95.       Set-Regex ($ListBox1.SelectedItem)
96.     }
97.   }
98. })
99.  
100. $Button2.Add_Click({
101.   $objForm = New-Object System.Windows.Forms.FolderBrowserDialog
102.   $objForm.Description = "Select folder containing XML"
103.   $objForm.SelectedPath = [System.Environment+SpecialFolder]'MyComputer'
104.   $objForm.ShowNewFolderButton = $false
105.   $result = $objForm.ShowDialog()
106.   if ($result -eq "OK") {
107.     $TextBox1.Text = $objForm.SelectedPath
108.   } else {
109.     $TextBox1.Text = ""
110.   }
111. })
112.  
113. #endregion events }
114. #endregion GUI }
115.  
116.  
117. #Write your logic code here
118. Function Set-Regex {
119.   param (
120.     [string]$selItem
121.   )
122.   switch ($selItem) {
123.     "Classification" { $regex = '(____________________________)(.+?)(___)' }
124.     "ProductType" { $regex = '(_____________________)(.+?)(___)' }
125.     "ProductID" { $regex = '(___________________)(.+?)(___)' }
126.   }
127.   Mulch-Files $regex
128. }
129.  
130. Function Mulch-Files {
131.   param (
132.     [string]$pattern
133.   )
134.   $files = Get-ChildItem -Path ($TextBox1.Text + "\*.xml")
135.   for ($h = 0; $h -lt $files.Count; $h++) {
136.     $TextBox2.Text = $files[$h].Name
137.     $products = (Get-Content $files[$h] -Raw) -_____ '(____)^.*?(____________________________)'
138.     for ($i = 1; $i -lt $products.Count; $i += 2) {
139.       $products[$i] -_____ '(_________)(.+?)(___)'
140.       $prod = $Matches[0]
141.       $temp = $products[$i] -_____ $pattern
142.       for ($j = 0; $j -lt $temp.Count; $j++) {
143.         if ($RadioButton2.Checked) {
144.           $outFile = $Matches[0] + ".csv"
145.           $outText = ($prod + (((($products[$i] -replace '(<[^>]+>|\s)', ',' ) -replace '`r', '') -replace '`n', '') -replace '(,)(,)+', '$1').TrimEnd(','))
146.         } else {
147.           $outFile = $Matches[0] + ".xml"
148.           $outText = $products[$i]
149.         }
150.         Out-File -FilePath $outFile -InputObject $outText -Append
151.       }
152.     }
153.   }
154.   $TextBox2.Text = "Finished"
155. }
156.  
157. [void]$Form.ShowDialog()

702

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on September 18, 2018, 05:26 PM »

You expected anything more?

@kalos: Paste your complete PS script here as it is currently, not as a single line but as a correctly formatted script with no PS shortcuts.

FYI: 80% of what you seemingly want now is covered by this script: https://www.donation....msg422784#msg422784

Only thing missing is output to separate files which would be trivial to add ...

703

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on September 18, 2018, 09:06 AM »

What's the difference?

You either have 3 lines that say:

3  Product1
1  Product2
1  Product3

Or three files that contain lines that say:

File "Product1.txt"
Product1
Product1
Product1

File "Product2.txt"
Product2

File "Product3.txt"
Product3

Either way all you're getting is a count of how many times a match appears.

704

Living Room / Re: EU to Stop Summer (or is it Winter) Time

« Last post by 4wd on September 16, 2018, 08:02 AM »

The plan also raises the prospect of neighboring countries ending up an hour apart.

That's actually funny, wonder what would happen if they visited here.

We have one town that's 30 minutes different to the rest of the state it's a part of, another small area that has its own time zone, and only 5 of the 8 states/territories observe DST.

Probably cause their heads to implode.

They should go visit a country with more than one time zone, they might learn something.

705

Living Room / Re: Do Not Buy a Smartwatch Right Now

« Last post by 4wd on September 16, 2018, 07:41 AM »

Some info on the SnapDragon Wear 3100 courtesy of XDA Developers:

https://www.xda-deve...-wear-os-smartwatch/
https://www.xda-deve...napdragon-wear-3100/

706

Living Room / Re: EU to Stop Summer (or is it Winter) Time

« Last post by 4wd on September 16, 2018, 06:41 AM »

and they the entire EU should be unified on the exact same time "to make trade easier"

-Stephen66515 (September 16, 2018, 06:02 AM)

I dont believe this is the goal here Stephen -- they are not scrapping time zones.

-tomos (September 16, 2018, 06:18 AM)

No, they are making them a joke ... what's the point in a time zone if they're not going to use them?

Personally think the need for DST has long since past.

707

Living Room / Re: Do Not Buy a Smartwatch Right Now

« Last post by 4wd on September 14, 2018, 02:26 AM »

I have the Apple watch series 3 and have used it in the pool here at my complex and at the beach without any issues.

-c.gingerich (September 13, 2018, 12:05 PM)

From a purely technical point of view, comparing apples and oranges:

• Amazfit BIP: IP68, rated for total immersion below 1m.
• Apple Watch 3: Water Resistant to 5ATM under ISO 22810.

There's no such thing as a waterproof watch as defined by ISO standards, water resistant is the best you'll get because at some point water will get in.

ISO 22810^w, (we'll have to rely on Wiki here since you have to buy ISO standards):
Water Resistant 5 atm or 50 m: Suitable for everyday use. Splash/rain resistant. Not suitable for showering, bathing, swimming, snorkeling, water related work, fishing, and diving.

So you're comparing an electronic device IP rated for total immersion against a watch ISO rated as being splash/rain resistant - that kind of turned the argument on its head, didn't it

708

Living Room / Re: Do Not Buy a Smartwatch Right Now

« Last post by 4wd on September 13, 2018, 03:20 AM »

"IP68 rating - resistant to dust, rain and splashing"

-c.gingerich (September 12, 2018, 02:18 PM)

Saying it's "resistant to dust, rain, and splashing" is understating the IP68 rating a little.

IP68 = Dust proof (no ingress), immersion to a depth > 1m, (generally tested at 3m).

The only IP rating higher is IP69K which involves using high temperature water jets.

709

General Software Discussion / Re: Et Tu, CCleaner!

« Last post by 4wd on September 12, 2018, 05:57 AM »

And if you pony up the cash, it also comes in portable format, the free version only comes as an installer.

-Shades (September 11, 2018, 06:18 AM)

Install, copy folder elsewhere, uninstall = portable

It keeps its config file in its folder and appears to create nothing in %APPDATA% or the registry, (other than MS creating entries about it being run, compatibility, etc).

710

Living Room / Re: Movies you've seen lately

« Last post by 4wd on September 08, 2018, 08:31 PM »

Stephanie

After a mysterious global crisis, a young girl is left alone to hide from a malevolent power that stalks her home. Her parents eventually return and the struggle begins to save their daughter.

Like one of the reviewers on IMDB says, "Don't read reviews before watching the film."

711

General Software Discussion / Re: Et Tu, CCleaner!

« Last post by 4wd on September 08, 2018, 07:58 PM »

Hasn't been mentioned but CCleaner 5.46 goes a little way towards ameliorating the indiscretions of v5.45.

Privacy Settings

• The Monitoring feature and reporting of anonymous usage data can now be controlled separately (previously both were controlled by the ‘Active Monitoring’ checkbox)
• Added a separate control for the reporting of anonymous usage data
• Added a link to a Data Factsheet, which explains the data reported from CCleaner, why it’s reported, and what it’s used for (in summary, CCleaner only reports anonymous, statistical data for the purposes of maintaining and improving the app, and it does not report any personal information)

Smart Cleaning

• Renamed the ‘Monitoring’ feature to ‘Smart Cleaning’, to better describe its purpose (intelligent cleaning alerts) and underline the fact that it does not report usage data
• Reworded the ‘System Monitoring’ checkbox to ‘Tell me when there are junk files to clean’
• Reworded the ‘Browser Monitoring’ checkbox to ‘Enable automatic browser cleaning’
• Reworded the ‘Active Monitoring’ checkbox to ‘Enable Smart Cleaning’
• If Smart Cleaning is disabled, CCleaner’s background process will close and the feature will not run on startup (same behavior as in v5.44)

The above is just the relevant part of the change log, there's also various fixes, etc.

They tell you exactly what is reported in their Data Factsheet.

712

General Software Discussion / Re: Registry of phone calls android-pc

« Last post by 4wd on August 29, 2018, 12:02 AM »

Call History Manager - Can export call history to Excel file then just transfer to computer via Bluetooth, email, etc.

713

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on August 25, 2018, 11:28 PM »

Code: PowerShell [Select]

1. Get-Help about_*

-wraith808 (August 21, 2018, 09:04 AM)

Thanks, didn't know there was so many 

714

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on August 24, 2018, 03:32 PM »

Thanks Wraith.

Regarding the script above:

• There's enough information within it to discern what the two missing operators are.
• The first RegEx has been given within this thread.
• The second RegEx will require a little lateral thinking, searching, and experimentation - just like the third did.

715

Living Room / Re: WhatsApp Backups in Google Drive - Curious

« Last post by 4wd on August 24, 2018, 07:07 AM »

Same thing applies to Viber - backups to Google Drive are not encrypted.

I think it's so they can be restored to another device in the event the device that made the backup dies, (if the encryption uses device specific information).

716

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on August 24, 2018, 06:58 AM »

Maybe we should just shut this down as it's getting a bit heated, and I think that everyone is done.

-wraith808 (August 23, 2018, 11:46 AM)

Agree. Moderator, please move this thread to underground.

-anandcoral (August 24, 2018, 06:49 AM)

Nah, just remove posts 94-97, 100-104 and then lock the thread - there is useful information in the various posts which won't be seen if moved to the Underground.

717

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on August 24, 2018, 06:37 AM »

Code: PowerShell [Select]

1. Clear-Host
2. $products = (Get-Content "test.xml" -Raw) -xxxxx '(....)^.*?(..........................)'
3. for ($i = 1; $i -lt $products.Count; $i += 2) {
4.   $products[$i] -xxxxx '(.........)(...)(...)' | Foreach { Write-Host ($Matches[0] + (((($products[$i] -replace '(<[^>]+>|\s)', '; ' ) -replace '`r', '') -replace '`n', '') -replace '(;\s)(;\s)+', '$1').TrimEnd('; ')) }
5. }

Output

prod1; PRD; PRD_XE; 10004; 2018-07-23; REPAIRS; REP_XE; ED
prod2; PRD2; PRD_XE2; 10005; 2018-12-23; REPAIRS2; REP_XE2; ED2
prod3; PRD3; PRD_XE3; 10014; 2013-07-23; REPAIRS3; REP_XE3; ED3
prod4; PRD4; PRD_XE4; 10567; 2010-07-23; REPAIRS4; REP_XE4; ED4
prod5; PRD5; PRD_XE5; 10004890; 2015-05-15; REPAIRS5; REP_XE5; ED5

-xxxxx = An operator

'(....)^.*?(..........................)' = A RegEx, number of dots represents number of characters in it.

'(.........)(...)(...)' = A RegEx, number of dots represents number of characters in it.


Mental exercise complete ...

Single Line Version

Code: PowerShell [Select]

1. gci *.xml | % {(gc $_ -Raw) -xxxxx '(....)^.*?(............................)' | % { if ($_ -xxxxx '(.........)(...)(...)') { ($matches[0] + (((($_ -replace '(<[^>]+>|\s)', '; ' ) -replace '`r', '') -replace '`n', '') -replace '(;\s)(;\s)+', '$1').TrimEnd('; ')) } }}

718

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on August 22, 2018, 06:30 AM »

Thanks, but it needs me to run it as admin, which I cannot.

-kalos (August 21, 2018, 09:42 AM)

And it's taken 4 pages to find that out - something that should have been stated earlier.

Any idea why the below does not work?

(gc *.xml) -match '(?s)<\?xml\ version="1\.0"\ encoding="UTF-8"\?>.+?</dbts:PmryObj>'

Sure.

Q: Whats's the input data?
A: We don't know.

Q: What's the command output?
A: We don't know.

Q: What version of Powershell are you using?
A: We don't know.

Q: What OS are you using, (including architecture)?
A: We don't know.

Q: What's the statistics of the input file, (eg. size)?
A: We don't know.

Q: Why the hell are you trying to process all files at once instead of one at a time?
A: We don't know.

etc, etc, etc, etc ... for 4 pages.

Idea: We don't know.
Why: See point 1 here.

719

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on August 22, 2018, 04:44 AM »

But I need ad-hoc answers, it's not about a specific thing I try to achieve, but mostly to learn

-kalos (August 22, 2018, 03:55 AM)

And yet every answer given here can be found on Google ... if you're going to learn anything, learn to ask the right questions.

Input

<?xml version="1.0" encoding="ISO8859-1" ?>
<html:products>
    <html:prod id="prod1">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD</html:classificationType>
          <html:productType>PRD_XE</html:productType>
          <html:productId>10004</html:productId>
          <html:assignedDate>2018-07-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS</html:name>
          <html:Entity>REP_XE</html:legalEntity>
          <html:location>ED</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod2">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD2</html:classificationType>
          <html:productType>PRD_XE2</html:productType>
          <html:productId>10005</html:productId>
          <html:assignedDate>2018-12-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS2</html:name>
          <html:Entity>REP_XE2</html:legalEntity>
          <html:location>ED2</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod3">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD3</html:classificationType>
          <html:productType>PRD_XE3</html:productType>
          <html:productId>10014</html:productId>
          <html:assignedDate>2013-07-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS3</html:name>
          <html:Entity>REP_XE3</html:legalEntity>
          <html:location>ED3</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod4">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD4</html:classificationType>
          <html:productType>PRD_XE4</html:productType>
          <html:productId>10567</html:productId>
          <html:assignedDate>2010-07-23</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS4</html:name>
          <html:Entity>REP_XE4</html:legalEntity>
          <html:location>ED4</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
    <html:prod id="prod5">
      <html:referenceData>
        <html:product>
          <html:classificationType>PRD5</html:classificationType>
          <html:productType>PRD_XE5</html:productType>
          <html:productId>10004890</html:productId>
          <html:assignedDate>2015-05-15</html:assignedDate>
        </html:product>
        <html:book>
          <html:name>REPAIRS5</html:name>
          <html:Entity>REP_XE5</html:legalEntity>
          <html:location>ED5</html:location>
        </html:book>
      </html:referenceData>
   </html:prod>
</html:products>

Code: PowerShell [Select]

1. gc "test.xml" -Raw | sls '(?smi)(<html:prod\s.+?/html:prod>)' -AllMatches | % {$_.Matches} | % { ((((($_.Value) -replace '(<[^>]+>|\s)', '; ') -replace '`r', '') -replace '`n', '') -replace '(;\s)(;\s)+', '$1').Trim('; ') }

Output

PRD; PRD_XE; 10004; 2018-07-23; REPAIRS; REP_XE; ED
PRD2; PRD_XE2; 10005; 2018-12-23; REPAIRS2; REP_XE2; ED2
PRD3; PRD_XE3; 10014; 2013-07-23; REPAIRS3; REP_XE3; ED3
PRD4; PRD_XE4; 10567; 2010-07-23; REPAIRS4; REP_XE4; ED4
PRD5; PRD_XE5; 10004890; 2015-05-15; REPAIRS5; REP_XE5; ED5

• Stop trying to put it all on one line, (just because I do doesn't mean you should).
• Stop using Powershell shortcuts until you to understand what they are because they make the source harder to read, (and yes, I used them for a reason).
• No, the output is not exactly what you wanted - not my problem since getting any coherent information is like extracting a 3 course meal from a lump of granite and takes just as long.
• If it doesn't work on the files you have - again, not my problem - see above reason.

Your homework to increase your knowledge: Render the above one line into a multi-line Powershell script with no command shortcuts.
Non-optional extra: Tell us what the RegEx is doing.
Optional extra: Fix it so you get the prod value from the input data at the start of the output lines.
Optional extra: Make it process multiple files without using gc *.xml anywhere in it.

If it doesn't work on your data, you tell us why, don't ask us, we're not mind readers.

I'm done.

720

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on August 21, 2018, 07:49 AM »

but I cannot see in the list of operators the OR 

-kalos (August 21, 2018, 04:02 AM)

Code: PowerShell [Select]

1. Get-Help about_Logical_Operators

721

General Software Discussion / Re: Extract REGEX matches from multiple text files

« Last post by 4wd on August 20, 2018, 07:15 PM »

Also, I still have not figured out how to make Powershell match . any character including newline... Any hint?

-kalos (August 20, 2018, 09:36 AM)

Learn to use Powershell's built-in help system:

Code: PowerShell [Select]

1. Get-Help about_comparison_operators

Learn to use Google:
http://lmgtfy.com/?q...er+including+newline
http://lmgtfy.com/?q...egex+match+multiline
http://bfy.tw/JV48

722

Post New Requests Here / Re: Any program required to move files to my NAS.

« Last post by 4wd on August 17, 2018, 06:11 PM »

I think it would, creating RegEx rules to cater for them is easy.

Trying to programmatically create them from the directory names is a little more of a challenge.

Kind of getting there in  PowerShell but i don't have a lot of time available at the moment.

723

Post New Requests Here / Re: Any program required to move files to my NAS.

« Last post by 4wd on August 16, 2018, 08:05 PM »

@Craig381: Does the NAS require log on credentials or are they already stored/saved in Windows?

ie. Can you just access the share through Explorer without entering user/password?

Also, define "special characters", is this anything other than what Windows defines as forbidden filename characters, (ie. <>: "/\ |?*) ?

ADDENDUM: Also, you could ask skwire to enhance his File Punter program to accept UNC destinations, it should be able to do what you want after you create the RegEx rules.

724

Living Room / Re: Do Not Buy a Smartwatch Right Now

« Last post by 4wd on August 14, 2018, 11:15 PM »

How's the interface?

-wraith808 (August 14, 2018, 10:31 PM)

The watch or the phone app?

The watch face can be changed, see here for a load of user created versions: Amazfit BIP.
Watch interface is locked until you push the button, then you can swipe left/right through the screens: Status, Activity, Weather, Alarm, Timer, Compass, Settings
Tap on the one you want then you can swipe up/down/left or tap to get further into the respective areas. Swiping right goes back up the menu system, it's actually pretty good.

A long press on the button switches it to activity tracking, (you can set default activity: walking, running, etc or go through the menu to select something else), and it will show a screen saying it's getting a GPS lock, (takes about 2 mins), then you tap OK when it vibrates indicating it has lock - you can skip it if you don't want a track log.
Another long press will pause activity tracking and you can choose to continue or end the tracking.

I can't say much about the attendant apps, Mi Fit and the ones from Amazfit.  Huami fall under the Xiaomi unbrella, hence under the Mi ecosystem, that's why the Mi Fit app.

I use a third party app called Notify & Fitness for Amazfit which provides a lot more functionality.

I guess it all comes down to what your main use is, mine was time, notifications, with the added bonus of being able to log a GPS route when I went walking plus it had/has the best battery life available - I did not want to charge it every 1-7 days.



In the screen above, the down arrow in the bottom right indicates there's more info available, eg. step count, step distance, calories, time taken, etc.  (In the case of the Weather screen, it's a 7 day forecast pulled from Weather.com,I think, could be AccuWeather, for your location, requires your phone naturally).

The interface I currently have, will probably change it as the steps, calories, and heart rate are all available under the Status screen.



It shows 46% on the battery, the app tells me it was charged on July 31, with an expected discharge date of August 28 - depends a lot on notifications, (I get quite a few through emails, SMS, Viber, etc), using vibration shortens the battery life.
When I first got it and hadn't set up any notifications, I got 35 days from 100%->9% before I decided I couldn't be bothered waiting to see how long it was going to take to go flat.

Addendum: Couple more things I just discovered with the BIP, (by accident, I should read the instructions one day), if you swipe up it'll display the last notification, swipe down and you have access to DND which you can turn on/off or to Auto.

725

Found Deals and Discounts / Re: Windscribe - Get 50GB free VPN bandwidth every month for life

« Last post by 4wd on August 14, 2018, 10:21 PM »

Speaking of Windscribe, one year deal on BdJ today

Windscribe VPN Unlimited Pro
Safeguard All of Your Online Activity
79% Off
$90 ----> $19
http://www.bitsdujou...in=todays-deals-home

I don't have big time VPN experience but from what I see Windscribe is not the fastest, overall very good though

-rgdot (August 14, 2018, 08:34 AM)

It's a standard deal they have on StackSocial, 1 year @ $19, they also have lifetime @ $69.

I picked up the lifetime version for ~US$39, (early StackSocial deal), about 18 months ago and it's been great.  They have the same deal every so often, last one was in March this year I think.