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%
Solved! Go to Solution.
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
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%
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.
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 %
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
Hope this helps : )