Extract string after letter


#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


#5

Thank you Vikas