@dustinb3403 said in Need Regex Help:

@travisdh1 No, backend database access isn't available to me.

Well, that's a little ****y. No db gui has given me everything I wanted to do with a database.

@DustinB3403 : Team effort! 🙂

What spam examples will this block?

@jaredbusch said in How can I sed or regex this out:

@romo said in How can I sed or regex this out:

@jaredbusch said in How can I sed or regex this out:

****** Object: UserDefinedFunction [dbo].[FiscalMo] Script Date: 11/30/2017 10:24:23 AM ******

sed 's/Script.*M //g'

I need at least one * and the / to close.

So this?

sed 's/Script.*M /\ \*\//g'

You are escaping seds delimiters with that.

Changing the delimiters for better clarity:

From Script to M + space, replace with space,. It keeps all your * and the final /.

0_1512131437191_Screenshot_20171201-062914.png

@tim_g said in PowerShell Regex - How to remove everything after first line?:

Actually, I'm sticking to this:

$compName = Get-WmiObject win32_ComputerSystem | Select-Object -ExpandProperty Name if ($compName -match "WINDOWS") { $dellTag = Get-WmiObject win32_bios | Select-Object -ExpandProperty SerialNumber Rename-Computer -NewName $dellTag -Force -Restart } Exit

Compared to sed, that makes my head hurt. Glad you got it sorted, and an example for when I'll need to do the same thing.

I use it very little but have the odd task that I use it for. It's difficult to pop into a one liner so I try to use other tools when possible.