Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 3 months ago. Active 9 years, 3 months ago. Viewed 7k times. Improve this question. Are you using the -o option? Neil yes, I am using -o as well and getting it on a CSV format. Neil Thanks you for your response. I was able to remove dashed lines below the headers of output file.
OR other way around would be simply output of sqlcmd is not in Unicode encoding. Struggling to solve this issue. This command was converting the string to strange sets.
First you have to find out what language the file is in to get some idea what is correct content and what is garbled content and to have a list of possible encodings. Because there are zillions of encodings, but only few were used for any particular language. Than you need to try converting the file from each possible encoding and for each conversion that succeeds technically which unfortunately will be most of them view the result and check whether it is correct or not. A spell-checker might help you with the review, since incorrect conversions will lead to more spell checker errors.
I knew this was generated by a German WindowsXP installation and contained some umlauts but iconv was not able to convert it to something sensible:. But since iconv knows so many encoding I used a brute force approach to find out a working source encoding:.
Then I would go through result. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more.
Asked 8 years, 2 months ago. Active 1 year, 7 months ago. Viewed 16k times. Convert Hex to Ascii in a Ascii file. Hi All, I have an ascii file in which few columns are having hex values which i need to convert into ascii. Kindly suggest me what command can be used in unix shell scripting?
Thanks in Advance 2 Replies. Search and Replace Extended Ascii Characters. We are getting extended Ascii characters in the input file and my requirement is to search and replace them with a space.
So my input Red Hat. I have used iconv before though it can't recognize it for some reason and says unknown file encoding. When I used ascii2uni package with different package,.
Remove characters other than ISO Hi please help in writing a script for replacing all the non-iso characters to question marks. Hi gurus, I have a file in unix with ascii values. I need to convert all the ascii values in the file to ascii characters. File contains nearly records with ascii values. Hi, I try to get tr to replace multibytes characters by ascii equivalent. Replace characters in a string using their ascii value.
RedHat Commands. OpenSolaris Commands. Linux Commands. SunOS Commands. FreeBSD Commands.
0コメント