Review M-Files on G2 & get a $25 gift card Arrow right Review us!

Options
  • Locked Locked
  • Replies 10 replies
  • Subscribers 8 subscribers
  • Views 312 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

A little VB Script help please?

Former Member
Former Member
I have property definitions for FirstName, Surname, and FullName.
I need the user to be able to enter the FullName in a single field, and to automatically calculate the FirstName and Surname.
I can use the automatic value 'Simple concatenating of properties' to achieve the reverse result, but presume I need to use Calculated Value(VBScript) to separate the FirstName and Surname.
I could do it easily in EXCEL but I'm not a programmer and don't know how to do it with VBScript. ???
I wonder if somebody would be kind enough to give me the code for this?
Parents
  • Former Member
    Former Member
    Can you specify in more detail how the FullName is entered. Is it e.g.


    • Firstname, Lastname

    • Firstname Lastname

    • Firstname MiddleName Lastname

    • Lastname, Firstname

    • Lastname Firstname

    • Lastname MiddleName Firstname



    Or something else? Then, based on your specification it is easier to give you the exact code that works as expected.

    Also, have you consideted working the other way around? E.g. having separate property definitions for the FirstName and LastName? Then, it is very easy to use the simple concatenation feature to concatenate the FullName property.

    Samppa

    P.S. Also all M-Files solution providers and M-Files consultants would be more than happy to help you with your scripting needs (but this is usually for a fee)
Reply
  • Former Member
    Former Member
    Can you specify in more detail how the FullName is entered. Is it e.g.


    • Firstname, Lastname

    • Firstname Lastname

    • Firstname MiddleName Lastname

    • Lastname, Firstname

    • Lastname Firstname

    • Lastname MiddleName Firstname



    Or something else? Then, based on your specification it is easier to give you the exact code that works as expected.

    Also, have you consideted working the other way around? E.g. having separate property definitions for the FirstName and LastName? Then, it is very easy to use the simple concatenation feature to concatenate the FullName property.

    Samppa

    P.S. Also all M-Files solution providers and M-Files consultants would be more than happy to help you with your scripting needs (but this is usually for a fee)
Children
No Data
M-Files
M-Files Support


© 2024 M-Files, All Rights Reserved.