How to extract particular data from Array

[srujana13a5]

For example
a1[7]={ “SYD.1”, “EDSON”, “AVENUE”, “OURIMBAH”, “NSW”, "2258", “610419924053” }
string[8]= { “MAN.5A”, “NORTH”, “WEST”, “ARM”, “ROAD”, “GYMEA”, “2227”, “610452397416” }
string[7]= { “SYD.24”, “FAIRLIGHT”, “STREET”, “FAIRLIGHT”, “SYDNEY”, “2094”, “61477771387” }
string[11]= { “O”, “0605”, “ADDRESS”, “11”, “DOUGLAS”, “STREET,”, “EARLWOOD,”, “2206,”, “AU”, “TEL”, “00610413851435” }

how to extract phone number and four digit postal code from this above arrays which are in different postion

Thanks in advance

[anon88744563]

Hi @srujana13a5

if you want to Store in same Array u can use this

yourArray.AsEnumerable().where(Function(x) IsNumeric(x.ToString)).ToArray

Thanks,
Harivishnu

[ppr (Peter)]

find demo for string based / regex based approaches:

[srujana13a5]

string[11] ={ “LHR.THE”, “SURRY”, “APARTMENTS”, “421”, “423”, “ELIZABETH”, “STREET”, “SYDNEY”, “AUSTRALIA”, “2010”, "447791404862" }
string[13]= { “O”, “0605”, “ADDRESS”, “16”, “NAPIER”, “STREET”, “DOVER”, “HEIGHTS”, “DOVER”, “HEIGHTS”, “2030”, “TEL”, “0061400557181” }

I need 4 digit postal code after the address i need and phone number the positions are changing

Thanks for your quick response

[ppr (Peter)]

we are doing this with the different approaches. Or faced you you any wrong result, when applying it. Then let us konw the input and the wrong output result.

You can quickly prototype it by using the immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

[srujana13a5]

“O 0605 ADDRESS 6 SEAFORTH AVENUE WOOLOOWARE NEW SOUTH WALES 2230 AUSTRALIA NEED BOOSTER SEAT FOR CHILD 2YRS TCP B4TJSS ** TEL 0061481914980”

“JNB.176 CUMBERLAND STREET THE ROCKS SYDNEY NSW2000 270833063993”

In this text i need to fetch only 2230 and 2000

Thank in advance

[supermanPunch (Arpan)]

@srujana13a5

“O 0605 ADDRESS 6 SEAFORTH AVENUE WOOLOOWARE NEW SOUTH WALES 2230 AUSTRALIA NEED BOOSTER SEAT FOR CHILD 2YRS TCP B4TJSS ** TEL 0061481914980”

“JNB.176 CUMBERLAND STREET THE ROCKS SYDNEY NSW2000 270833063993”

Hi @srujana13a5 ,

We do see that your initial Requirement and the latest requirement does differ. Here, we would need to extract a number but we do not have concrete pattern or it is not uniquely identified (since it is an address info).

Maybe we could do a Check on the source as to How you are receiving this data, and maybe put a marker from there for later extraction.

Do let us know more on the data to be extracted, any business rules etc. so we could try applying the conditions on it.