Trim Not Working With File

[anon97]

Hi everyone, I have a very simple problem. I just need to trim some cells from excel. I tried it on my own but there are some errors I don’t understand.

Here is a link to my project, an example excel is there too: Project Zip

[Julian_Muhlbauer (Julian Mühlbauer)]

Happy to help! Can you provide more details? What is given, and what would you like it to look like?

[anon97]

Hi!

Basically, I just want to make a new column with the (S$) in header instead of the values. The new values will just take the minimum price. If the item wasn’t found, it should be 0. That’s about it

[Vinit_Mhatre (BotBuilder)]

Hi @anon97 ,

Try attached updated workflow, hope it helps you

Data Manipulation.zip (12.6 KB)

Regards,
Vinit Mhatre

[anon97]

Hi!

Thanks for the example. How can I trim the S$ out before the data is inserted in the new column? Besides that, I think just the new header is a different name

[Vinit_Mhatre (BotBuilder)]

Hi @anon97 ,

You can use Replace function to replace “S$”

Split(CurrentRow("Price").ToString().Trim().ToUpper(),"TO")(0).Replace("S$","").Trim

Regards,
Vinit Mhatre

[anon97]

thank you. where exactly should I change or add this?

[Vinit_Mhatre (BotBuilder)]

Hi @anon97 ,

Just update the expression into arrayrow that i have added into ELSE part of if condition, as below

And also if you want to change the column name you can do it into BUILD DATATABLE

Regards,
Vinit Mhatre

[anon97]

When I try to change it, this appears:

[Vinit_Mhatre (BotBuilder)]

Hi @anon97 ,

Updated workflow: Main.xaml (15.5 KB)

Use this,

{CurrentRow("Items").ToString,CurrentRow("Price").ToString,Split(CurrentRow("Price").ToString().Trim().ToUpper(),"TO")(0).Replace("S$","").Trim}

Regards,
Vinit Mhatre

[anon97]

Thanks! It works now

[Vinit_Mhatre (BotBuilder)]

Happy automation !!!