I have the problem that in some strings from JSON Import file there are Linefeeds that corrupt load to SQL Server, so I have to remove these Linefeeds in strings before parsing out
Hi Jose, welcome to the ZappySys Community.
Do you have an exampe of JSON string with line feed? What error are you getting when you load it?
May be you can try something like below to fix invalid JSON String. col1_1 is good data (properly encoded) and col_2 is bad data in JSON string.
Used Following setting
Enable Custom Search / Replace: true
Search For: (\r|\n|\t)--regex
Replace with: keep this field blank
