how to extract file name and insert as a header in flat file

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

how to extract file name and insert as a header in flat file

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Ask XML questions here] >> BizTalkers >> how to extract file name and insert as a header in flat file

Page: [1]

Message

<< Older Topic Newer Topic >>

how to extract file name and insert as a header in flat... - 16 January 2008

Jay

Posts: 21
Score: 0
Joined: 16 November 2006
Status: offline

Hello,

I want to extract the name of the file and i want to insert the file name as a header in the Flat File . Currently my file does not have a header . Please tell me how should i do this

I have created source and destination schema with the orchestration and i want to make this modification inside the orchestration
Orchestration consist of Receive port and shape then i have construct shape, Inside the construct shape i have Transform message shape and below that i have Message Assign shape and then send port

Inside the Message Assign shape i have

//xpath(PendingWithHeaderMsg, "//Header") = PendingNoHeaderMsg(FILE.ReceivedFileName);
xpath(PendingWithHeaderMsg, "/*[local-name()='TransactionPending']/*[local-name()='Header']") = PendingNoHeaderMsg(FILE.ReceivedFileName);

Please help me urgent

Thank you
Jay

Post #: 1

RE: how to extract file name and insert as a header in ... - 25 January 2008

Siva

Posts: 102
Score: 0
Joined: 20 September 2006
Status: offline

are you still looking for a ans?

(in reply to Jay)

Post #: 2

RE: how to extract file name and insert as a header in ... - 25 January 2008

Jay

Posts: 21
Score: 0
Joined: 16 November 2006
Status: offline

Hello Siva

Yes I am still looking for an answer. I want to strip the file name and insert it as a header in the file. I did lot of things created orchestration and special schemas but it did not work. At some point i was able to get the path and the file name in the header but i dont want that i just want the file name inserted as a header in my CSV files

File name "Cash Balances As Of 01-03-2008.Csv"

Example
1-3-2008 <<<----- Header
1/3/2008,19-2360,ACTIVEPASSIVE INTL EQUITY FUND,Open,0,0,0,100000,100000
1/3/2008,19-2362,ACTIVEPASSIVE EMERGING MK/FUNDQUEST,Open,0,0,0,99900,99900

Thank you for your help in advance
Jay

(in reply to Siva)

Post #: 3