Replacing a character with values from a loop

[Shell]

Gurus,

Not sure if I did the justification with the Subject. However, here is where I am stuck.

I have two columns; A and B (as below): Total (current) rows 20000+

	A	B
1	103XFSGS
2	10XFSFRW	1-3
3	20X4952DF
4	10X48520K	1-3

What I need to do is to split row number 2 and row 4 in to multiple of 3 rows, and replace the values with 1-3 because column B indicates that values of 'x'  should be from 1 to 3. The position of X is at constant 3 from left therefore this rule does not apply to row 1; also it does not apply on row 3 because it does not start with 10X.

Expected Result:

	A
2	101FSFRW
2	102FSFRW
2	103FSFRW
4	10148520K
4	10248520K
4	10348520K

Sounds interesting?

/ps: Thanks in advance for your time.

[morr-co · Accepted solution]

Hi @Shell - I believe this will yield the output you are looking for. Let me know if you have questions.

[Shell]

wonderful! right on the dot!