Is there a way to export last word of a string into a new field?
You can use this code as validation script of a field where text is:
this.getField("Text1").value = event.value.split(" ").pop();
Change field name if needed.
Thank you so much. I have additional question.
In my string first and last word are numbers. How would I extract both numbers and then join them,
but numbers from end of the strings should be first?
Just add this '+event.value.split(" ").shift();' to the code like this:
this.getField("Text1").value = event.value.split(" ").pop()+event.value.split(" ").shift();
TIP: split(), splits string into array.
pop(), removes last element of array and returns that element
and shift(), removes first element of array and returns that element.
Do you want to add the numbers to each other, or join them as strings?
As i wrote in my post, I wanted numbers from end of the string to be first for example "12 hello 34"
and I wanted numbers to be 3412, so Nesa code gives me that. Is there better solution?
No, Nesa's solution is excellent. I just thought you might wanted to add those numbers together (so in your example the result would be 46), not concatenate them as strings. But if that's what you want to do then Nesa's solution should work just fine.
Thanks Thom Il take a look at it.
Hi, I have additional question. In my text field "Text1" I have a string that starts with a letter and end with a number.
I want to show this in second field but I need letter to be next to a number. e.g. original text: "X some text 1234"
new text: "some text 1234X".
var str = this.getField("Text1").valueAsString;
var xstr = str.split("");
ystr = xstr.join("");
event.value = ystr;