i am new to Talend, I am using Talend open studio for big data. i am dealing with the task which contains a excel file having rows data with numbers and strings i want to read only the numeric data from the file and want to print in a table format. can you please help me how to do this. can you please send me the detailed job design.
Thanks & Regards
@Mastan_123,read in below way,since in tmap you can pass therequired fileds to output section.
tFileInputExcel-->tMap-->tLog(select Table format)
My Excel file contain "Minimum: 8.08, Maximum: 8.13, Average: 8.10, Standard Dev.: 0.02, Reletive Std. Dev.: 0.23", "191.0 mg Ñ 3.0% (Between 185.27 mg to 196.73 mg)" this type of data from this i want only the numeric data to be propagated to next component.
Hello Mastanaiah Shaik,
Could you please elaborate your case with an example with input and expected output values?