I have a Lookup table (loaded from a user flat file) with 2 columns only , one being the joining column and the other being the desired output. 

My source data column A is having sample data like follows: 

999-55555-000-400-9999

800-22222-123-777-2233 

and so on... 500K Records. 

Now Lookup table is as follows: 

Column B || Column C

999-X-000-400-X || John

X-22222-X-777-X || Smith

Requirement is if Source Column A data matches the format of Lookup Table's Column B data, it will return the value from Column C as output. 

How can I achieve this via LKP and Expression Transformation (Not using Java as I am not well versed with it). If the LKP table needs additional column that can be added as I am loading data from the flat file there. Will appreciate if someone can assist on this?