How to split a filename based on underscore separator
The filenaming convention is setup in such a way A_B_C_D.txt and i would want to split and read the individual parts of the file name and store them in separate fields and load the values into oracle database in such a way column ID has value A(from the file name),table column name has value B and so on separately.
eg.file name:Atest_Bhello_Cworld__20200908132211_.std.gz needs to be broken down into as
Atest for column FILENAME,
Bhello-column DESCRIPTION
Cworld-column TEXT
timestamp(20200908132211)-column TIME
How can i do this in talend?
I created a workflow with tfilelist-iterate-tIteratetoflow-tLogRow.I am not sure after i read the file name and print it,what is the right way to split them and store in a variable /identifier that can be parsed into the oracle table columns separately?
