CSV

---

PowerShell: List Installed Software on Local Computer in .CSV File

2 Mar, 2017  in Automation / Backend / PowerShell  tagged Automation / CSV / Extract / PowerShell by Peter Lalovsky

I had to collect the installed software from few computers and i used Belarc Advisor. The fun came when i started to consolidate the data :-) To make my future life easier, I wrote a PowerShell script that exports a list of the installed programs into .CSV file.

---

T-SQL: UDF SplitString() – Split String into an Array (Table) with Multi-Character Delimiter

22 Dec, 2014  in T-SQL  tagged CSV / T-SQL / User Defined Function by Peter Lalovsky

An user-defined function to convert comma separated values (CSV) to an Array (table) is always needed. I wrote one that uses a multi-character delimiter and returns not/trimmed values. The string searches for the delimiter, inserts the left slice into the resulting table and cuts the left slice from the string. […]

---