I have a serial number field with data that spans multiple rows for the same item, that ultimately I am trying to parse into 1 serial number value per record.
Details of the data and fields are below:
Sample Input and desired output files are attached. Screenshot shown is to view the sample input data file as it shows in my flow in the Input tool (with Null values).
Thanks for your help.
Solved! Go to Solution.
Hey @Drvt6713,
This can be solved with a concatenation followed by a split by spaces.
See the attached WF.
Hi @FrederikE ,
Unfortunately, as you can see in the output, this solution does not accommodate the records where the last character is a number and not a space ( 082416308*C*35 row 15) which results in 2 serial numbers together, and adding a space to the concatenation will cause double spaces on other records.
Hey @Drvt6713,
I see. I'd probably add an adjustment part that is able to fix it when something goes wrong. I have attached an example that splits off strings that are twice as long (chars) as the mode (e.g. normal) for this product. You could similarly also build a logic that accounts for the fact that the numbers are in a row (if that's not just the dummy data).
Hi @FrederikE ,
This will work. I already have the S/N length in another field so can build off that.
Great job!
Thanks for the solution.