September 25, 2008 at 5:05 am
Hi SSIS gurus,
i have a csv file i this table i have some fields
V00000004341
V00000004341
V00000004453
V00000004453
before this fields squarebox is there there is no charecter to type in keyboard
i want replace this normal fileds like
V00000004341
V00000004341
V00000004453
V00000004453
how to solve this i am trying Replace,Trim,Substring everthing but no use
anybody help appriciated
thanks
murali
September 25, 2008 at 6:56 am
Windows often displays characters that it cannot display as a square box. It could be anything - a line feed, a korean character that you do not have installed, etc.
If it is only a single character, using SUBSTRING to take everything after the first character will handle it. If it could be multiple characters, you will need to check the ASCII value of each character until you get to one that is in your acceptable character set.
September 25, 2008 at 9:46 am
I get data like this all of the time, assuming you need to remove these characters you need to create a script to open the file and scan through line by line removing the chars you no longer need and writing the result to a new file. One of the other things I check for is that the no of delimited fields matches the no of stated fields stated by the header, the number of people that don't stick to CSV standards (including MS) is amazing.
February 14, 2011 at 1:48 pm
Do you have an example of a script that would go through line by line and strip these unwanted characters?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply