🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Remove leading zero, space and dash in existing column and return the output in new column

syazwaan

I have a dataset something like this:

Image: https://us.v-cdn.net/6030995/uploads/editor/fq/epl2fsr6l63v.png

I want to remove leading zero, space, and dash in column_1 and return the new data in a new column.

Expected output:

Image: https://us.v-cdn.net/6030995/uploads/editor/hq/y4putmftz2n4.png

Thank you.

Find more posts tagged with

AI Studio

Replace

Accepted answers

BalazsBaranyRM

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

All comments

BalazsBaranyRM