HI Guys!
simple one but I cannot get there :/
If column B contains text like "10,00%" (Ex. "Discount 10,00% was granted")
insert number 21 in column Q of the same row.
Output should look like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]BLA BLA 10,00% BLA[/TD]
[TD][/TD]
[TD][/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]BLA BLA BLA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10,00%[/TD]
[TD][/TD]
[TD][/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]BLA BLA BLA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Best Regards!
W.
simple one but I cannot get there :/
If column B contains text like "10,00%" (Ex. "Discount 10,00% was granted")
insert number 21 in column Q of the same row.
Output should look like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]BLA BLA 10,00% BLA[/TD]
[TD][/TD]
[TD][/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]BLA BLA BLA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10,00%[/TD]
[TD][/TD]
[TD][/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]BLA BLA BLA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Best Regards!
W.