Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...This is easily the most helpful website I've ever used, and this is the best forum with the quickest response time bar none...."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Programmers > DBMS Packages > Microsoft: Visual FoxPro Forum

Can you identify this language?

thread184-1686455
Read More Threads Like This One
steve4king (IS/IT--Management)
21 Jun 12 15:17
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)

CODE

<?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 (IS/IT--Management)
21 Jun 12 16:31
in case that wasn't enough to go on here's another sample

CODE

CDATA[LEFT(SUBSTITUTE(VALUE("BillingStreet"),"\n"," "),41)]
mmerlinn (Programmer)
22 Jun 12 2:34
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

MikeLewis (Programmer)
22 Jun 12 3:26
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 (IS/IT--Management)
25 Jun 12 11:24
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!
Read More Threads Like This One

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Visual FoxPro

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close