hello there
I had the problem to select and replace some strange symbols from a csv file into umlaute such as ä, ö, ü
on various columns..
thanks to Michael Berthold there is now an elegant solution to it: :-)
the worklfow is as follows:
1. Column List Loop start
2. Extract Column header (use the Port 2 so the one at the bottom as output!!)
3. Java snippet (simple)
copy into the Method Body the following:
$Column 0$=$Column 0$.replace ("ü","ü");
$Column 0$=$Column 0$.replace ("è", "è");
$Column 0$=$Column 0$.replace ("ä","ä" );
$Column 0$=$Column 0$.replace ("ö","ö");
$Column 0$=$Column 0$.replace ("ô","ô" );
$Column 0$=$Column 0$.replace ("é","é");
$Column 0$=$Column 0$.replace ("Ö","Ö");
$Column 0$=$Column 0$.replace ("É","E");
$Column 0$=$Column 0$.replace ("Ãœ","Ü");
return $Column 0$;
Set on Replace Column and on String!!!
4. Loop End (Column Append)