Remove all digits after ","

Hello all, I need to remove these two zeros after * , * along with Euro sign. Tried with split, didn’t make it.
digit

1 Like

Hi
Try like this inside the FOR EACH ROW activity
row(“yourcolumnname”) = “‘“ + Split(row(“yourcolumnname”).ToStting,”,”)(0).ToString
Where if we concatenated with a single quote before the format will be of type text

Cheers @bp777

1 Like

why don’t you just try replace function.

Replace(",00 E","")

Check the below post -

Regards,
Karthik Byggari

1 Like

I’ve tried this method, but what is weird, after this method : Replace(",00 E","") - expected behavior is to get 4.800, but I’m getting 4.8
vvv

vvv2

Because you need to change the format of the column. (change to Text)

1 Like

In excel it takes likes this… When you enter manually also it changes

1 Like

did we try with this method buddy
Cheers @bp777

2 Likes

I’ve tried both methods, and both of them works! Thank you all!
@Palaniyappan @KarthikByggari

2 Likes

awesome
Cheers @bp777

Hi @bp777,

This package contains the activity called Find and Replace . You can use this activity instead moving the data to datatable.

Regards
Balamurugan.S