I use the below script to edit a datalinq text field that is pulling user names from facebook. So John Doe becomes John D. This script works perfectly but for some reason if I make the text field static, the script stops working and I'm not sure why. Anybody have any advice... Thank you.
dim first as string
dim last as string
first = Split(Text," ",2)(0)
'grabs first name
last = Split(Text," ",2)(1)
'grabs last name
last = Left(last,1) & "."
'trims last name to just the first letter and adds a period
text = first & " " & last
'outputs the first name and the trimmed last name