https://community.qlik.com/t5/Talend-Studio/How-to-split-a-filename-based-on-underscore-separator/m-p/2291333#M64523 <P>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.</P><P>&nbsp;</P><P>eg.file name:Atest_Bhello_Cworld__20200908132211_.std.gz needs to be broken down into as</P><P> Atest for column FILENAME,</P><P>Bhello-column DESCRIPTION</P><P>Cworld-column TEXT</P><P>timestamp(20200908132211)-column TIME</P><P>How can i do this in talend?</P><P>&nbsp;</P><P>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?</P> Sat, 16 Nov 2024 01:29:56 GMT Haresh 2024-11-16T01:29:56Z https://community.qlik.com/t5/Talend-Studio/How-to-split-a-filename-based-on-underscore-separator/m-p/2291333#M64523 <P>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.</P><P>&nbsp;</P><P>eg.file name:Atest_Bhello_Cworld__20200908132211_.std.gz needs to be broken down into as</P><P> Atest for column FILENAME,</P><P>Bhello-column DESCRIPTION</P><P>Cworld-column TEXT</P><P>timestamp(20200908132211)-column TIME</P><P>How can i do this in talend?</P><P>&nbsp;</P><P>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?</P> Sat, 16 Nov 2024 01:29:56 GMT https://community.qlik.com/t5/Talend-Studio/How-to-split-a-filename-based-on-underscore-separator/m-p/2291333#M64523 Haresh 2024-11-16T01:29:56Z