Change string ending in column (find and replace)

Hi,

I have for example the following strings in a column:

m00002c
m00002s

m00002x

		<p>what I would like to do is: combine these three entries&nbsp;by removing the last peace of the string which indicates the compartment &nbsp;-&gt;&nbsp;&nbsp;(m00002)&nbsp;</p>

		<p>&nbsp;</p>

		<p>Thank you :)</p>

		<p>&nbsp;</p>
		</td>
	</tr>
</tbody>

Hi Mrs. Sippi,

you can do that using the String Manipulation Node. You should end up with something like

substr($YourColumnName$, 0, length($YourColumnName$)).

Let me know if you have problems with the node configuration, then I will provide an example workflow.

Best,


Christian

 

It worked great! Thank you very much! :)