How to extract only vendor tax id in assignment2.I am getting tax id as (de123456 name) .Can anyone guide me?


#1

Hi all how to extract only taxid without name ?Can anyone help me ?In download monthly reports page,vendor tax id is typing as de123456 name.How should i get only tax id as de123456 when entering.Please help me if anyone knows.


#2

@SUPRIYA123

what method your using…?

use Get text- the result string you can split and get the required value


#3

I have used assign activity and used split and trim expressions.But not getting correct result.


#4

u have mentioned your getting output like this " de123456 name".

in that case replalce the name with “”, use value.replace(variable1,“name”,"")


#5

I solved it this way.
Use GetText Activity then get extracted string,
Use Generate DataTable Activity with seperator “:” input string is your extracted string
Assing Your DataTable.Rows(0)into temp string variable,
then you can split your temp string to get your taxID

Hope this will help you.


#6

ya.thanks.let me try.


#7

thanks.let me try it


#8

usevalue means?


#9

can u tell split expression


#10

split with : and arr(1) will be your taxid :+1:


#11

@bala_subramanyam

if you split with " : ", you will get id with name right…?

TaxID: RO345879
Name: Megatronic Incorporated
Address: Strada Sperantei la parter
City: Bucuresti, Romania!

Capture|690x274

@SUPRIYA123

syntax mistake from my side: just use —> variable.replace(“Name”,"")

thanks


#12
<webctrl css-selector='body&gt;div&gt;div&gt;div&gt;div&gt;div&gt;div&gt;div' idx='1' tag='DIV' />

This is my selector for extracting the ID!
Try using this and tell me if this works! I’ve used screen scraping! :slight_smile:(i.e. getvisibletext)

Regards
Niket Ghai


#13

got id from this expression but how to bind this in create yearly report invoke file.ID is not entering in field.


#14

@SUPRIYA123

i have just started with Assignment2 yet come to the flow your talking about so i dont know how to enter this step.

thanks


#15

ok…