Hi Team,
Hope you are well. I need help.
Please find attached the input and expected output. The fields inside the first bracket to be separated in different columns.
Thanks for the help
Sri
Solved! Go to Solution.
Hi @binuacs ,
Thank you very much. Really appreciate it. I need one help. i would like to have another column along with the above one "Name" and it should include anything before the bracket. In this example sdfdsfdsfdf, sdfdsfdsf in a separate column.
Please let me know,
Thanks
Sri
Hi @ChrisTX ,
Thank you Chris. Really appreciate it. i need another help. I just posted again. I would like to have another column with Name and the one appears before bracket.
Hi @binuacs ,
Thank you. Perfect. Is it possible to remove the , between the names and replace with blank. For eg.sdfdsfdsfdf sdfdsfdsf instead of sdfdsfdsfdf, sdfdsfdsf .please?