Hello and welcome to this demonstration on manipulating strings using sub string con cat split format and replace methods. In this video, you will learn to create a workflow that will extract the name of the location from a sentence and display the name of the location in a different sentence in a message box. Also, it will ask the user for the tour budget and suggest an alternative place to visit. So, let's begin. Search for an assigned activity in the activities panel and drag and drop it in the designer panel. Let's rename the sequence as string manipulation. And add an annotation to it. Then rename the assigned activity as initial text. In the two text box, press control plus K to create a new variable and name it as initial text. Navigate to the properties panel of the assigned activity, click the ellipsis icon of the value field to open the expression editor window. Type, I live in Norfolk County in England. It is a great place to visit in double quotes, click OK. Search for an assigned activity again in the activities panel and drag and drop it below the first to sign activity, rename it as city name. In the two text box press control plus K to create a new variable and name it as city name. Navigate to the properties panel of the assigned activity, click the ellipsis icon of the value field to open the expression editor window, enter the expression, initial text dot sub string. Then wright initial text dot last index of in parenthesis and then right Norfolk and parenthesis of last index of, click OK. Here dot sub string extract specified characters from a string starting from the word Norfolk indicated within dot last index of. Search for a message box activity, drag and drop it below the second assign activity and rename it as message one. Navigate to its properties panel, click the ellipsis icon of the text property to open the expression editor window, enter string dot concat. In parenthesis, wright, thank you for showing interest in touring in double quotes plus city name, click OK. Search for an input dialog activity. Drag and drop it below the message box activity and rename it. In double quotes, enter the title text, user budget in the dialog title and label text, what is your tour budget in the input label box. Navigate to the variables panel, create a variable called budget with variable type is string and set its scope to sequence string manipulation. Close the variables panel, go to the input dialog activities properties panel and enter the budget variable in its result property. Drag and drop in a sign activity below the input dialog activity and rename it as message. In the two text box, press control plus K to create a new variable same message. Navigate to the properties panel of this activity and click the value properties ellipsis icon to open the expression editor window, enter the expression string dot format, then start parenthesis and enter zero in curly brackets. Then type is too low to go and type one in curly brackets. After that, enter comma budget, comma city name. On execution, zero will be replaced by budget and one will be replaced by city name, click OK. Search for another assigned activity and drag and drop it below the previous assign activity and rename it as first sentence. In the two text box, press control plus K to create a new variable and name it as first sentence. Navigate to the properties panel of this activity and click the value, properties ellipsis icon to open the expression editor window. Enter the expression message dot split start parenthesis, enter period in double quotes followed by C. Insert first after parenthesis followed by dot to string, click OK. Search for a message box activity below the assigned activity and rename it. Enter the variable first sentence in its text box. Drag and drop another message box activity below the previous message box activity and rename it as message two. Navigate to its properties panel and click the text fields ellipsis icon to open the expression editor window, enter the expression but comma space in double quotes plus first sentence dot replace. Then start parenthesis and enter low and good in double quotes separated by comma dot replaced after the parenthesis. Start parenthesis, enter Norfolk and Cornwall in double quotes separated by a comma, click OK. Save the project and run it. You can see that the country name is extracted and displayed an additional text, click OK. It asks for a tour budget, enter any value, say 50 and click OK. It says the budget is too low, click OK and now it offers another location to visit, click OK. The workflow ran successfully. It is encouraged to try this activity by building the workflow as demonstrated and familiarize yourself with the various string manipulation methods in studio. Thank you for watching.
