I have a scenario where i have to search for customer ID in the Description column of Bank.
I have two input files: Bank and Customer_master.
Bank description has data something like this : WP/JULY/11D2135E/Interest/Kelie where 11D2135E is the customerID.
I am using following method:
However it is giving me correct results but it is failing in some particular scenarios like.
Customer ID : 21AD210001, 10001
Bank Description: WP/AUG/SAL/21AD210001/WASA
in this case it should only match with 21AD210001 but it is also matching with 10001 which is incorrect.
Any idea how to overcome with this issue?