Can someone help me how to insert character ( in my example I need to insert “period” ) in cells in Column A in the middle, but only in cells which have “Ford” in column C.
I uploaded a picture of my table. Result should be like 245.447 instead 245447 in first row.
Maybe sometime I will have to insert some other character like $, #…
Thanks on quick answer. Result needs to be like in your picture. If value in column C is “Ford” than insert “period” in column A. Don’t understand why we need new prediction column?
Whole thing is I need to compare 2 sets of data from excel, but unique key is a little different in these sets of data so I need to clean or modify at first. One thing is this what you solve, to put “period” (fullstop) in the middle but only if value “Ford” is in Column C.
With “column expression” node I replaced some characters in one set of data.
Maybe is this possible to do with column expression? So in one node i could have bunch of rules to modify data.
Note that if column A is of variable length, you are better off switch over to a String Manipulation or Column Expression node and use the length() function. You can nest it in the substr() function.