Hello
I have an irregular character string that can contain the following 8 contents = Name : x1-y1 Telef : x2-y2 P.O. Box : x3-y3 City : x4-y4
xn = all characters except carriage return
yn = all characters after line feed
I'm looking for a method to generate the following 8 sub-strings = Name
1 = Name: x1
2 = y1 (maybe empty)
3 = Telef : x2
4 = y2 (maybe empty)
5 = C.P. : x3
6 = y3 (maybe empty)
7 = City: x4
8 = y4 (maybe empty)
If possible, the same contents always in the same position/column (i.e. recognize and order the right sub-contents when they exist, in the appropriate column/position = y4 should always be in position/column 8).
We can use fivxrr or upwxrk for this.
THANK YOU
