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
R8VIAsked:
Who is Participating?
 
WyTyzConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.