Seperating the values inside the row

[Kavya432]

Hi Team,

In the below picture I just need  "1 - Build Rapport (BEST) (online) " don't want data part. 

There are 33000 rows in the same format with different names and lengths

Can we separate them in two different columns or can we apply the formula just to select the underlined part omitting the date field in Alteryx?

[Thableaus]

Hi @Kavya432 

An option - looking at your example - would be to use Text To Columns tool.

Use the "-" separator, and split the field to 3 columns.

Cheers,

[bpatel]

Hi @Kavya432 ,

i'm sure there is a better way to do this. But this is what i came up with. You can use the text to columns tools and have "-" as your delimiter and concatenate the two fields together. 

Hope this helps!

[Kavya432]

Thank you!

But there are some fields like this

VOTH - SAP - Sales Cloud: Agency Compenstion Made Easier (90) (online) - 6/19/2019 11:00am EDT

In the above case its just selecting VOTH, is there any way we can just separate data part 

The main reason behind this is I am joining Fugent table with MC_Desc table. can we use ike operator if part of that matches join or else don't .

Fugent Table has format like below

VOTH - SAP - Sales Cloud: Agency Compenstion Made Easier (90) (online) - 6/19/2019 11:00am EDT

MC_Desc table has format like

VOTH - SAP - Sales Cloud: Agency Compenstion Made Easier (90) (online)

Appreciate your help

[bpatel]

@Kavya432 i see.

i modified the workflow and used the regex tool instead. is this better?

[Kavya432]

I tried , but din't solve the issue, I can see the time part. Please find the attached workflow with changes.

[T_Willins]

@Kavya432,

Try this in a RegEx parse

(.*?)\s-\s\d+?/\d+?/\d{4}.*

[bpatel]

@Kavya432 

here you go! my apologies attached the wrong file. 

Hope this helps!

[Kavya432]

Close! Is there anyway to remove (online) from the attached screenshot

[bpatel · Accepted solution]

@Kavya432 Almost there! try this!