Advertisement

[x]
Attachment Details

Need a Help

Hi,

       I need small help.I have 3 type of files,files will come as per the business needs.
       files look like these
                     realage_campaign1_20080201132132.txt
                     dogage_campaign2_20080201132132.txt                      
                     catage_campaign3_20080201132132.txt

Based on the type of file, i need to extract in two methods..
   1. Site ID will be derived based on first part of the file name

                      Site Name = realage  Site ID = 1
                      Site Name = dogage  Site ID = 2
                      Site Name = catage   Site ID = 3
    2. List Name will be based on 2nd part of the file name

                     Example : For file realage_campaign1_20080201132132.txt                                            
                                                   List Name = campaign1

Can you please help me to write the code to extract the above mentioned logic.

Thanks in advance

Related Solutions
Related Solutions
 
Loading Advertisement...
 

Rank: Master

Expert Comment by MikeOM_DBA:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 

Rank: Master

Expert Comment by awking00:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 

Rank: Wizard

Expert Comment by sujith80:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
Loading Advertisement...
20080924-EE-VQP-41 / EE_QW_2_20070628