Hello,
I am using this workflow to parse a concatenated sentence, but I am not able to get a correct result from the WF. So what's happening is I am concatenating every column into one column, where I am dividing them into 3 sets using "|" from the Multi-row tool and using a Regex replace to change the sets into the desired format.
Example :
"SUI Wages (Subject),111 414 88 Y,28 547 88 Q|SUI Wages (Taxable),7 000 00 Y,Q|SDI Wages,111,414,88,Y,28 547 88 Q" This is the output of multi-row
"SUI Wages (Subject),111 414 88 Y,28 547 88 Q|SUI Wages (Taxable),7 000 00 Y,Q|SDI Wages,11141488Y,28 547 88 Q" This is the output of the Regex replace using the formula tool.
But for some of the data, the output of regex is "Paid In Month 2,Y,1 Q|Paid In Month 3,Y,1 Q|Other CAFE125,4 627,60,Y,1 131 90 Q"
where the last set data is not getting converted correctly, the output I want is "Other CAFE125,462760Y,113190Q" .
I am also attaching the workflow. I wanted to know how I can modify the data so that even if I change it, I can still get the correct result by using any tools.
Solved! Go to Solution.
@Peddsairam can you upload the expected result based on your input file?
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |