Load CSV files into database unstructure

[Anonymous]

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.

[manodwhb]

@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.

row1.col.substring(0,row1.col.lastIndexOf('.'))

[manodwhb]

@lalitkothawade,still do you have issue?

[Anonymous]

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 (.).

[manodwhb]

@lalitkothawade,you can exteact using tExtractDelimitedFields.

check the below link to know the detals of tExtractDelimitedFields

https://help.talend.com/reader/9q55KsfASqX0qY4GVhEDNQ/0is4W2Xc7rQp8mFGjxIDRw

[manodwhb · Accepted solution]

@lalitkothawade,if you are facing issue,please check the belwo one.

[amitdadri]

[Anonymous]

why we used tfixedflowinput.. what is content in it..???

[manodwhb]

@lalitkothawade,to generate the source data by using the tFixedInputFlow.

[Anonymous]

What is columnfromstring...?? is that component or only name and if only name then which component is that??