Sponsored Content
Top Forums Shell Programming and Scripting Removing dupes within 2 delimited areas in a large dictionary file Post 302740961 by gimley on Friday 7th of December 2012 08:50:55 AM
Old 12-07-2012
Hello,
I found the problem. BOM: Byte Order mark
Normally under windows a UTF-8 file starts with a BOM (byte order mark, U+FEFF), as is standard for UTF-8 files on Windows systems. I concede that it is legal for them to do so, but it is utterly pointless since the byte order is determined by the formal specification of the UTF-8 representation itself. And it just happens that, unlike the rest of UTF-8, an initial BOM will screw up a Unix system. And Perl is supposed to be
Quote:
"an oasis of Unix culture in the desert of can't-get-there-from here" (Larry Wall, probably slightly misquoted).
Using a hex editor I removed the FEFF and it worked like a charm.

On Linux you should have no problem, since this aberration does not exist ina Unix system

Many thanks for trying to solve the mystery.

As an aid to all of us who suffer the tyranny of the WinOS system, here is a useful link:
HTML Code:
http://www.perlmonks.org/?node_id=599720.
This offers two solutions for the problem. Googling
Quote:
"perl bom" or "perl File::BOM"
comes up with more if needed.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Issue with Removing Carriage Return (^M) in delimited file

Hi - I tried to remove ^M in a delimited file using "tr -d "\r" and "sed 's/^M//g'", but it does not work quite well. While the ^M is removed, the format of the record is still cut in half, like a,b, c c,d,e The delimited file is generated using sh script by outputing a SQL query result to... (7 Replies)
Discussion started by: sirahc
7 Replies

2. Shell Programming and Scripting

Removing blanks in a text tab delimited file

Hi Experts I am very new to perl and need to make a script using perl. I would like to remove blanks in a text tab delimited file in in a specfic column range ( colum 21 to column 43) sample input and output shown below : Input: 117 102 650 652 654 656 117 93 95... (3 Replies)
Discussion started by: Faisal Riaz
3 Replies

3. Shell Programming and Scripting

Removing Embedded Newline from Delimited File

Hey there - a bit of background on what I'm trying to accomplish, first off. I am trying to load the data from a pipe delimited file into a database. The loading tool that I use cannot handle embedded newline characters within a field, so I need to scrub them out. Solutions that I have tried... (7 Replies)
Discussion started by: bbetteridge
7 Replies

4. Shell Programming and Scripting

Large pipe delimited file that I need to add CR/LF every n fields

I have a large flat file with variable length fields that are pipe delimited. The file has no new line or CR/LF characters to indicate a new record. I need to parse the file and after some number of fields, I need to insert a CR/LF to start the next record. Input file ... (2 Replies)
Discussion started by: clintrpeterson
2 Replies

5. Shell Programming and Scripting

Extracting a portion of data from a very large tab delimited text file

Hi All I wanted to know how to effectively delete some columns in a large tab delimited file. I have a file that contains 5 columns and almost 100,000 rows 3456 f g t t 3456 g h 456 f h 4567 f g h z 345 f g 567 h j k lThis is a very large data file and tab delimited. I need... (2 Replies)
Discussion started by: Lucky Ali
2 Replies

6. Shell Programming and Scripting

Script Optimization - large delimited file, for loop with many greps

Since there are approximately 75K gsfiles and hundreds of stfiles per gsfile, this script can take hours. How can I rewrite this script, so that it's much faster? I'm not as familiar with perl but I'm open to all suggestions. ls file.list>$split for gsfile in `cat $split`; do csplit... (17 Replies)
Discussion started by: verge
17 Replies

7. Shell Programming and Scripting

Removing Dupes from huge file- awk/perl/uniq

Hi, I have the following command in place nawk -F, '!a++' file > file.uniq It has been working perfectly as per requirements, by removing duplicates by taking into consideration only first 3 fields. Recently it has started giving below error: bash-3.2$ nawk -F, '!a++'... (17 Replies)
Discussion started by: makn
17 Replies

8. Shell Programming and Scripting

Merging dupes on different lines in a dictionary

I am working on a homonym dictionary of names i.e. names which are clustered together according to their “sound-alike” pronunciation: An example will make this clear: Since the dictionary is manually constructed it often happens that inadvertently two sets of “homonyms” which should be grouped... (2 Replies)
Discussion started by: gimley
2 Replies

9. UNIX for Advanced & Expert Users

Need optimized awk/perl/shell to give the statistics for the Large delimited file

I have a file size is around 24 G with 14 columns, delimiter with "|" My requirement- can anyone provide me the fastest and best to get the below results Number of records of the file First column and second Column- Unique counts Thanks for your time Karti ------ Post updated at... (3 Replies)
Discussion started by: kartikirans
3 Replies

10. Shell Programming and Scripting

Remove dupes in a large file

