Im using apache POI-HSSF Api to parse excel spread sheets.
I observed that I’m getting some special characters, might be some contol characters which are not visible in wMdeveloper, but visible when I paste the text in text editor.
GPO Inv IDGPO Inv NumberExp Ipac Date1343425â€1271075â€¬â€06-JUL-2011â€¬1343529â€1271179â€¬â€06-JUL-2011â€¬1343807â€1271273â€¬â€06-JUL-2011â€¬
Ascii value of these special charaters is 8236 and 8237 etc.
I tried UTF-8 to decode but didnt work. my present work around is to eliminate those special characters through a util service.
Any help is appreciated.