Hello,
My code is fetching this strange character _x000 from excel, that is nowhere to be found in actual document.
Only part of the code that I can think of doing this is:
if REGEXP_COUNT(c.C001, '...\d+') > 1 then
for n in 2..REGEXP_COUNT(c.C001, '...\d+') loop
apex_collection.add_member(
p_collection_name => 'COLLECTION',
p_c001 => REGEXP_SUBSTR(c.C001, '...\d+',1,n),
p_c007 => c.C007,
p_c008 => c.C008,
p_c009 => c.C009
);
end loop;
apex_collection.update_member_attribute (
p_collection_name => 'COLLECTION' ,
p_seq => c.seq_id,
p_attr_number => 1,
p_attr_value => REGEXP_SUBSTR(c.C001, '...\d+',1,1)
);
end if;
This part of the code is looking if there are multiple occurrences of the string in regexp format ‘…\d+’, and if there is add member to the collection, and update original member by removing all other occurrences.
Only mention of this character in the internet is _x000d_ as \r.
I actually would not like to change REGEXP format ‘…\d+’, as it helps me later in the code identify missing characters.
Is there any explanation why this happens or how to solve it?
Thanks,
M.P.