In this article we will see how to separate data one by one from a comma separated string. First declare a variable to store articles in comma separated values. DECLARE @DataString VARCHAR(200) SET @DataString = 'ASP.NET, VB.NET, C#.NET, SQL, Javascript' Add comma at last to @DataString SET @DataString = @DataString + ',' Using while loop through all the topics in @DataString WHILE (CHARINDEX(',', @DataString) > 0) -- CHARINDEX is a SQL inbuilt function which returns the integer value if charecter is present in a string. BEGIN -- To hold each topic DECLARE @Topics VARCHAR(30) -- Get the topic one at a time SET @Topics = SUBSTRING(@DataString,0, CHARINDEX(',', @DataString)) PRINT @Topics -- Reset the @DataString SET @DataString = SUBSTRING(@DataString, CHARINDEX(',', @DataString) + 1, LEN(@DataString)) END Here is the out put of the above query ASP.NET V
I searched internet for handling binary data in AWS Gateway for more than a week but I could not find any working sample code. Every where there was a bits and pieces but no one explained or provided sample working code through which I can upload an image or render an image. So I am sharing below working sample code to handle binary data in AWS Gateway Proxy+ Below is the NodeJS example to upload and render image or binary data. By default AWS Gateway does not enable processing binary data. So we have to go to settings and enable binary data as shown below Copy this code in lambda index.js file and Deploy it. const https = require('https'); const AWS = require('aws-sdk'); exports.handler = async (event) => { let response = ''; let options = { method: event.httpMethod, hostname: ' ', path: ' ' }; let apiResponse = await proxyRequest(options, event.body, event.isBase64Encoded); // Handling ret