I have a system in Mercator 6.5. It validates a file that may contain characters á, é, í, ó, ú and other european characters. The individual fields that are text have UTF-8. The delimiter between fields is literally a comma, western-native.
In one field the map cannot handle the ó and misses the next delimiter:
Trace from Before:
(Level 2: Offset 3637, len 7, comp 6 of 25, #1, DI 00000158
Data at offset 3637 ('Morón",') was found to be of TYPE
X'000C' (CITY Column_1 Store_Profile Data).
(Level 2: Offset 3645, len 0, comp 7 of 25, #1, DI 00000159
Data at offset 3645 ('","Dir Ops - J.V...') does not match DELIMITER ','
of TYPE X'0004' (Row Store_Profile Data).
___________________________________________________________
Trace from After:
(Level 2: Offset 3637, len 5, comp 6 of 25, #1, DI 00000158
Data at offset 3637 ('Moron') was found to be of TYPE
X'000C' (CITY Column_1 Store_Profile Data).
(Level 2: Offset 3648, len 20, comp 8 of 25, #1, DI 0000015A
Data at offset 3648 ('Dir Ops - J.VALL') was found to be of TYPE
X'000E' (SPACER1 Column_1 Store_Profile Data).
In another field I changed Santa Fé to Santa Fó and it went through:
(Level 2: Offset 1260, len 17, comp 21 of 25, #1, DI 0000007D
Data at offset 1260 ('Av. Santa Fó 195') was found to be of TYPE
X'001B' (ADDRESS_LINE1 Column_1 Store_Profile Data).
(Level 2: Offset 1289, len 16, comp 25 of 25, #1, DI 00000081
Data at offset 1289 ('L.SFE@ar.mcd.com') was found to be of TYPE
X'001F' (EMAIL_ADDRESS Column_1 Store_Profile Data).
Why am I having problems with the CITY field?
In one field the map cannot handle the ó and misses the next delimiter:
Trace from Before:
(Level 2: Offset 3637, len 7, comp 6 of 25, #1, DI 00000158
Data at offset 3637 ('Morón",') was found to be of TYPE
X'000C' (CITY Column_1 Store_Profile Data).
(Level 2: Offset 3645, len 0, comp 7 of 25, #1, DI 00000159
Data at offset 3645 ('","Dir Ops - J.V...') does not match DELIMITER ','
of TYPE X'0004' (Row Store_Profile Data).
___________________________________________________________
Trace from After:
(Level 2: Offset 3637, len 5, comp 6 of 25, #1, DI 00000158
Data at offset 3637 ('Moron') was found to be of TYPE
X'000C' (CITY Column_1 Store_Profile Data).
(Level 2: Offset 3648, len 20, comp 8 of 25, #1, DI 0000015A
Data at offset 3648 ('Dir Ops - J.VALL') was found to be of TYPE
X'000E' (SPACER1 Column_1 Store_Profile Data).
In another field I changed Santa Fé to Santa Fó and it went through:
(Level 2: Offset 1260, len 17, comp 21 of 25, #1, DI 0000007D
Data at offset 1260 ('Av. Santa Fó 195') was found to be of TYPE
X'001B' (ADDRESS_LINE1 Column_1 Store_Profile Data).
(Level 2: Offset 1289, len 16, comp 25 of 25, #1, DI 00000081
Data at offset 1289 ('L.SFE@ar.mcd.com') was found to be of TYPE
X'001F' (EMAIL_ADDRESS Column_1 Store_Profile Data).
Why am I having problems with the CITY field?