Hello all, I need to remove these two zeros after * , * along with Euro sign. Tried with split, didn’t make it.
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
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
I’ve tried both methods, and both of them works! Thank you all!
@Palaniyappan @KarthikByggari
2 Likes
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