Gingertrees
Well-known Member
- Joined
- Sep 21, 2009
- Messages
- 697
How would I check to see if columns on my sheet match a set array of column names?
Array :
So my sheet ideally looks like this:
[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Concatenate[/TD]
[TD]Report Item No[/TD]
[TD]Area Code[/TD]
[TD]Phone Start[/TD]
[TD]Phone End[/TD]
[TD]Name[/TD]
[TD]ID23[/TD]
[TD]ID33[/TD]
[TD]ID42[/TD]
[/TR]
[TR]
[TD]5615551212BD[/TD]
[TD]1[/TD]
[TD]561[/TD]
[TD]555[/TD]
[TD]1212[/TD]
[TD]BDoe[/TD]
[TD]x[/TD]
[TD]e[/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]6041238888AT[/TD]
[TD]2[/TD]
[TD]604[/TD]
[TD]123[/TD]
[TD]8888[/TD]
[TD]ATann[/TD]
[TD]r[/TD]
[TD]e[/TD]
[TD]r[/TD]
[/TR]
</tbody>[/TABLE]
I'd like info on which columns are missing. Any chance I could add code to insert missing columns at the right places??
Thanks.
Array :
Code:
("Concatenate", "Report Item No", "Area Code", "Phone Start", "Phone End", "Name")
So my sheet ideally looks like this:
[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Concatenate[/TD]
[TD]Report Item No[/TD]
[TD]Area Code[/TD]
[TD]Phone Start[/TD]
[TD]Phone End[/TD]
[TD]Name[/TD]
[TD]ID23[/TD]
[TD]ID33[/TD]
[TD]ID42[/TD]
[/TR]
[TR]
[TD]5615551212BD[/TD]
[TD]1[/TD]
[TD]561[/TD]
[TD]555[/TD]
[TD]1212[/TD]
[TD]BDoe[/TD]
[TD]x[/TD]
[TD]e[/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]6041238888AT[/TD]
[TD]2[/TD]
[TD]604[/TD]
[TD]123[/TD]
[TD]8888[/TD]
[TD]ATann[/TD]
[TD]r[/TD]
[TD]e[/TD]
[TD]r[/TD]
[/TR]
</tbody>[/TABLE]
I'd like info on which columns are missing. Any chance I could add code to insert missing columns at the right places??
Thanks.