How to parse data in javascript file through .net?

Question

How to parse data in a java script file through .net .

I have an url like this :

http://..../xml/en/file_1.js

The data in my .js file is like this :

getdate(20140802,'','','',10,5);
getdate(20140802,'','','',10,5);
getdate(20140727,'','','',10,5);
getdate(20140727,'','','',10,5);
getdate(20140723,'','','',10,5);
getdate(20140723,'','','',10,5);

for example I want to interpret 20140802 to 02 as day and 08 as month and 2014 as a year and so on through the whole file ...

are you able to get the string "20140802" so that it is easy to parse as you wish. — Sudhakar Tillapudi
– Sudhakar Tillapudi, Commented Nov 19, 2013 at 9:38

Sudhakar Tillapudi · Accepted Answer · 2013-11-19 10:01:52Z

Step1: Read All Lines from the JS file.

Step2: from each Line get the substring from ( to next 8 characters(Date is 8 characters length)

Step3: you can Convert the obtained date string into Date Type using ParseExact() method by providing format yyyyMMdd

Complete Solution:

                String [] JSLines=System.IO.File.ReadAllLines("c:\\myfile.js");
                String strDate = "";
                for(int i=0;i<JSLines.Length;i++)
                {                        
                    strDate=JSLines[i].Substring(JSLines[i].LastIndexOf("(")+1,8);               
                    DateTime myDate = DateTime.ParseExact(strDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);                               
                }

Output: myDate Contains the Date

Tigran · Accepted Answer · 2013-11-19 09:42:55Z

1

So basically if you have a current date presented like yyyyMMdd, you can parse it like :

    string d = "20131118"; 
    System.Globalization.CultureInfo provider = 
            System.Globalization.CultureInfo.InvariantCulture;

    DateTime da = DateTime.ParseExact(d, "yyyyMMdd", provider);

This will result in DateTime instance with

Day :   18
Month : 11
Year:   2013

answered Nov 19, 2013 at 9:42

Tigran

62.3k8 gold badges90 silver badges124 bronze badges

2 Comments

Anyname Donotcare Over a year ago

thanks but i don't ask basically about that , i ask how to the load .js file and get all the numbers after the first circle bracket through all the file

Tigran Over a year ago

@just_name: can build regular expression, for example with: gskinner.com/RegExr

Collectives™ on Stack Overflow

How to parse data in javascript file through .net?

2 Answers 2

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Related