Remove leading zero, space and dash in existing column and return the output in new column
I have a dataset something like this:
I want to remove leading zero, space, and dash in column_1 and return the new data in a new column.
Expected output:
Thank you.
I want to remove leading zero, space, and dash in column_1 and return the new data in a new column.
Expected output:
Thank you.
Find more posts tagged with
Sort by:
1 - 1 of
11
Sort by:
1 - 1 of
11
Hi!
The easiest way to do this is Generate Attributes with the replaceAll function.
It takes three parameters: The name of the attribute to read (column_1), the regular expression to search for, and the replacement (the empty string "").
A regular expression to find leading spaces, zeros and dashes would be this: ^[0 -]+
Regards,
Balázs
The easiest way to do this is Generate Attributes with the replaceAll function.
It takes three parameters: The name of the attribute to read (column_1), the regular expression to search for, and the replacement (the empty string "").
A regular expression to find leading spaces, zeros and dashes would be this: ^[0 -]+
Regards,
Balázs
The easiest way to do this is Generate Attributes with the replaceAll function.
It takes three parameters: The name of the attribute to read (column_1), the regular expression to search for, and the replacement (the empty string "").
A regular expression to find leading spaces, zeros and dashes would be this: ^[0 -]+
Regards,
Balázs