How to update column values in all lines in a text file using Powershell?

I have a text file that has 1000’s of lines. And each lines has elements that are separated by tilde(~) delimiter. Now, i want to just change the first column value numbers to a Random/Unique number, i.e 34324242342333. It is of 15 chars length. But this is not working. I need this urgently. Thanks! 34324242342333~22~BB74~001~… Read More How to update column values in all lines in a text file using Powershell?

Remove all label tags inside a string

I want to remove all label tags from a string. This is the input string. <p> <title>Contact Us</title> </p> <table dropzone="copy"> <tbody> <tr> <td class="label" style="cursor: default;">Full Name</td> <td style= "cursor: default;">[<label id="{0a4a7240-9606-416a-bf7b-ef11a47cca8e}">First name</label>] [<label id="{94263497-683b-46f9-ba0f-69f4c2736598}">Last name</label>]</td> </tr> <tr> <td class="label" style="cursor: d efault;">Telephone</td> <td style="cursor: default;">[<label id="{ce68e02e-e9fd-40ee-9375-ee1b05972e9b}">Phone</label>]</td> </tr> <tr> <td class="label" style="cursor: default;">Email</td> <td… Read More Remove all label tags inside a string