Rpa dev

[HareeshMR (Hareesh Madasi)]

Split function will take a character to split the entire string. So we are passing the values in the double quotes and implicitly mentioning it as a character @shilpa1

[shilpa1 (shilpa R N)]

ok I got

[HareeshMR (Hareesh Madasi)]

@shilpa1

Happy to help

[shilpa1 (shilpa R N)]

yup thanks

[shilpa1 (shilpa R N)]

SpiceJet Limited
Domestic Terminal, xxxxx International Airport(P) Ltd, xxxxxx xxxxxx
International Airport, Terminal 1d,
nnn nnnnn110087
GSTIN of SpiceJet Limited : 11xxxxx1459x1ZT

how do I get the gstin of SpiceJet

[HareeshMR (Hareesh Madasi)]

pos.Substring(pos.IndexOf("GSTIN of SpiceJet Limited : ")+"GSTIN of SpiceJet Limited : ".Length).Split(Environment.NewLine.ToCharArray)(0)

Try this @shilpa1

[shilpa1 (shilpa R N)]

Terminal, xxxxx I

getting this one

[HareeshMR (Hareesh Madasi)]

Can you post the text in assign activity you have @shilpa1…

May be again some upper case or text … Try copy and pasting the text from tha main text

[shilpa1 (shilpa R N)]

yeah, tq

[HareeshMR (Hareesh Madasi)]

Glad to help you again @shilpa1

[shilpa1 (shilpa R N)]

Original Invoice No:00000/0000000000 Invoice No: 000000/0000000000
Original Invoice Date:26­Nov­2018
11:38 AM Invoice Date: 03­Dec­2018
10:43 AM
Bill to
Passenger: MR. ARINDAM MUKHERJEE
PNR: z8zz3Z Sector: Gangtok ­ Kolkata
GSTIN / UIN of Customer: 06AAACM0829Q1Z8 Place of Supply: Haryana

gstofcus.Substring(gstofcus.IndexOf("GSTIN / UIN of Customer: ")+"GSTIN / UIN of Customer: “.Length).Split(” "c)(0)

for some pdf im not getting correct result

[HareeshMR (Hareesh Madasi)]

What you are getting @shilpa1?

can you post the output and assign activity !!

[shilpa1 (shilpa R N)]

I need to get gstin of customer

[HareeshMR (Hareesh Madasi)]

I’m getting it @shilpa1

[shilpa1 (shilpa R N)]

for some pdfs im not getting correct value

[HareeshMR (Hareesh Madasi)]

May be the text changes there or any spaces between the text will be added in those pdf’s @shilpa1…check that

[shilpa1 (shilpa R N)]

so, any solution

[HareeshMR (Hareesh Madasi)]

using regex will help you get the particular text in the entire text and it doesn’t need the text to be same everytime @shilpa1

But sorry, I don’t know much Regex
Adding the expertise to help you here @Pablito

Please help her

[Pablito (Pawel Wozniak)]

Hi @shilpa1,
With regex it’s imo easier to achieve this. Let me show you an example:



etc.

[shilpa1 (shilpa R N)]

regex is not a problem but while writing it to an excel im not getting the value…

System.Linq.Expressions.NewExpression