topic Re: Separating the text inside a bracket in different columns - irregular sentences in Alteryx Designer Desktop Discussions

Separating the text inside a bracket in different columns - irregular sentences

sriniprad08 — Thu, 13 Jun 2024 21:37:35 GMT

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

Re: Separating the text inside a bracket in different columns - irregular sentences

binu_acs — Tue, 29 Mar 2022 10:45:04 GMT

@sriniprad08

Re: Separating the text inside a bracket in different columns - irregular sentences

ChrisTX — Tue, 29 Mar 2022 10:54:38 GMT

Attached is one option, using RegEx

Chris

Re: Separating the text inside a bracket in different columns - irregular sentences

sriniprad08 — Tue, 29 Mar 2022 10:55:40 GMT

Hi @binu_acs ,

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

Re: Separating the text inside a bracket in different columns - irregular sentences

sriniprad08 — Tue, 29 Mar 2022 10:56:20 GMT

Re: Separating the text inside a bracket in different columns - irregular sentences

sriniprad08 — Tue, 29 Mar 2022 11:01:41 GMT

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.

Re: Separating the text inside a bracket in different columns - irregular sentences

binu_acs — Tue, 29 Mar 2022 11:08:01 GMT

@sriniprad08

Re: Separating the text inside a bracket in different columns - irregular sentences

sriniprad08 — Tue, 29 Mar 2022 11:20:02 GMT

Hi @binu_acs ,

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?

Re: Separating the text inside a bracket in different columns - irregular sentences

binu_acs — Tue, 29 Mar 2022 11:47:51 GMT

@sriniprad08 you can use the ReplaceChar function to replace , with space