I have csv file in that 3 columns are present but in one column the data will be unstructured like
175.4A.EC-413.ZN-F.175.4h.TC-420.ZN-F.Present Value, I want to seperate that (.) into columns, how to load this type of csv file into mysql database through talend??? please help us. I have attached csv file for reference.
Solved! Go to Solution.
@lalitkothawade,you need out as "175.4A.EC-413.ZN-F.175.4h.TC-420.ZN-F" ?
if yes you can use below expression in tmap.
my input is like 175.4A.EC-413.ZN-F.175.4h.TC-420.ZN-F and i want ouput as separate columns like
175 4A EC-413 means separated by (.).
@lalitkothawade,you can exteact using tExtractDelimitedFields.
check the below link to know the detals of tExtractDelimitedFields
@lalitkothawade,it is tFileInputDelimmited,just given name for the Componnet Label format in View of tFileInputDelimmited.