Dear Ista,
I copied my data below
UNIQUEID,FINDINGSID,ORGNUMRES,STNUMRES,CONVRES,VISITDY,ORGCHARRES,STCHARRES,NOMINALDAY,NOMINALDATE,MEASRMTDAY,MEASRMTDATE,INPUTDATE,NEOPLASMNAME,TUMORCLASSNAME,CATDOMAIN,CATDID,SPECIMENTYP,SPTDID,PCDOMAIN,USUBJID,PCDID,TESTDOMAIN,TSTDID,ORRESUNIT,RESDID,SUBJECTSID,STDRESUNIT,STDRDID,CONVRESUNIT,COVRDID,CUSTOMFIELD5,GRPLABEL,GRPNUMBER,SEX,SEXDID,TRIALGROUPSID,SPECIMENLOC,SPECIMENCOND,SPECIMENCOND1,SPECIMENCOND2,SPECIMENCOND3,SEVERITY,COMM,ASPECT,CAUSEOFDEATH,DERIVEFLG,PHASENAME,PHASENAMEDID,ENTITY,ENTITYDID,SECONDARYFLAG,CUSTOMFIELD0,CUSTOMFIELD4,CUSTOMFIELD6,CUSTOMFIELD9,SOURCE,RESCATEGORY,OFSPSEX,OFFSPNUM,FILEID,ANALYTEID,ANALYTEDID,DATETIME,ELTM,ENDY,NOMDAYOFPHASE,OFSPSEXDID,PLTIMEPOINT,STATUSFLAG,ANABIOREGION,TESTMETHOD,FINDLOC,CUSTOMFIELD8,TIMESLOTDESC,TIMESLOTCODE,PTPTN,TPTNUM
3073004,3073004,,37.800000000000000,37.800000000000000,61,© ® ⢠â â â³
฿ ⵠ¢
⡠⢠â $ ⫠৳ â¯ â¬ Æ â£ â² â´ â ⺠Ⳡ⥠⦠⧠ⱠⰠ£
⹠⨠⪠⸠⮠⩠¥ á,© ® ⢠â â Ⳡ฿ ⵠ¢
⡠⢠â $ ⫠৳ â¯ â¬ Æ â£ â² â´ â ⺠Ⳡ⥠⦠⧠ⱠⰠ£
⹠⨠⪠⸠⮠⩠¥
á,61,,,,,,,,,,,BW,"apcu102881`~!@#$%^&*()-_+={[}]|:;""'<,>.?/",16082,© ® â¢
â â Ⳡ฿ ⵠ¢ ⡠⢠â $ ⫠৳ â¯ â¬ Æ â£ â² â´ â ⺠â³
⥠⦠⧠ⱠⰠ£ ⹠⨠⪠⸠⮠⩠¥ á,,© ®
⢠â â Ⳡ฿ ⵠ¢ ⡠⢠â $ ⫠৳ â¯ â¬ Æ â£ â² â´ â âº
Ⳡ⥠⦠⧠ⱠⰠ£ ⹠⨠⪠⸠⮠⩠¥
á,45741,38733,© ® ⢠â â Ⳡ฿ ⵠ¢ ⡠⢠â $ ⫠৳ ⯠â¬
Æ â£ â² â´ â ⺠Ⳡ⥠⦠⧠ⱠⰠ£ â¹
⨠⪠⸠⮠⩠¥ á,,© ® ⢠â â Ⳡ฿ ⵠ¢ ⡠⢠â $ â«
৳ â¯ â¬ Æ â£ â² â´ â ⺠Ⳡ⥠⦠⧠ⱠⰠ£
⹠⨠⪠⸠⮠⩠¥
á,,"USB102881`~!@#$%^&*()-_+={[}]|:;""'<,>.?/","SC51`~!@#$%^&*()-_+={[}]|:;""'<,>.?/:
SET 1⬠é à ñ ó ú ü ¿ á é à ó ú ü
ñ","SC51`~!@#$%^&*()-_+={[}]|:;""'<,>.?/",M,42133,1445,,,,,,,,,,,,,,,,,,,,,,,,2631,,,,,,,,,A,,,,,,,©
® ⢠â â Ⳡ฿ ⵠ¢ ⡠⢠â $ ⫠৳ â¯ â¬ Æ â£ â² â´ â
⺠Ⳡ⥠⦠⧠ⱠⰠ£ ⹠⨠⪠⸠⮠⩠¥ á,
Thanks & Regards,
D V Kiran Kumar
On Wed, Feb 5, 2014 at 5:05 PM, Ista Zahn <[email protected]> wrote:
> Hi Kiran,
>
> Please post a reproducible example, either by pasting a sample of
> comma separated values into you message, posting a .csv file somewhere
> where we can download it. Without an example all we can do is guess
> what your problem might be.
>
> Best,
> Ista
>
> On Wed, Feb 5, 2014 at 5:10 AM, Venkata Kirankumar
> <[email protected]> wrote:
> > Hi David,
> >
> >
> > In CSV RFC 4180 format if any ' or " character is there then character
> will
> > go with escape character so CSV will distinguish properly.
> >
> >
> >
> > I will try with read.fwf once because with redline I am facing same
> issue.
> >
> > Thanks & Regards,
> > D V Kiran Kumar.
> >
> >
> > On Wed, Feb 5, 2014 at 3:14 AM, David Winsemius <[email protected]
> >wrote:
> >
> >>
> >> On Feb 4, 2014, at 7:58 AM, Venkata Kirankumar wrote:
> >>
> >> > Hi All,
> >> >
> >> >
> >> > I have some data with different special characters, newline character,
> >> and
> >> > different language characters in a CSV file like `~!@#$%^&*|
> >> > ()-_+={[}]|\:;""'<,>.?/
> >> > in data, while I am trying to read this CSV and trying to do
> >> calculations I
> >> > am not able to get this data as there in single cell. I found
> something
> >> > like RFC 4180 format can help to solve this problem.
> >> >
> >> >
> >> >
> >> > If anyone can give suggestion related to handling these special
> >> characters
> >> > it will be help full for me
> >> >
> >>
> >> I'm having a difficult time understanding your expectations and thedata
> >> situation. If it's a "csv file", then how can all three of <comma>,
> >> <single-quote>, and <double-quote> be properly distinguished when they
> are
> >> also part of the data?
> >>
> >>
> >> You might consider using readLines (from base) or read.fwf (from the
> utils
> >> package)
> >>
> >>
> >>
> >> >
> >> >
> >> > Thanks in advance,
> >> >
> >> > D V Kiran Kumar
> >> >
> >> > [[alternative HTML version deleted]]
> >> >
> >> > ______________________________________________
> >> > [email protected] mailing list
> >> > https://stat.ethz.ch/mailman/listinfo/r-help
> >> > PLEASE do read the posting guide
> >> http://www.R-project.org/posting-guide.html
> >> > and provide commented, minimal, self-contained, reproducible code.
> >>
> >> David Winsemius
> >> Alameda, CA, USA
> >>
> >>
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > [email protected] mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
>
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
