Thanks for the post Tom. Yes, holding the pointer over might work. The problem is that the data is coming from a large database organization, so we will have many databases, with different strucutures. Even if I had the time to go through each and check what fields this happened in and code around the issue, it should have been noted/fixed before. So I have a ticket in with SAS Support, and I will get back to the DB supplier to see why these specials are being sent in the first place. Not my job to fix commericial products :smileylaugh:
Hi,
Just to finalise this post. Support sent me some code posted below, which is working for me as an intermediary setup.
data _null_;
infile "s:\temp\rob\x.csv" recfm=n;
file "s:\temp\rob\y.csv" recfm=n;
retain Flag 0;
input a $char1.;
if a = '"' then
if Flag = 0 then
Flag = 1;
else
Flag = 0;
if Flag = 1 then
do;
if a = '0D'x then
do;
goto exit;
end;
if a = '0A'x then
do;
goto exit;
end;
end;
put a $char1.;
EXIT:
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.