Unable to split Client ID,Name and counter for level-3 assignent

Hi fnds,

im unable to split Client ID,Name and counter for level-3 assignent…

Please gide me

Use this to get Client Name… @venkateshtangudu

text.Substring(text.IndexOf("Client Name: ")+"Client Name: ".Length).Split(Environment.NewLine.ToCharArray)(0)

And try for remaining

Credits to @lakshman

1 Like

Hi Hareesh,

it not working

Can you post the value you are using in assign activity?

Here you are missing something…

Filtereddata.ToString.Split({":",“Client ID”}, StringSplitOptions.RemoveEmptyEntries)

Filtereddata is a data table , I don’t know why you are using this.

In the above get text activity use another variable as text or something… It will return you the string, then use the condition i gave in earlier post @venkateshtangudu,

That will help. You don’t have any output variable in get text activity in the file attached. So , you are not getting any values related to client

@venkateshtangudu split(outtext.Split(environment.NewLine.ToArray(),stringsplitoptions.RemoveEmptyEntries)(0),":")(1).ToString give like buddy you will get the output as client id numberin the same way replace 0 with 1 and 2 for the next two lines you will get the output and at last concatenate the 3 variables.

if you find above one as hard give like this **outtext.split({":"},stringsplitoptions.removeemptyentries)**this will give you output as array of string,and then by seeing the index of the requirement append them.

hii

its not working…getting error

Hello @venkateshtangudu

this is how i did it.

for this i used this activities:
-Find Image
-set crippling region
-get visible text or OCR
and an assing box

Also to get the coords for the clippling region you need to use the get position activity

do that with all the info you need to extract.

check the pics below

image
image

cheers!

What is the output of Get Text activity above that assign activity @venkateshtangudu ?

That variable you have to use in the assign

@venkateshtangudu Try this on the Filtereddata variable.

Filtereddata.Split(Environment.NewLine.ToCharArray)(1).Trim().Substring("Client ID: ".Length)

Watch this video

@venkateshtangudu buddy replace outtext with the variable of your text. Don’t put anything before split. Just replace the outtext with filtereddata

Now try this @venkateshtangudu,

Filtereddata.Substring(Filtereddata.IndexOf("Client Name: ")+"Client Name: ".Length).Split(Environment.NewLine.ToCharArray)(0)

Hi @venkateshtangudu

Uae substring where we can get client name client I’d etc

Thanks
Ashwin.S

hello @venkateshtangudu
store in string array clientdetails.Split(Environment.NewLine.ToArray,StringSplitOptions.RemoveEmptyEntries)

then
store clientID = idtoremainingstr(0).Substring(idtoremainingstr(0).IndexOf(":")+1).Trim

2 Likes

@venkateshtangudu
Please find the attached flow._Test.xaml (5.0 KB)