FrankL.41685 (Customer) asked a question.
Hey all,
Is there a way to transform a text output (with comma separated values) to a CSV file to use the import card. Or to turn it into a list so I can use For Each?
Thanks,
Frank
Hello @FrankL.41685 (Customer),
Thank you for posting.
Please check the following links with information related:
https://okta-help.pixtulate.com/wf/en-us/Content/Topics/Workflows/build/export-import-flows.htm
Regards,
Natalia
Okta Inc.
Thanks Natalia! I'm looking for information for processing a comma separated text output efficiently in Workflows.
@FrankL.41685 (Customer) What you are asking is possible but each are different and use pretty round-about methods. The main issue is turning type "text" into type "file". You would need to pass it into a table then export the table to make it a type file.
The "list" part is easy. That can be performed with "split". But it really depends on your source data and its structure. For example something like val1,val2,val3 "split" on "," would result in a list:
val1
val2
val3
However, if you have say headers: val1, val2, val3 (return carriage) 1,2,3 (return carriage) a,b,c (return carriage) and so on. It gets more complicated.
Can you provide an example of the "CSV" you want to convert?
Also, the actual use case would help too.
Edit: Additionally, splitting on return carriage was easier than I thought. It is described in the help: https://okta-help.pixtulate.com/wf/en-us/Content/Topics/Workflows/function-reference/Text/text_split.htm
Hey Tim! Thanks for the writeup and suggestion! I did something similar with the "split" and "slice" to do a very hardcoded workflow for this. I have the example CSV uploaded to Case 01327143 if you want to take a look!
Thanks,
Frank
@FrankL.41685 (Customer) We put together an example flow that I believe meets your needs. There is definitely "some" manual setup required if the column structure changes. Essentially, the flow "normalizes" the sample data you provided. Separates the headers from the body. Turns the body into one large list. Then passes the large list into a helper flow using (Call flow). Inside the call flow it then slices out a segment of the list to create a row in the table. It then slices the list removing the already processed information and passes the new list back through the helper flow to repeat until the entire list is empty.
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
We use cookies to provide the best website experience and to help understand marketing efforts. We may also share data with ad partners to reach potential customers across the web. To learn more, visit our Privacy Policy. Click here for Your Privacy Choices. You may also opt out of this sharing by signaling your preference via GPC, applicable only to the browser signaling the opt-out.
More information
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
Select All
@FrankL.41685 (Customer) What you are asking is possible but each are different and use pretty round-about methods. The main issue is turning type "text" into type "file". You would need to pass it into a table then export the table to make it a type file.
The "list" part is easy. That can be performed with "split". But it really depends on your source data and its structure. For example something like val1,val2,val3 "split" on "," would result in a list:
val1
val2
val3
However, if you have say headers: val1, val2, val3 (return carriage) 1,2,3 (return carriage) a,b,c (return carriage) and so on. It gets more complicated.
Can you provide an example of the "CSV" you want to convert?
Also, the actual use case would help too.
Edit: Additionally, splitting on return carriage was easier than I thought. It is described in the help: https://okta-help.pixtulate.com/wf/en-us/Content/Topics/Workflows/function-reference/Text/text_split.htm