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

[venkateshtangudu (Venkatesh)]

Hi fnds,

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

Please gide me

[HareeshMR (Hareesh Madasi)]

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

[venkateshtangudu (Venkatesh)]

Hi Hareesh,

it not working

[HareeshMR (Hareesh Madasi)]

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

[HareeshMR (Hareesh Madasi)]

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

[venkatmalla6 (venkat malla)]

@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.

[venkateshtangudu (Venkatesh)]

hii

its not working…getting error

[AlanSmill (Alan Smill Almonte Encarnacion)]

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

cheers!

[HareeshMR (Hareesh Madasi)]

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

That variable you have to use in the assign

[venkateshtangudu (Venkatesh)]

[karavinds (Aravind Krishnaswamy)]

@venkateshtangudu Try this on the Filtereddata variable.

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

[Moaz_Fadel]

Watch this video

- YouTube

[venkatmalla6 (venkat malla)]

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

[HareeshMR (Hareesh Madasi)]

Now try this @venkateshtangudu,

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

[AshwinS2 (Ashwin S)]

Hi @venkateshtangudu

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

Thanks
Ashwin.S

[sandeep13 (Sandeep Pathak)]

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

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

[kirti.iyer]

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