Data or some string Extraction from excel

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,

Expression

Accepted answers

Gaurav_dup_112

hi @MahanteshS, i am attaching the solved solution. hope that helps. Screenshot (187).png

REGEX.yxzp

All comments

Gaurav_dup_112

hi @MahanteshS, i am attaching the solved solution. hope that helps. Screenshot (187).png

REGEX.yxzp

MahanteshS

Hi Gaurav,

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

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703