Numerical data reading from the Excel sheet

[Anonymous]

 hi,

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

Mastanaiah Shaik  

[manodwhb]

@Mastan_123,read in below way,since in tmap you can pass therequired fileds to output section.

tFileInputExcel-->tMap-->tLog(select Table format)

[Anonymous]

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.

[Anonymous]

Hello Mastanaiah Shaik,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina