remove first digit if its a comma

Hi all,

probably an easy question:

image

Could someone tell me, how I could remove the “,” (if there is one) at the beginning of the cells?

Which node would you use and with which formula.

Thank you very much!

Best
Markus

Hi @Markus3003 , you can easily do this via the Column Expressions node, using this expression:

if(substr(column("Text"), 0,1) == ",") {
  substr(column("Text"), 1)
} else {
  column("Text")
}
3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.