Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data or some string Extraction from excel

MahanteshS
8 - Asteroid

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,

5 REPLIES 5
Gaurav_dup_112
7 - Meteor

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

MahanteshS
8 - Asteroid

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
7 - Meteor

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
8 - Asteroid

It's ok I got it, Thank you

MahanteshS
8 - Asteroid

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? 

Labels