Element split

[Vinutha_L]

Hi guys
How to split the element PC00206608-01

I need PC00206608 only as output

[yundw]

PC00206608 -01

Is 01 a fixed value?

I need a rule

[supermanPunch]

@Vinutha_L Try this :

Split(“PC00206608-01”,"-")(0).ToString

[ImPratham45]

Var.Split("-"c)(0)

[Vinutha_L]

hi @yundw,

No its not fixed, it can be any value but it is in this format.

[mzahid]

Using regex (^[\s\S]{0,10})

[Vinutha_L]

hi @supermanPunch

the value can be changed its not constant. Actually am extracting the element from pdf using get text activity. the element is not constant. but its in this format

[supermanPunch]

@Vinutha_L Yes. You can try with Other values and check. If you are storing the value in a variable ,it should work considering the separator is “-”

strValue = “PC00206608-01”

Split(strValue,"-")(0).ToString

[yundw]

Is the standard string “-”?
Do you take the word before “-”?

[Vinutha_L]

hi @yundw

attached image for the reference.
Every time i need the policy number as output. As the pdf get change the policy number will also get change. i need only PC00206608.

policy number will be in same format. i need to extract only the number before the ‘-’

[yundw]

Best done with @supermanPunch’s answer

[Vinutha_L]

Hi @supermanPunch,

it worked!

Thanks a lot!!!

[mzahid]

Agreed with @supermanPunch . that is a best solution.

Attached is workflow using regex
RegexToRemoveCharactersAfter-.xaml (4.7 KB)

Where FinalStr is System.Text.RegularExpressions.Regex.Replace(Str,"(.*)…$","$1", System.Text.RegularExpressions.RegexOptions.None)

Irrespective of whatever the string is, Here the last 3 characters of the string are removed.

[Vinutha_L]

Hey @mzahid

Thanks a ton!!! …