Category Archives: String handling

SQL Server string functions for Data Munging (Wrangling)

In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server. In many cases, Machine learning outcomes are only as good as the data they’re built on – but the work … Continue reading

Posted in String handling | Tagged , | Leave a comment

How to Replace Multiple Strings in a File using PowerShell

Replace the Data Source and Initial Catalog values of WebConfig.XML Content of XML file <Configuration ConfiguredType=”Property” Path=”\Package.Connections[ConnStaging].Properties[ConnectionString]” ValueType=”String”> <ConfiguredValue>Data Source=localhost;Initial Catalog=Stage;Integrated Security=SSPI; Connection Timeout = 10</ConfiguredValue> </Configuration> PARAM( [String]$DatabaseName=’DCTarget’, [String]$XML=’c:\webconfig.XML’, [String]$DatabaseServer=’DataCenterDB01′) [string]$db = ‘Catalog=’+ $DatabaseName [string]$dbs = ‘Source=’+ $DatabaseServer (Get-Content $XML) | … Continue reading

Posted in PowerShell, String handling | Tagged , , | Leave a comment