One for the tech guys?

[RSDonovan]

I’m not sure if this is the correct forum, please advise if not and I’ll move it.

i want a plain text file containing all the three letter station abbreviation codes eg. STP EUS HOV ECR etc. as plain text I have seen many links that lead to spreadsheets etc. but I just need a text file, either undelimited eg STPEUSHOVECR or delimited eg STP,EUS,HOV,ECR or similar. I can deal with line feeds but only if they are consistent.

I hope someone will be able to help me!

Thanks in advance

 

[The_Train]

I'm no expert but is it not just possible to save one of the spreadsheets you've been linked to as a .txt file?

 

[pdeaves]

My immediate thought is to take one of those spreadsheets and 'save as' text (or copy/paste into a text file).

 

[RSDonovan]

I'm no expert but is it not just possible to save one of the spreadsheets you've been linked to as a .txt file?

Unfortunately not. There are loads of embedded control characters that would be almost impossible to unscramble! Thanks anyway

 

[ComUtoR]

Would a csv file help ?

== Doublepost prevention - post automatically merged: 8 Apr 2022 ==

I have the original CSV and converted it to tab delimited but its ugly as sin. The forum doesnt allow .csv uploads. Just uploaded a slightly better version. Just a few tabs out of alignment.

 

[RSDonovan]

Hi! In what way is it “ugly as sin”? I’m trying to avoid too much processing. What if you just saved it as a .txt file?

 

[SargeNpton]

Can you not just open up one of the spreadsheets, highlight the column that contains the CRS codes, then copy & paste that into a new text file?

 

[RSDonovan]

Would a csv file help ?

== Doublepost prevention - post automatically merged: 8 Apr 2022 ==

I have the original CSV and converted it to tab delimited but its ugly as sin. The forum doesnt allow .csv uploads

I now see that it looks like a saved spreadsheet file. It still contains all the spreadsheet control characteristics which I am trying to avoid. Thanks anyway

== Doublepost prevention - post automatically merged: 8 Apr 2022 ==

Can you not just open up one of the spreadsheets, highlight the column that contains the CRS codes, then copy & paste that into a new text file?

I don’t have a spreadsheet program!

 

[pelli]

You can use Google Sheets online if you don't want to install a free spreadsheet program such as LibreOffice Calc.

For example, National Rail Enquiries publishes their list here: https://www.nationalrail.co.uk/stations_destinations/48541.aspx . You can download the CSV file and open it in Google Sheets online, and extract the data you want. Also, in fact, you can just select and copy the entire table on the web page and paste into Google Sheets, then copy out the second column only into your text file (which is what I've done to get the attached file).

Edit: The web page is dated 5 Aug 2020 while the CSV file is dated 7 Dec 2020, but the only difference between the two is that the CSV file contains Okehampton twice.

 

[ComUtoR]

It still contains all the spreadsheet control characteristics which I am trying to avoid.

Only shows as a standard txt file for me. This was opened in notepad. What program are you opening it with ?

 

[py_megapixel]

Unfortunately not. There are loads of embedded control characters that would be almost impossible to unscramble! Thanks anyway

I've just copied and pasted the list from the National Rail website and run it through a quick Python script that removes any control characters and then rewrites all the codes into a text file. There should not be any line breaks in this (except perhaps at the end), just the codes and delimiters. Is this suitable for your use?

 

[37078xotTE]

I’m not sure if this is the correct forum, please advise if not and I’ll move it.

i want a plain text file containing all the three letter station abbreviation codes eg. STP EUS HOV ECR etc. as plain text I have seen many links that lead to spreadsheets etc. but I just need a text file, either undelimited eg STPEUSHOVECR or delimited eg STP,EUS,HOV,ECR or similar. I can deal with line feeds but only if they are consistent.

I hope someone will be able to help me!

Thanks in advance

 

[RSDonovan]

You can use Google Sheets online if you don't want to install a free spreadsheet program such as LibreOffice Calc.

For example, National Rail Enquiries publishes their list here: https://www.nationalrail.co.uk/stations_destinations/48541.aspx . You can download the CSV file and open it in Google Sheets online, and extract the data you want. Also, in fact, you can just select and copy the entire table on the web page and paste into Google Sheets, then copy out the second column only into your text file (which is what I've done to get the attached file).

Edit: The web page is dated 5 Aug 2020 while the CSV file is dated 7 Dec 2020, but the only difference between the two is that the CSV file contains Okehampton twice.

That’s brilliant thanks a lot

 

[RailAleFan]

You can use Google Sheets online if you don't want to install a free spreadsheet program such as LibreOffice Calc.

For example, National Rail Enquiries publishes their list here: https://www.nationalrail.co.uk/stations_destinations/48541.aspx . You can download the CSV file and open it in Google Sheets online, and extract the data you want. Also, in fact, you can just select and copy the entire table on the web page and paste into Google Sheets, then copy out the second column only into your text file (which is what I've done to get the attached file).

Edit: The web page is dated 5 Aug 2020 while the CSV file is dated 7 Dec 2020, but the only difference between the two is that the CSV file contains Okehampton twice.

Having seen the date I thought i'd double check and the National Rail Enquiries CSV is missing a couple of the more recent openings...

Bow Street (BOW)
Kintore (KTR)
Soham (SOJ)

 

[RSDonovan]

I've just copied and pasted the list from the National Rail website and run it through a quick Python script that removes any control characters and then rewrites all the codes into a text file. There should not be any line breaks in this (except perhaps at the end), just the codes and delimiters. Is this suitable for your use?

That is absolutely brilliant thanks a million