Can you identify this language?

[steve4king]

I know this isn't a fox question, but I've found the active members here to be quite sharp.

I'm using a 3rd party web app connector. They leave XML files open so that I can alter the mappings.
They have been pretty unresponsive when I try to work with them so I've started just modifying the program myself.

However, I'm not sure what language is used in the CDATA blocks for the data validation/translations, and so I've only been able to make generic changes.
Can anyone ID this so that I can look up the available functions? (repeated trial and error on live data isn't fun)

<?xml version="1.0" encoding="UTF-8"?>
<class>
  <function>
    <name>BillingStreet</name>
    <translate language="formula" type="="><![CDATA[VALUE("BillAddress/Addr1") + " " + VALUE("BillAddress/Addr2") + " " + VALUE("BillAddress/Addr3") + " " + VALUE("BillAddress/Addr4") + " " + VALUE("BillAddress/Addr5")]]></translate>
  </function>
  <function>
    <name>Name</name>
    <translate language="formula" type="="><![CDATA[LEFT(VALUE("Name"),41)]]></translate>
  </function>
  <function>
    <name>VALIDATEROW</name>
    <translate language="formula" type="="><![CDATA[IF(OR(VALUE("ParentRef/ListID")==null, VALUE("ParentRef/ListID")==""),"true","false")]]></translate>
  </function>
</class>

Thanks!

 

[steve4king]

in case that wasn't enough to go on here's another sample

CDATA[LEFT(SUBSTITUTE(VALUE("BillingStreet"),"\n"," "),41)]

 

[mmerlinn]

I put "SUBSTITUTE()" in Google and the primary thing that came up was Excel. Try doing the same thing for other functions in your program that are not common to many other programs and see what comes up. You might be able to find what you need by doing that.

mmerlinn

http://mmerlinn.com

Poor people do not hire employees. If you soak the rich, who are you going to work for?

"We've found by experience that people who are careless and sloppy writers are usually also careless and sloppy at thinking and coding. Answering questions for careless and sloppy thinkers is not rewarding." - Eric Raymond

 

[Mike Lewis]

Actually, I think it is Excel. LEFT(), SUBSTITUTE() and VALUE() are all Excel functions, and the overall syntax looks like Excel.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[steve4king]

Yeah, it does appear to work pretty much like excel, which is surprising giving the application. I figure the programmer made a bunch of custom functions modeled after Excel.

I was able to figure out most of it based on that assumption. If only the logging was better haha.

Thanks guys!