Hi all, I have used GET TEXT to import a name into a variable. The name looks something like this
joe h. bloggs I have use LEFT/RIGHT to try to get the last part of the name (bloggs) as a new variable, however I keep getting a blank result
Full Text = Test (Contains the Name) - I have checked its populated using message box
Seperator = " "
I think there is a blank space at the end of the name so when trying to get a LEFT result I end up with nothing
How do I trim the end of the text
PLEASE NOTE this is studioX and not studio
Any help would be appreciated
Try this in assign or a previous step.
You could also try using Regex to grab the last word and then trim that also:
See this link for a preview
Thanks for the reply, StudioX doesnt have an assign (studio does) where would I put this?
You should be able to use the “trim” function in the output/result field of the get text.
Remember you can use “ctrl + space” to see that syntax options you have available. Look for “trim” then “tostring”
I have this
Saved.Values(Of System.String)(“Test”). you cant add trim to this, im confused
Can you try this solution:
But use this Regex pattern:
Regex.Match(Saved.Values(Of String)(“StrInput”),” \w+(?=\s*$)").Value
Hi thanks, I have seen that previously, however regex is not a menu option in studioX
Hold on, I may have been too quick with that reply, apologies
So added a write line activity plus the code you gave me thank you, i get this
REGEX is not declared error message
Please try this…
system.text.regularexpressions.Regex.Match(Saved.Values(Of String)("StrInput"),” \w+(?=\s*$)").Value
that got rid of the error thank you
Where does the result get recorded?
You can use “Save for Later activity” and save the output to another variable.
HI, thanks for the reply, the Write Line activity does not have a save for later option, or am i missing something?
sorry not awake yet, understand what you mean
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.