Solved

How to map and parsing/reading two flat files

Posted on 2012-04-11
3
513 Views
Last Modified: 2012-04-23
Hi Friends,

I have a two flat files with hears/coloums like

Template_ Batch120408.txt

CMD_ID||CAI_CMD||DEPENDANCY_CMD_ID
1||CREATE:HLRSUB:MSISDN,@Param_MSISDN:IMSI,@Param_IMSI:PROFILE,2:RSA,1;||-1
2||SET:HLRSUB:MSISDN,@Param_MSISDN:BS3G,0;||1
3||SET:HLRSUB:IMSI,@Param_IMSI:OBO,1:OBI,2:PDPCP,250;||1
4||SET:ICSSUB:MSISDN,@Param_MSISDN:PAYTYPE,2:SCREENTYPE,1;||-1

Batch120408.txt

Param_MSISDN      Param_IMSI
966540510136      420030100033981
966540510295      420030100033982
966540510296      420030100033983
966540510298      420030100033984

How can i map and parse these two flat files?
0
Comment
Question by:PrakashVarma
3 Comments
 
LVL 40

Accepted Solution

by:
gurvinder372 earned 500 total points
Comment Utility
parsing first fie should not be a tough job since there seems to be a clear delimiter '||' between columns.
But
-- what are the semantics of these columns?
-- how does the columns map to information in second file?
-- what is the delimiter used in second file?
0
 

Author Comment

by:PrakashVarma
Comment Utility
- how does the columns map to information in second file?
i need solution for this

-- what is the delimiter used in second file?
comma(,)
0
 
LVL 16

Expert Comment

by:imladris
Comment Utility
To put it another way: What is the expected output?
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Windows Script Host (WSH) has been part of Windows since Windows NT4. Windows Script Host provides architecture for building dynamic scripts that consist of a core object model, scripting hosts, and scripting engines. The key components of Window…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now