Navigation

Search

Categories

On this page

Archive

Blogroll

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.



RSS 2.0 | Atom 1.0 | CDF

Send mail to the author(s) E-mail

Total Posts: 121
This Year: 3
This Month: 0
This Week: 0
Comments: 35

Sign In
Pick a theme:

# Monday, July 07, 2014
Monday, July 07, 2014 10:26:51 PM (GMT Daylight Time, UTC+01:00) ( )

It's not possible to setup a new TV without manually editing all 35 analog channels or manually sorting after auto-tuning. After discovering how difficult it is to find the list in the internet, I decided to just share it somewhere.

PS: My search was not easy as this operator recently changed the brand completely and forgot to publish the information on the new website. Anyway, found some parts in forums online, so here goes my contribution, and how I ended up formatting the table in Excel (and PowerQuery).

So my simple exercise is just parsing this:

Into something more readable like:

 

The easy way is by splitting using position from right to left.

Visual tools are great and in the end the generated code was:

= Table.SplitColumn(Source,"Column1",Splitter.SplitTextByEachDelimiter({" "}, null, true),{"Column1.1", "Column1.2"})

Here is the final table, just for googlers out there:

Plano de Frequências ZON e/ou NOS

Posicao

Canal

Frequencia

1

RTP1

C-5

2

RTP 2

C-7

3

SIC

C-8

4

TVI

C-10

5

SIC NOTÍCIAS

S-6

6

TVI 24

S-7

7

RTPN

S-8

8

SIC MULHER

S-29

9

SIC RADICAL

C-22

10

RTP MEMÓRIA

C-39

11

PORTO CANAL

C-47

12

RTP ÁFRICA

C-26

13

CANAL PANDA

C-25

14

PANDA BIGGS

C-49

15

HOLLYWOOD

S-34

16

MOV

S-30

17

AXN

S-35

18

FOX LIFE

C-31

19

FOX

S-20

20

MTV PORTUGAL

S-33

21

DISCOVERY TRAVEL & LIVING

C-50

22

TV RECORD

C-34

23

DISCOVERY CHANNEL

C-42

24

ODISSEIA

S-9

25

NATIONAL GEOGRAPHIC

C-45

26

HISTÓRIA

C-43

27

BIOGRAPHY CHANNEL

C-28

28

VH1

S-19

29

MEZZO

S-25

30

EURONEWS

S-26

31

CNN

S-32

32

BBC WORLD NEWS

S-16

33

BBC ENTERTAINMENT

S-17

34

SKY NEWS

S-13

35

ARTV

S-31

36

CANAL DE TESTE

S-12

37

CANAL DE TESTE 2

C-11

38

DESTAQUES DE PROGRAMAÇÃO

S11

Comments are closed.