I have a global variable that has file name in it. I am trying to parse the variable and extract parts of it and map to elements in my target schema.
The file name will be in the format a_b_c.csv. I would like to extract a, b, c and map them to 3 different elements in output. a/b/c can contain '_' in them as well. The length of a/b/c are variable.
My example file name would be 36172_Company_Name_2016-05-26.
Here, a = 36172, b=Company_Name, c=2016-05-26
There will be underscores only in b(CompanyName).