I have a large file 1.5 gb and want to sort the file. I used the following AWK script to do the job !x++ The script works but it is very slow and takes over an hour to do the job. I suspect this is because the file is not sorted. Any solution to speed up the AWk script or a Perl script would... (4 Replies)
Discussion started by: gimley
4 Replies
uconv_u16tou32(3C)					   Standard C Library Functions 					uconv_u16tou32(3C)

NAME
uconv_u16tou32, uconv_u16tou8, uconv_u32tou16, uconv_u32tou8, uconv_u8tou16, uconv_u8tou32 - Unicode encoding conversion functions SYNOPSIS
#include <sys/types.h> #include <sys/errno.h> #include <sys/u8_textprep.h> int uconv_u16tou32(const uint16_t *utf16str, size_t *utf16len, uint32_t *utf32str, size_t *utf32len, int flag); int uconv_u16tou8(const uint16_t *utf16str, size_t *utf16len, uchar_t *utf8str, size_t *utf8len, int flag); int uconv_u32tou16(const uint32_t *utf32str, size_t *utf32len, uint16_t *utf16str, size_t *utf16len, int flag); int uconv_u32tou8(const uint32_t *utf32str, size_t *utf32len, uchar_t *utf8str, size_t *utf8len, int flag); int uconv_u8tou16(const uchar_t *utf8str, size_t *utf8len, uint16_t *utf16str, size_t *utf16len, int flag); int uconv_u8tou32(const uchar_t *utf8str, size_t *utf8len, uint32_t *utf32str, size_t *utf32len, int flag); PARAMETERS
utf16str A pointer to a UTF-16 character string. utf16len As an input parameter, the number of 16-bit unsigned integers in utf16str as UTF-16 characters to be converted or saved. As an output parameter, the number of 16-bit unsigned integers in utf16str consumed or saved during conversion. utf32str A pointer to a UTF-32 character string. utf32len As an input parameter, the number of 32-bit unsigned integers in utf32str as UTF-32 characters to be converted or saved. As an output parameter, the number of 32-bit unsigned integers in utf32str consumed or saved during conversion. utf8str A pointer to a UTF-8 character string. utf8len As an input parameter, the number of bytes in utf8str as UTF-8 characters to be converted or saved. As an output parameter, the number of bytes in utf8str consumed or saved during conversion. flag The possible conversion options that are constructed by a bitwise-inclusive-OR of the following values: UCONV_IN_BIG_ENDIAN The input parameter is in big endian byte ordering. UCONV_OUT_BIG_ENDIAN The output parameter should be in big endian byte ordering. UCONV_IN_SYSTEM_ENDIAN The input parameter is in the default byte ordering of the current system. UCONV_OUT_SYSTEM_ENDIAN The output parameter should be in the default byte ordering of the current system. UCONV_IN_LITTLE_ENDIAN The input parameter is in little endian byte ordering. UCONV_OUT_LITTLE_ENDIAN The output parameter should be in little endian byte ordering. UCONV_IGNORE_NULL The null or U+0000 character should not stop the conversion. UCONV_IN_ACCEPT_BOM If the Byte Order Mark (BOM, U+FEFF) character exists as the first character of the input parameter, interpret it as the BOM character. UCONV_OUT_EMIT_BOM Start the output parameter with Byte Order Mark (BOM, U+FEFF) character to indicate the byte ordering if the output parame- ter is in UTF-16 or UTF-32. DESCRIPTION
The uconv_u16tou32() function reads the given utf16str in UTF-16 until U+0000 (zero) in utf16str is encountered as a character or until the number of 16-bit unsigned integers specified in utf16len is read. The UTF-16 characters that are read are converted into UTF-32 and the result is saved at utf32str. After the successful conversion, utf32len contains the number of 32-bit unsigned integers saved at utf32str as UTF-32 characters. The uconv_u16tou8() function reads the given utf16str in UTF-16 until U+0000 (zero) in utf16str is encountered as a character or until the number of 16-bit unsigned integers specified in utf16len is read. The UTF-16 characters that are read are converted into UTF-8 and the result is saved at utf8str. After the successful conversion, utf8len contains the number of bytes saved at utf8str as UTF-8 characters. The uconv_u32tou16() function reads the given utf32str in UTF-32 until U+0000 (zero) in utf32str is encountered as a character or until the number of 32-bit unsigned integers specified in utf32len is read. The UTF-32 characters that are read are converted into UTF-16 and the result is saved at utf16str. After the successful conversion, utf16len contains the number of 16-bit unsigned integers saved at utf16str as UTF-16 characters. The uconv_u32tou8() function reads the given utf32str in UTF-32 until U+0000 (zero) in utf32str is encountered as a character or until the number of 32-bit unsigned integers specified in utf32len is read. The UTF-32 characters that are read are converted into UTF-8 and the result is saved at utf8str. After the successful conversion, utf8len contains the number of bytes saved at utf8str as UTF-8 characters. The uconv_u8tou16() function reads the given utf8str in UTF-8 until the null ('') byte in utf8str is encountered or until the number of bytes specified in utf8len is read. The UTF-8 characters that are read are converted into UTF-16 and the result is saved at utf16str. After the successful conversion, utf16len contains the number of 16-bit unsigned integers saved at utf16str as UTF-16 characters. The uconv_u8tou32() function reads the given utf8str in UTF-8 until the null ('') byte in utf8str is encountered or until the number of bytes specified in utf8len is read. The UTF-8 characters that are read are converted into UTF-32 and the result is saved at utf32str. After the successful conversion, utf32len contains the number of 32-bit unsigned integers saved at utf32str as UTF-32 characters. During the conversion, the input and the output parameters are treated with byte orderings specified in the flag parameter. When not speci- fied, the default byte ordering of the system is used. The byte ordering flag value that is specified for UTF-8 is ignored. When UCONV_IN_ACCEPT_BOM is specified as the flag and the first character of the string pointed to by the input parameter is the BOM char- acter, the value of the BOM character dictates the byte ordering of the subsequent characters in the string pointed to by the input parame- ter, regardless of the supplied input parameter byte ordering option flag values. If the UCONV_IN_ACCEPT_BOM is not specified, the BOM as the first character is treated as a regular Unicode character: Zero Width No Break Space (ZWNBSP) character. When UCONV_IGNORE_NULL is specified, regardless of whether the input parameter contains U+0000 or null byte, the conversion continues until the specified number of input parameter elements at utf16len, utf32len, or utf8len are entirely consumed during the conversion. As output parameters, utf16len, utf32len, and utf8len are not changed if conversion fails for any reason. RETURN VALUES
Upon successful conversion, the functions return 0. Upon failure, the functions return one of the following errno values: EILSEQ The conversion detected an illegal or out of bound character value in the input parameter. E2BIG The conversion cannot finish because the size specified in the output parameter is too small. EINVAL The conversion stops due to an incomplete character at the end of the input string. EBADF Conflicting byte-ordering option flag values are detected. EXAMPLES
Example 1 Convert a UTF-16 string in little-endian byte ordering into UTF-8 string. #include <sys/types.h> #include <sys/errno.h> #include <sys/u8_textprep.h> . . . uint16_t u16s[MAXNAMELEN + 1]; uchar_t u8s[MAXNAMELEN + 1]; size_t u16len, u8len; int ret; . . . u16len = u8len = MAXNAMELEN; ret = uconv_u16tou8(u16s, &u16len, u8s, &u8len, UCONV_IN_LITTLE_ENDIAN); if (ret != 0) { /* Conversion error occurred. */ return (ret); } . . . Example 2 Convert a UTF-32 string in big endian byte ordering into little endian UTF-16. #include <sys/types.h> #include <sys/errno.h> #include <sys/u8_textprep.h> . . . /* * An UTF-32 character can be mapped to an UTF-16 character with * two 16-bit integer entities as a "surrogate pair." */ uint32_t u32s[101]; uint16_t u16s[101]; int ret; size_t u32len, u16len; . . . u32len = u16len = 100; ret = uconv_u32tou16(u32s, &u32len, u16s, &u16len, UCONV_IN_BIG_ENDIAN | UCONV_OUT_LITTLE_ENDIAN); if (ret == 0) { return(0); } else if (ret == E2BIG) { /* Use bigger output parameter and try just one more time. */ uint16_t u16s2[201]; u16len = 200; ret = uconv_u32tou16(u32s, &u32len, u16s2, &u16len, UCONV_IN_BIG_ENDIAN | UCONV_OUT_LITTLE_ENDIAN); if (ret == 0) return(0); } /* Otherwise, return -1 to indicate an error condition. */ return (-1); Example 3 Convert a UTF-8 string into UTF-16 in little-endian byte ordering. Convert a UTF-8 string into UTF-16 in little-endian byte ordering with a Byte Order Mark (BOM) character at the beginning of the output parameter. #include <sys/types.h> #include <sys/errno.h> #include <sys/u8_textprep> . . . uchar_t u8s[MAXNAMELEN + 1]; uint16_t u16s[MAXNAMELEN + 1]; size_t u8len, u16len; int ret; . . . u8len = u16len = MAXNAMELEN; ret = uconv_u8tou16(u8s, &u8len, u16s, &u16len, UCONV_IN_LITTLE_ENDIAN | UCONV_EMIT_BOM); if (ret != 0) { /* Conversion error occurred. */ return (ret); } . . . ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Committed | +-----------------------------+-----------------------------+ |MT-Level |MT-Safe | +-----------------------------+-----------------------------+ SEE ALSO
attributes(5), uconv_u16tou32(9F) The Unicode Standard (http://www.unicode.org) NOTES
Each UTF-16 or UTF-32 character maps to an UTF-8 character that might need one to maximum of four bytes. One UTF-32 or UTF-8 character can yield two 16-bit unsigned integers as a UTF-16 character, which is a surrogate pair if the Unicode scalar value is bigger than U+FFFF. Ill-formed UTF-16 surrogate pairs are seen as illegal characters during the conversion. SunOS 5.11 18 Sep 2007 uconv_u16tou32(3C)
All times are GMT -4. The time now is 05:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy