[resolved] Convert to String in csv tconvert problem

[Anonymous]

Hello everybody,
I tried to connect an csv with out Salesforce System
But i have a problem with the conversion from String to Double 
Here is my test environment:

I tried the tconvert method which has Sabrina described with the treplace component  from this thread.
I tried several scenarios to set the treplace behind or in front of tmap .. but nothing will fit properly.
It comes the following errror:
Error in the component's properties:Type mismatch: cannot convert from String to Double
But I'm not sure if this working in any way with these approach.

Here is my csv File:

Best regards john 

[Anonymous]

Did you try in the tMap  Double.parseDouble(rowXX.yourString) (without any tReplace or tConvert)

[a_vlad]

Hello!

The answer already  in the error description
Just go from left to right on You Job and check all schemas for data type, possible to start from tMap
when You found change type String to double - use in tMap conversion function  Double.valueOf(row1.some_name)

[Anonymous · Accepted solution]

Hello Everybody 
I have solved the conversion Problem .. there is no more error if i start the job.
I have still tconvert in action cause my java skills are so bad 
...thanks for the hints 
but i think that treplace doesn't work properly.
Here are my treplace settings:

I thought i need sth. like simple expression like r/n but this  doesn't seems to work 

Here is an outline from the csv export from toad ( i've made 2 examples what is important for the transformation):



And this is the outline from the same File what i get from Talend back:




I hope that is understandable what the problem is .... 

Edit: 

Here are my Excel Sheet Settings:
 


regards john 

[Anonymous]

Hello Everbody,
I've made some Tests with and without some Components and it's seems to that the TConvert Component is repsonsible for the cold cut of important data even if i deactivate  all options for the Component.
So i think with the tconvert component is getting more worse than better ...
So as https://community.talend.com/t5/Design-and-Development/Covert-integer-DateKey-to-Date-MM-dd-yyyy/td-...[size=2][font=Verdana, Helvetica, Arial, sans-serif]  [/font][/size]said before maybe it's a better idea to use tmap only.
 I'm totally new so how i have to integrate this. But i think i need treplace to trim my csv.
Do i have to do itin this way as mentioned here on the picture?:

best regards john 

[Anonymous]

Update
I'm sick with the csv conversitions...
I got the Permission to Access  Directly to database and  everything is fine 
Thanks all  for helping in other threads 
regards john