DSXchange

In Map Designer, when I click on Help and search for a topic, the list of topics comes up OK but when I click on the bottom box to go to the specific topic, it takes me to some unrelated subject. Has anyone had this problem ?
Thanks.

I got it....I added a component to the output tree definition and put the RUN statement in there. In the map, the output card looks like this: Output Rule ------------------------------------------- Extract(s) =(LEAVEPRINT(Record01) RunJob =Run("Job2"."")

The only formula I have is =LEAVEPRINT(Rec01). This is in the output rule
of my first extract. How do I code it and/or where ?
The syntax is RUN("Extract2",""). Do you conatentate it to the first formula ?

I see from the documentation that you can use the RUN command to execute another map. It also says that you can code it in a component rule or map rule. My second map is ready to run. The inputs and outputs are already defined. All I need to do is code RUN("Map02",""). Where does...

I looked at the log and the map recognizes the first two tags but then thinks the rest of the stream is data. It's not recognizing the </tag3> after the first chunk of data.

Same result. I would have thought something would change but it didn't.

I'm close....(I think) Input file looks like this: <tag1><tag2>dataxxxxxxxxxxx</tag2><tag3>dataxxxxx</tag3>>tag4>dataxxxxxxxxxxxzzz</tag4></tag1> The input is one continuous stream. I have the input file defined like this: Extracted_XML Group Extract_Rec(0:s) start_tag(0:s) initiator = <, terminator...

John: I apologize for these basic questions, but how do I define a series object ? I have a group defined and a record(0:s) under it.

I ended up using this: =F_String(SUBSTITUTE(LEAVEPRINT(Record1),"<Data1>","","</Data1>","|")) etc... The only problem being I have to hardcode the values of the tags. The next step is to come up with a way to inspect the string in a wildcard search. Seen the n...

Is there a way to do a wildcard search and replace ?

Something like....If field_x like "%zz%", replace field_x with "xyz".

I have one solution but I had to hardcode some stuff. This will work for now..... =SUBSTITUTE(LEAVEPRINT(record01),"<data1>","","</data1>","|")) etc. This returns a result of 111|222|333 etc. However, I had to hardcode the xml tags to be replaced. There must b...

Is there some way of extracting the data from the XML file without including the tags ?

I have just discovered that for now the tags are consistent...
<data1>1111</data1>
<data2>2222</data2>
<data3>3333</data3>
<data4>4444</data4>

etc...

The end result should be : 1111|2222|3333|4444

Thank you as always.

I guess I said that wrong.....I still need to figure out how to strip the xml
tags from the data.

I can do this:
<abc><rec>111</rec><dddec>222</dddrec><xrec>333</xrec> etc.


But not this:
111|222|333|444 etc.

Any suggestions ?

Thank you all very much.

I was actually able to string the data together by doing this: =LEAVEPRINT(DummyRecs) I used this against the group and did not need the F_Map. I just got lucky and stumbled into this command thanks to JanHess pointing me in the right direction. The new twist is that the xml tags are not consistent....