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
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.
You can configure text to columns like below. Delimiter is "| " (pipe & space)
Hope this helps 🙂
Hi @viditverma62,
I have prepared a workflow for you.
My solution removes everything after the - hyphen
text to columns and then regex_replace...
Thank you. let me tryy. 🙂
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.
i want the data till first pipes in one columns only and rest to be ignored. What should i do ?
i want the data till first pipes in one column only and rest to be ignored. what should i do ?
Hello , thanks for helping.
as per my requirement. in my data there are campaign names with that contains data up to 5 pipes and after that 5th pipe there is year also for example
if i found 5 pipes and year 2021 or 2020 , i would like to have this in my output that mean year as well.
and data can also be like this as well where there is no year
so on basis of 5 pipes here i want data like
i want this to be display in one seperate column
Hi! Are you using a chained app system to have one app open the next? Also - do you get an error on trying to use the scheduler?
No, i am not using any app.
I am currently running my workflows on my remote desktop where i input the files locally from my desktop then run the first workflow and thereby similarly running other 2 workflows.
when i go to options (Schedule workflow) its asking two options
add gallery and add controller.
clicking on add gallery its asking for a URL.
what should i do?
Hi,
So to run it from the gallery you'd need a gallery account/login, I believe. I don't use it. If you post a new thread on that issue specifically I'm sure someone more knowledgable can help out. If you have your workflow converted to a chain app, you can generate data in one workflow and have it carry it over to the other - so there is an inter-connectivity between multiple workflows.
hello,
Sorry for not able to being in touch.
I was able to schedule it but currently i ran into one more requirement
i have one sharepoint folder where i receive daily updated reports.
i need to pick the one latest file from that folder and make it run into my workflow
how can i do it?
