samuelmaiia
New Member
- Joined
- Jul 21, 2019
- Messages
- 1
Hi there,
Maybe someone can help me (is there any video/page I can watch?) as I am struggling to accomplish the following:
I have a huge list with post codes:
DN9 2BT
IP28 8PQ
DT6 4NG
F94 TP9N
LL20 8DD
RH1 2NB
YO22 5NH
TA8 2NZ
B48 7SQ
LL58 8YL
In the second column I want to insert a if statement (or other) that meets the following criteria,
If starts with,
[TABLE="width: 341"]
<tbody>[TR]
[TD]john[/TD]
[TD]pedro[/TD]
[TD]alex[/TD]
[/TR]
[TR]
[TD]CA[/TD]
[TD]LL[/TD]
[TD]SY[/TD]
[/TR]
[TR]
[TD]LA[/TD]
[TD]CH[/TD]
[TD]TF[/TD]
[/TR]
[TR]
[TD]BD[/TD]
[TD]CW[/TD]
[TD]WV[/TD]
[/TR]
[TR]
[TD]PR[/TD]
[TD]WN[/TD]
[TD]DY[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]WA[/TD]
[TD]WR[/TD]
[/TR]
[TR]
[TD]BL[/TD]
[TD]SK[/TD]
[TD]WS[/TD]
[/TR]
[TR]
[TD]OL[/TD]
[TD]IM[/TD]
[TD]DE[/TD]
[/TR]
[TR]
[TD]HX[/TD]
[TD][/TD]
[TD]NG[/TD]
[/TR]
[TR]
[TD]HD[/TD]
[TD][/TD]
[TD]LN[/TD]
[/TR]
[TR]
[TD]FY[/TD]
[TD][/TD]
[TD]LE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]NN[/TD]
[/TR]
[TR]
[TD]Any ideas?
Thank you[/TD]
[TD][/TD]
[TD]CV
[/TD]
[/TR]
</tbody>[/TABLE]
Maybe someone can help me (is there any video/page I can watch?) as I am struggling to accomplish the following:
I have a huge list with post codes:
DN9 2BT
IP28 8PQ
DT6 4NG
F94 TP9N
LL20 8DD
RH1 2NB
YO22 5NH
TA8 2NZ
B48 7SQ
LL58 8YL
In the second column I want to insert a if statement (or other) that meets the following criteria,
If starts with,
[TABLE="width: 341"]
<tbody>[TR]
[TD]john[/TD]
[TD]pedro[/TD]
[TD]alex[/TD]
[/TR]
[TR]
[TD]CA[/TD]
[TD]LL[/TD]
[TD]SY[/TD]
[/TR]
[TR]
[TD]LA[/TD]
[TD]CH[/TD]
[TD]TF[/TD]
[/TR]
[TR]
[TD]BD[/TD]
[TD]CW[/TD]
[TD]WV[/TD]
[/TR]
[TR]
[TD]PR[/TD]
[TD]WN[/TD]
[TD]DY[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]WA[/TD]
[TD]WR[/TD]
[/TR]
[TR]
[TD]BL[/TD]
[TD]SK[/TD]
[TD]WS[/TD]
[/TR]
[TR]
[TD]OL[/TD]
[TD]IM[/TD]
[TD]DE[/TD]
[/TR]
[TR]
[TD]HX[/TD]
[TD][/TD]
[TD]NG[/TD]
[/TR]
[TR]
[TD]HD[/TD]
[TD][/TD]
[TD]LN[/TD]
[/TR]
[TR]
[TD]FY[/TD]
[TD][/TD]
[TD]LE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]NN[/TD]
[/TR]
[TR]
[TD]Any ideas?
Thank you[/TD]
[TD][/TD]
[TD]CV
[/TD]
[/TR]
</tbody>[/TABLE]