Telus File Structure Analysis

Detailed Telus File Structure Analysis

Raw File Content (first 20 rows)

Row	Col 0	Col 1	Col 2	Col 3	Col 4	Col 5	Col 6	Col 7	Col 8	Col 9	Col 10	Col 11	Col 12	Col 13	Col 14	Col 15	Col 16	Col 17	Col 18	Col 19	Col 20	Col 21	Col 22	Col 23
0	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty
1	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty
2	Report name	Subscriber Export	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty
3	BAN(s)	32638657	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty
4	Created by	Suraj Bastola	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty
5	Date Generated	15/01/2026 08:22 EST	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty
6	Data last updated	15/01/2026 08:20 EST	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty
7	Organization	FOWLER CONSTRUCTION COMPANY LTD	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty
8	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty	empty
9	Subscriber Name	BAN	Phone Number	Status	Rate Plan	Service Category	Device Name	IMEI	Sim Serial Number	Embedded Identity Document	Upgrade eligible	Remaining balance due	Domestic Usage(MB)	Domestic Allowance(MB)	Domestic Overage(MB)	Domestic tiered charges ($)	Domestic Overage Charge	Roaming Usage(MB)	Roaming Allowance(MB)	Roaming Overage(MB)	Roaming tiered charges ($)	Roaming Overage charge	Days left	Contract end date
10	SANDRA CARLSON	32638657	2493582307	Active	Corporate Complete 42	Voice & Data	SS GALAXY XCOVER PRO 64GB BLACK	354884110341202	8912230102180190294	empty	2027-09-26	$650.00	36(Shared)	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2028-03-26
11	TIFFANY SOUTHALL	32638657	2493582315	Active	Corporate Complete 42	Voice & Data	SS GALAXY XCOVER PRO 64GB BLACK	354884110349098	8912230100123059246	empty	2027-09-26	$650.00	28(Shared)	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2028-03-26
12	RYAN LADD	32638657	2493583538	Active	Corporate Complete 42	Voice & Data	SAMSUNG GALAXY XCOVER6 PRO BLACK 5G SMARTPHONE	350533491345084	8912230102180190351	89043051202200836224013241229358	2027-07-20	$600.00	1277(Shared)	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2028-01-20
13	MIKE WALKER FWD TO BEN SAVE FOR NEW FP	32638657	2493583665	Active	Corporate Complete 42	Voice & Data	SAMSUNG GALAXY XCOVER6 PRO BLACK 5G SMARTPHONE	350533491041048	8912230100180163618	89043051202200006222004323405841	2027-07-20	$600.00	0	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2028-01-20
14	CDMC NB FIELD	32638657	2493583674	Active	Corporate Complete 42	Voice & Data	SS GALAXY XCOVER PRO 64GB BLACK	354884110348298	8912230102180190807	empty	2027-07-20	$600.00	0	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2028-01-20
15	JARED HELLAM	32638657	2493583725	Active	Corporate Complete 42	Voice & Data	SAMSUNG GALAXY XCOVER6 PRO BLACK 5G SMARTPHONE	350533491257917	8912230102186616664	89043051202200836223028026810980	2027-12-24	$737.06	1058(Shared)	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2028-06-24
16	CDMC NB PATROL FARLEYS	32638657	2493583738	Active	Corporate Complete 42	Voice & Data	SS GALAXY XCOVER PRO 64GB BLACK	354884115137951	8912230102162055945	empty	2027-12-24	$737.06	0	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2028-06-24
17	CDMC NB PATROL MARTEN RIVER	32638657	2493583739	Active	Corporate Complete 42	Voice & Data	SS GALAXY XCOVER PRO 64GB BLACK	354884115128604	8912230102162059194	empty	2027-12-24	$737.06	0	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2028-06-24
18	CODY READING	32638657	2495911477	Active	Corporate Complete 42	Voice & Data	SAMSUNG GALAXY XCOVER6 PRO BLACK 5G SMARTPHONE	350533491344863	8912230102122350493	89043051202200836224013241918349	2027-07-20	$600.00	346(Shared)	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2028-01-20
19	KATELYN JEAN RUSSELL	32638657	2495913078	Active	Corporate Complete 42	Voice & Data	SS GALAXY XCOVER PRO 64GB BLACK	354884110367967	8912230102187213214	empty	Yes	$73.84	0	2836480(Shared)	0	$0.00	$0.00	0	0	0	$0.00	$0.00	28	2026-04-28

Potential Header Rows Analysis

Row	Content	Looks Like Header?
0	\| \| \| \|	No
1	\| \| \| \|	No
2	Report name \| Subscriber Export \| \| \|	YES (contains 'name/subscriber', contains 'name/subscriber', good column count (2))
3	BAN(s) \| 32638657 \| \| \|	No
4	Created by \| Suraj Bastola \| \| \|	No
5	Date Generated \| 15/01/2026 08:22 EST \| \| \|	No
6	Data last updated \| 15/01/2026 08:20 EST \| \| \|	No
7	Organization \| FOWLER CONSTRUCTION COMPANY LTD \| \| \|	No
8	\| \| \| \|	No
9	Subscriber Name \| BAN \| Phone Number \| Status \| Rate Plan	YES (contains 'name/subscriber', contains phone-related terms, contains 'name/subscriber', contains phone-related terms)
10	SANDRA CARLSON \| 32638657 \| 2493582307 \| Active \| Corporate Complete 42	No
11	TIFFANY SOUTHALL \| 32638657 \| 2493582315 \| Active \| Corporate Complete 42	No
12	RYAN LADD \| 32638657 \| 2493583538 \| Active \| Corporate Complete 42	YES (contains phone-related terms)
13	MIKE WALKER FWD TO BEN SAVE FOR NEW FP \| 32638657 \| 2493583665 \| Active \| Corporate Complete 42	YES (contains phone-related terms)
14	CDMC NB FIELD \| 32638657 \| 2493583674 \| Active \| Corporate Complete 42	No

Phone Number Pattern Analysis

Looking for potential phone numbers in the data...

Row	Column	Value	Pattern
3	1	32638657	Number (8 digits)
10	1	32638657	Number (8 digits)
10	2	2493582307	10-digit number
11	1	32638657	Number (8 digits)
11	2	2493582315	10-digit number
12	1	32638657	Number (8 digits)
12	2	2493583538	10-digit number
13	1	32638657	Number (8 digits)
13	2	2493583665	10-digit number
14	1	32638657	Number (8 digits)
14	2	2493583674	10-digit number
15	1	32638657	Number (8 digits)
15	2	2493583725	10-digit number
16	1	32638657	Number (8 digits)
16	2	2493583738	10-digit number
17	1	32638657	Number (8 digits)
17	2	2493583739	10-digit number
18	1	32638657	Number (8 digits)
18	2	2495911477	10-digit number
19	1	32638657	Number (8 digits)

... and 61 more potential phone numbers

← Back to main application