How to replace string with null value and put the string into new neighbor column

[KaMa]

Dears,

would you be able to help me with the following intention?

I need to replace the string in column "value" with null and put this string into new neighbor column "other tools". Also in the next step I would need to split each word from the new column to the separate row. All steps are demonstrated below.

Could you just give me a hint which way to go?

Thank you a lot for your help :).

[messi007 · Accepted solution]

@KaMa,

Please see below:

1- Regex replace to replace any number with null

2- Text to column to split column on to row based on ","

Attached the workflow,

Regards,

[Prashant Chamarty]

@KaMa you can use the formula building block to copy to the new column "Other Tool" and then use Null() within a if condition to do the needful for the "value" column. Hope this helps

[binay2448 · Accepted solution]

Hope this will help, I have two output you can choose according to your need.