Icon

20210904 Pikairos Delete last two characters of a string in column

There has been no description set for this workflow's metadata.

The data withcolumn publication_numberExtract the 2 charactersin new column:reverse( substr(reverse($publication_number$), 0, 2))Remove the 2 charactersin the publication_number column:substr( $publication_number$, 0, length( substr( $publication_number$, 2)))Table Creator String Manipulation String Manipulation The data withcolumn publication_numberExtract the 2 charactersin new column: reverse( substr(reverse($publication_number$), 0, 2))Remove the 2 charactersin the publication_number column:substr( $publication_number$, 0, length( substr( $publication_number$, 2)))Table Creator String Manipulation String Manipulation

Nodes

Extensions

Links