[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

sql server SSIS

Hi,

I have the line input = Replace(input, Chr(34), " ")

This is in a Script component with SSIS data flow designed manage CSV file.

Please can someone tell me what the line

input = Replace(input, Chr(34), " ")

Does

Thanks,

R8VI
0
R8VI
Asked:
R8VI
1 Solution
 
WyTyzCommented:
The function chr(34) get the double quote (") character, e.g. ASCII's value 34.
It replaces all double quote chars in the input string with a whitespace character.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now