DataMystic

DM_Cal

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 ...

DM_Cal

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 ...

DM_Cal

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 ...

DM_Cal

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 ...

DM_Cal

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 ...

DM_Cal

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 ...

DM_Cal

OK I will look into it.
thanks Simon for all your help with this

DM_Cal

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 ...

DM_Cal

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 ...

DM_Cal

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 ...

DataMystic

Search found 10 matches

Trying to amend the VBScript in a standard filter

Suppressing main output file

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

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

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

Trying to output an XML value into the filename

Splitting based on an XML element value