Search found 10 matches

by DM_Cal
Fri Dec 19, 2008 8:58 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Trying to amend the VBScript in a standard filter
Replies: 1
Views: 3314

Trying to amend the VBScript in a standard filter

Hello I was trying to create a new filter based on an existing standard filter. The standard filter is 'rename files according to contents.fll' I want to change it so that rather than it creating a 'rename' line for each line in the input I just want a file created with only one rename line (i.e if ...
by DM_Cal
Wed Oct 22, 2008 9:20 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Suppressing main output file
Replies: 2
Views: 4228

Suppressing main output file

I wonder if someone can help me here. I have a filter that takes in input files and merges them. What I want to do is generate a full report from the main output (so far so good) but I also want to generate a file (doesn't matter what is in it) that tells me how many input files I received. I then h...
by DM_Cal
Tue Jun 03, 2008 6:43 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Capture value btwn XML tags, split it and use it elsewhere
Replies: 4
Views: 6125

Re: Capture value btwn XML tags, split it and use it elsewhere

Fantastic. It worked as you intimated if I removed the <Sender_ID> and <Receiver_ID> and then did a:- FIND <ENVELOPE>(.*)</FUNCTION>(.*)<VALUE>(.*)([AB]TYPE)</VALUE>(.*) REPLACE WITH <ENVELOPE>$1 <SENDER_ID>$4</SENDER_ID> <RECEIVER_ID>$3</RECEIVER_ID>$2<VALUE>$4</VALUE>$5 Had to remove a line with a...
by DM_Cal
Thu May 29, 2008 7:45 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Capture value btwn XML tags, split it and use it elsewhere
Replies: 4
Views: 6125

Re: Capture value btwn XML tags, split it and use it elsewhere

I tried this using 'find perl pattern' (which was the only one that seemed to 'work') and I got almost what I wanted except that these are in the wrong place:- <ENVELOPE> <CONTROL_NUMBER>321</CONTROL_NUMBER> <FUNCTION>0</FUNCTION> <SENDER_ID>Company X</SENDER_ID> <RECEIVER_ID>Company Y</RECEIVER_ID>...
by DM_Cal
Wed May 28, 2008 12:42 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Capture value btwn XML tags, split it and use it elsewhere
Replies: 4
Views: 6125

Capture value btwn XML tags, split it and use it elsewhere

I am trying to do the following. Search for a value held between a pair of XML tags(<ENVELOPE_PARM><VALUE>) then take that value and split it into two parts and then use them elsewhere in the xml file. Also I need to then overwrite that original value with one of the two parts. So if I get this in:-...
by DM_Cal
Sat Dec 15, 2007 12:25 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Trying to output an XML value into the filename
Replies: 0
Views: 8917

Trying to output an XML value into the filename

I'm trying to get a filter that checks XML files for a specific element value(<CountryofFinalDestinationCode>) then outputs the filename with that element value. For example if file is test1.txt and value is US it appears as test1_US.txt, if file is test2.txt value is AU it outputs test2_AU.txt. I a...
by DM_Cal
Fri Oct 19, 2007 9:42 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Splitting based on an XML element value
Replies: 6
Views: 9658

OK I will look into it.
thanks Simon for all your help with this
by DM_Cal
Fri Oct 19, 2007 6:17 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Splitting based on an XML element value
Replies: 6
Views: 9658

Can I maybe approach this from a different perspective? For instance if I can get the file into lines of data like this:- <OrderDetail><Value>A</Value><Info>ABC</Info></OrderDetail> <OrderDetail><Value>A</Value><Info>DEF</Info></OrderDetail> <OrderDetail><Value>B</Value><Info>GHI</Info></OrderDetail...
by DM_Cal
Fri Oct 19, 2007 5:07 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Splitting based on an XML element value
Replies: 6
Views: 9658

Sorry Simon maybe I wasn't specific enough. Unfortunately I can't guarantee what range of values I will receive. For instance I could get 2 x Value A OrderDetails, 1 x Value B, 4 x Value Cs, 3 x Value Ds, and so on. Therefore I can't have the subfilters specify what the value is since it is variable...
by DM_Cal
Thu Oct 18, 2007 9:27 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Splitting based on an XML element value
Replies: 6
Views: 9658

Splitting based on an XML element value

I am trying to split the following type of XML Order using textpipe:- <Message> <Head> </Head> <Body> <OrderHeader> <OrderDetail><Value>A</Value><Info>ABC</Info></OrderDetail> <OrderDetail><Value>A</Value><Info>DEF</Info></OrderDetail> <OrderDetail><Value>B</Value><Info>GHI</Info></OrderDetail> <Ord...