extract using delimiters

[viditverma62]

I have a data : ABC|001|BCE|2021 - Video-view-impressions-abc

i want to extract the data for first 4 delimiters pipes , i want to ignore after the hyphon

[Luke_C]

Hi @viditverma62 

You can use the text-to-columns tool followed by a string formula or regex to handle the dash. If your data is coming from csv, you can also set | as the delimiter. 

[atcodedog05]

Hi @viditverma62 

You can configure text to columns like below. Delimiter is "| " (pipe & space)

Hope this helps 🙂

[Emil_Kos]

Hi @viditverma62,

I have prepared a workflow for you.

My solution removes everything after the - hyphen

[apathetichell]

text to columns and then regex_replace...

[viditverma62]

Thank you. let me tryy. 🙂

[viditverma62]

hello i tried to run that and append it to current workflow but i can see it got split into 4 diffrent columns which i dont want.

i want the data till first pipes in one columns only and rest to be ignored.

[viditverma62]

hello i tried to run that and append it to current workflow but i can see it got split into 4 diffrent columns which i dont want.

i want the data till first pipes in one columns only and rest to be ignored. What should i do ?

[viditverma62]

hello i tried to run that and append it to current workflow but i can see it got split into 4 diffrent columns which i dont want.

i want the data till first pipes in one column only and rest to be ignored. what should i do ?

[atcodedog05]

 Hi @viditverma62 

Are you looking for something like this. If not please provide expected output. We will be happy to help🙂