Hi All, so far you guys have been awesome solving all my questions so thank you so much for the awesome help.
Now to the question, I get a Excel report every morning with case numbers, these case numbers look like this: Incident: INC1234567, I need to extract only the INC1234567 and be able to write it into a web form, now i know how to write it into a web form, but i don’t know how to get only the INC12134567 without the “Incident:” prepended.
Please take a look at the Example report, from the column C I only need the following case numbers: “INC1234567” not “Incident: INC1234567”
Hi Thank you for your solution, that works how ever i also get Item: not just the INC, for better understanding take a look at this example report pleae. Example Report.xlsx (9.8 KB)
continue use the expression i gave to you, the split method take the text after the colons, doesn’t matter what exist before or after, the method just divide the expression while he find any “:” Sequence.xaml (8.5 KB)