Hello,
I have the following field that I would like to split into individual fields within a query:
[YarnCode]: 1042/23S-0/2195-BR027
What I want:
- 1042
- 23S-0
- 2195
- BR027
I have the following code that I use on something similar, but I cannot get it to work due to the different separators ( "-" and "/"):
- Code: SplitFile(0,[YarnCode],"/")
- Twist: SplitFile(1,[YarnCode],"/")
- Quality: SplitFile(2,[YarnCode],"/")
- Colour: SplitFile(3,[YarnCode],"-")
I am not sure if this is the correct approach for this?
Any advice as to how to approach this please?