Data or some string Extraction from excel

[MahanteshS]

I have one string like below, and need to extract few lines or words, i am trying it by formula tool with functions TRIM and String Contains, but not able to build the expression.

STRING : "Cognizant Technology Solutions India Pri vate Limited (IN321), 1st to 4th Floor, Ish Info tech Plot No. P-1/4,Rajiv Gandhi Info Tech Park MIDC, Hinjewadi, Pune, Maharashtra 123 456, India GST No: 27AAACD4412M12T State code: 34"

From above string i want to get;

1) Cognizant Technology Solutions India Pri vate Limited (IN321)

2) 123 456

3) India

4) 27AAACD4412M12T

5) 34

suggest me some logics,

[Gaurav_dup_112 · Accepted solution]

hi @MahanteshS, i am attaching the solved solution. hope that helps.

[MahanteshS]

Hi Gaurav,

@Gaurav_dup_112..I am getting some alteryx version error, which version you are using and how can i download it ?

[Gaurav_dup_112]

HI, I am using 11.7 version of alteryx. May I know your version so that I can give you your version workflow. Thanks

[MahanteshS]

It's ok I got it, Thank you

[MahanteshS]

Hi Gaurav, 

If input data changes or increases string length, then this is not going to work ryt?

I need some Generic output where it will work for different types of inputs.

For Ex: for below data its giving values in different columns.

"Jones Lang LaSalle Property Consultants (India) Pvt Ltd. One BKC, 1501, Level 15. A Wing, Bandra Kurla Complex, Bandra (E) Mumbai. Maharashtra, 400-051, India Tel: 022-66207575 Fax: 022 66207576 GST No: 27AAACL2089B1ZS State code: 27"

Let me know if any other ways to handle it?