In my input file,some rows have dropdown list wtth 1,2 and 3 choices,i need solution to remove text from them throught workflow.
Looks like this
1-some random text
2-other text
3- some other text
User will choose some from that and throught workflow i need to get just 1,2 or 3 in output
Solved! Go to Solution.
Not very sure I understand you right... could you provide some sample data and what your expected output would look like?
My input has dropdown list which contains : 1-some text, 2-some text,3-some text,and user will choose what he needs,and then that input will go in workflow,for example it will be 2-some text, i need solution that will remove this -some text so in output will only 2 will be shown
Could you kindly provide some data to work with...?
Does this work?
Left([Choice], 1)
Hi @Aleksandar1 you can use this formula in a formula tool to only get the first character in a field:
LEFT([Field],1)