Input text -> Text processing will entirely depends upon the targeted domain or customer Replace key words, such as total number with count or total with sum etc. Remove stop words Identify the text ...
-- 1) Create raw table to hold incoming PAN values CREATE TABLE IF NOT EXISTS sgt_pan_numbers_dataset ( pan_number text ); -- 2) (Optional) Insert some test rows to try the logic quickly -- You can ...