Hello, and welcome to the step-by-step demo of how to manipulate strings using substring, concat, split, format, and replace methods. We'll demonstrate this by creating 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 tour budget and suggest an alternative place to visit. Search for an Assign activity in the Activities panel and drag and drop it in the Designer panel. A sequence is created automatically when the Assign activity is dropped in the Designer panel. Let's rename the Sequence activity as string manipulation and add an annotation to it. Then rename the Assign activity as initial text. In the To text box, press control plus k to create a new variable and name it as initialText. Navigate to the properties panel of the Assign activity. Click on 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,'' click, "Okay " Search for an Assign activity again in the activities panel, and drag and drop it below the first Assign activity, rename it as City Name. In the To text box, press control plus k to create a new variable and name it as cityName. Navigate to the properties panel of the Assign Activity. Click on the ellipsis icon of the value field to open the Expression Editor window, enter the expression initialText.Substring. Then write initialText.LastindexOf["Norfolk"], click Okay. Here,.substring extract specified characters from a string, starting from the word Norfolk indicated within.lastindexof. Search for a Message Box activity, drag and drop it below the second Assign activity and rename it as Message 1. Navigate to its properties panel and click on the ellipsis icon of the text property to open the Expression Editor window. Enter String.Concat then in parenthesis write ["Thank you for showing interest in touring'' plus CityName] then click "Okay." Search for an Input Dialog activity. Drag and drop it below the Message Box activity and rename it in double-quotes into 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 budgets with variable type as string and set its scope to sequence string manipulation. Go to the Input Dialog activities, properties panel, and enter the budget variable and its result property. Drag and drop an Assign activity below the input dialog activity and rename it as Message. In the To text box, press control plus K to create a new variable, say message. Navigate to the Properties panel of this activity, and click on the value Properties ellipsis icon to open the Expression Editor window into the expression String.Format, then start ["(0) is too low to go (1)",budget,cityName]. Upon execution, zero will be replaced by budget, and one will be replaced by cityName. Click, "Okay." Search for another Assign activity and drag and drop it below the previous Assign activity and rename it as First Sentence. In the To text box, press control plus k to create a new variable and name it as firstSentence. Navigate to the properties panel of this activity and click on the value properties ellipsis icon to open the Expression Editor window into the expression, message.Split["."c]First.ToString. Click "Okay." Search for a Message Box activity below the Assign activity and rename it into the variable firstSentence in its text box. Drag and drop another Message Box activity below the previous Message Box activity and rename it as Message 2. Navigate to its properties panel and click on the text field's ellipsis icon to open the Expression Editor window into the expression "But, " plus firstSentence["low", "good"].Replace["Norfolk", "Cornwall"]. Click "Okay." Click "Save" to save the project and run it. You can see that the country name is extracted and displayed with additional text. Click "Okay," it asks for a tour budget enter any value, let's say 50, and click "Okay." It says the budget is too low. Click "Okay," and now it offers another location to visit. Click "Okay." Thanks for watching. Goodbye.
