Parse String Field

[bertal34]

Hi Alteryx Community!

I am trying to extract information from a Customer Care "Notes" field.  I have attached sample data of the Input and Desired Output.

The sku number can always be found after #sku and adjustment can always be found after #adj.  These can be upper or lower case so the solution has to be case insensitive.  Also, it will always be indicated if adjustment is $ or %.

Any help is GREATLY appreciated!

[Jean-Balteryx]

Hi @bertal34 ,

I completed your workflow. Tell me if it helps you !

Cheers,

Jean-Baptiste

[bertal34]

@Jean-Balteryx 

Thank you for your help.  Your solution is close however needs to work when there are multiple sku/adj in the same Notes field.  In my example, record number 3 has 2 pairs of sku/adj and therefore needs 2 output records.  Any ideas?

[bertal34 · Accepted solution]

I have found a solution for this.