Extract string after letter

Help
1

Hi
I have a workflow that extracts a number from a citrix screen and inserts it in another screen, It scrapes the screen in a certain place. The issue is that the number is being prefixed by diffrent characters and also the number length is variable.
What I would like to do is read the whole number and only use the characters after the ā€œPā€ an example is the number might read 002P876543 or 002/P87654 or P556789 I need to read just the Pand the following number.
Does anyone know how I can do the equivalent of FIND in Excel.

Thanks
Dave

2

Hi @dsb18,

You can split the string on the basis of ā€œPā€ and then use the second item of the array.

Regards,
V

3

Hi Vikas

Not sure how you mean, I have used Split in a string array, this is a straight forward string is it Split(POrderno.tostring,ā€œPā€)
Thanks

4

Hi,

Here is a small example, hope this helps.

Forum_SplitString.xaml (6.0 KB)

Regards,
V

1 Like
5

Thank you Vikas