Thanks for the forums, they look active from the great community that’s here.
I have a text file with some data separated by new lines and spaces that I want some of it converted to csv, so that I can then import into a database.
Tue 09/10/2019 08:20:46:27 Text Here FOO 8000 - BAR 10.1.0.70 XXX 7,846 $22,037.00 $292.50
Notice commas are missing from fields 6 and 7.
I suppose an alternative to this is to quote them:
So how can I approach this with powershell and manipulate the data to my desired outcome?