Graphics

Hi! I am trying to reformat names that come in from datalinq as Last, First into First Last through visual logic. I am pretty sure this is possible, but I am not entirely sure what the best way to go about it is. Any ideas?

Hi! I am trying to reformat names that come in from datalinq as Last, First into First Last through visual logic. I am pretty sure this is possible, but I am not entirely sure what the best way to go about it is. Any ideas?

------------------------------
Philip Doherty
Elon University
------------------------------

The script is only 5 lines of code if you want to try it.

if InStr(text, ",") > 0 then

    text = split(text, ",")(1) & " " & split(text, ",")(0)

else

   text = text

end if

------------------------------
Malcolm Thorpe
xpression design
Free Lance Xpression Designer/Carbonite TD

Original Message:
Sent: 01-05-2024 11:46
From: Philip Doherty
Subject: Reformatting names with visual logic

Hi! I am trying to reformat names that come in from datalinq as Last, First into First Last through visual logic. I am pretty sure this is possible, but I am not entirely sure what the best way to go about it is. Any ideas?

------------------------------
Philip Doherty
Elon University
------------------------------

I am relatively new to scripting, should I put this in the object, or the scene itself? Also, do I need to declare any variables beforehand?

The script is only 5 lines of code if you want to try it.

if InStr(text, ",") > 0 then

    text = split(text, ",")(1) & " " & split(text, ",")(0)

else

   text = text

end if

------------------------------
Malcolm Thorpe
xpression design
Free Lance Xpression Designer/Carbonite TD

Original Message:
Sent: 01-05-2024 11:46
From: Philip Doherty
Subject: Reformatting names with visual logic

Hi! I am trying to reformat names that come in from datalinq as Last, First into First Last through visual logic. I am pretty sure this is possible, but I am not entirely sure what the best way to go about it is. Any ideas?

------------------------------
Philip Doherty
Elon University
------------------------------

you would put this script on the text field in your scene that is linked to your data. No variables needed. It looks at the text and finds any commas, then uses that to split the string and flip the order. If there are no commas, it just passes the name through. It's pretty slick. Be sure to compile the script afterwards. (little orange logo in the script window up at the top)

I am relatively new to scripting, should I put this in the object, or the scene itself? Also, do I need to declare any variables beforehand?

The script is only 5 lines of code if you want to try it.

if InStr(text, ",") > 0 then

    text = split(text, ",")(1) & " " & split(text, ",")(0)

else

   text = text

end if

------------------------------
Malcolm Thorpe
xpression design
Free Lance Xpression Designer/Carbonite TD

Original Message:
Sent: 01-05-2024 11:46
From: Philip Doherty
Subject: Reformatting names with visual logic

Hi! I am trying to reformat names that come in from datalinq as Last, First into First Last through visual logic. I am pretty sure this is possible, but I am not entirely sure what the best way to go about it is. Any ideas?

------------------------------
Philip Doherty
Elon University
------------------------------

It works! Thank you so much, I am going to try and teach my self some visual basic as it seems like scripting gets more and more useful.

you would put this script on the text field in your scene that is linked to your data. No variables needed. It looks at the text and finds any commas, then uses that to split the string and flip the order. If there are no commas, it just passes the name through. It's pretty slick. Be sure to compile the script afterwards. (little orange logo in the script window up at the top)

I am relatively new to scripting, should I put this in the object, or the scene itself? Also, do I need to declare any variables beforehand?

The script is only 5 lines of code if you want to try it.

if InStr(text, ",") > 0 then

    text = split(text, ",")(1) & " " & split(text, ",")(0)

else

   text = text

end if

------------------------------
Malcolm Thorpe
xpression design
Free Lance Xpression Designer/Carbonite TD

Original Message:
Sent: 01-05-2024 11:46
From: Philip Doherty
Subject: Reformatting names with visual logic

Hi! I am trying to reformat names that come in from datalinq as Last, First into First Last through visual logic. I am pretty sure this is possible, but I am not entirely sure what the best way to go about it is. Any ideas?

------------------------------
Philip Doherty
Elon University
------------------------------