Need to split column based on a string

[jmedidi]

i am trying to split the text based on string value using Regex. Something like this:

Existing  Field 1 : Size 112KB(76 KB Used) 65%

Expected:

 Field1 :Size 116KB(12 KB Used)

 Field2: 65%

There can be space between the number and percentage and it can be decimal as well like 65.22%

[atcodedog05 · Accepted solution]

Hi @jmedidi 

Here is how you can do it.

Workflow:

Hope this helps : )

[jmedidi]

Hi,

I am trying to split the column based on the string value using RegX. Appreciate your support.

Existing

Version: FDFD OEM Part No.: NZSY-XXX-YY

Required

Field1

Version: FDFD

Field2

OEM Part No.: NZSY-XXX-YY

[atcodedog05 · Accepted solution]

Hi @jmedidi 

Please find the attached workflow with Regex.

Hope this helps : )

[jmedidi]

I am trying to split the below string into multiple columns. Is this something possible using Regex ? Appreciate your help here.

Existing Field

Primary: 128kB Total (115kB used) Secondary: 112122kB Total (2235kB used) Primary : 89% Secondary: 86%

Field 1 

128kB Total (115kB used)

Field 2

112122kB Total (2235kB used)

Field 3

89%

Field 4

86%

[atcodedog05]

Hi @jmedidi 

Here is the updated workflow for the task.

Hope this helps : )

[jmedidi]

Thanks for the quick response. That works.

I understand the parsing will break if there are no semicolons in between. How to handle if there is a space after primary instead of semi colon. 

[atcodedog05 · Accepted solution]

Hi @jmedidi 

Here is the updated workflow.

Hope this helps : )

[jmedidi]

Trying different schema. Is there any Tool you recommend to get knowledge on Regex. Appreciate your support.

Existing Field 

Primary: 512 kB, 76.8% free Secondary: 28672 bytes, 66.2% free

Field 1

512 KB

Field 2

76.8%

Field 3

28673 bytes

Field 4

66.2 %

[atcodedog05]

Hi @jmedidi 

Here is the workflow for the task.

Few resources on Regex:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

https://regexr.com/ 

Hope this helps : )