BobS.65071 (Customer) asked a question.
I am using Workflows to transform some data from a CSV file by importing it into a table, but I need to ultimately be able to export that table as a TSV file. I see that the Export to CSV function has the ability to set a custom delimiter, does anyone have a tip about how to set that to tabs?
Thanks!
Hi @BobS.65071 (Customer) , Thank you for reaching out to the Okta Community!
There is no support for this at the moment. You can suggest it as a Feature Enhancement on the Okta Community page by going to the Community→ Ideas tab. Features suggested in our community are reviewed and can be voted and commented on by other members. High popularity will increase the likelihood of it being picked up by the Product Team and it being implemented.
More details here.
Regards.
--
Help others in the community by liking or hitting Select as Best if this response helped you.
Collect them all. Learn a new skill and earn a new Okta Learning badge.
@BobS.65071 (Customer) - While this is not explicitly supported, I ran it by some of my Workflows colleagues and they suggested testing Export to CSV but under delimiter try pressing TAB, instead of the suggested example for pipe " | " delimitation mentioned in the doc to see if it works.
Regards.
--
Help others in the community by liking or hitting Select as Best if this response helped you.
Collect them all. Learn a new skill and earn a new Okta Learning badge.
Pressing the 'tab' key just moves the cursor to the next field, but copying and pasting a tab from a text editor like Tim suggested below seems to work just fine.
@BobS.65071 (Customer) -- Assuming my understanding of your issue is correct. You want to export data from a Workflows Table utilizing the Export to CSV function in Workflows with the delimiter of the file being a "tab" instead of some other character.
This should be possible. But due to the special meaning of "tab" in browsers you have to be a little creative. If you open a text editor that supports a "tab". Create a tab then copy & paste the tab into the delimiter on the form input field (Delimiter) it will be accepted as a valid character. Just trying to hit tab on your keyboard will tab to the next field (due to the browser). This will allow you to export a tab separated file. (Note: 4 spaces is not a tab even though they visually look the same. They are instead 4 unique ascii characters vs a single unique ascii character)
Example header column from a file I just "Exported to CSV"
stashId rowId system c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22
Now for some technical information:
CSV is just the common name for a set of data separated by a delimiter. All of these files regardless of the delimiter utilized are still just plain text files if you view them in a Hex Editor. Different extensions such as CSV, TSV, EXE, BIN, etc... are utilized by OS -> applications mappings designed to ingest them to allow easy execution. They also tell specific applications what they "should expect" so they can run the proper engine to parse the files. You can technically put what ever extension you want on a file and it doesn't change the actual fileType.
In short, in your situation a CSV and TSV are identical in that they are both a plain text file that is delimited. The difference is the application you want to ingest the plain text file expects a TSV delimiter because its engine to parse the plain text data expects one.
If you want to learn more about fileTypes look into leveraging Hex Editors. If your role has any elements around antivirus/malware this is good stuff to know.
Oh duh! This is such a simple and obvious work around that I'm slightly mad at myself for not thinking of it.
Thanks!
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
May Okta Community Buzz
Stay ahead of the curve with Okta for AI Agents, new Okta Learning live sessions and labs, shout-outs, and top trending topics—all aimed at enriching your Okta journey.
@BobS.65071 (Customer) -- Assuming my understanding of your issue is correct. You want to export data from a Workflows Table utilizing the Export to CSV function in Workflows with the delimiter of the file being a "tab" instead of some other character.
This should be possible. But due to the special meaning of "tab" in browsers you have to be a little creative. If you open a text editor that supports a "tab". Create a tab then copy & paste the tab into the delimiter on the form input field (Delimiter) it will be accepted as a valid character. Just trying to hit tab on your keyboard will tab to the next field (due to the browser). This will allow you to export a tab separated file. (Note: 4 spaces is not a tab even though they visually look the same. They are instead 4 unique ascii characters vs a single unique ascii character)
Example header column from a file I just "Exported to CSV"
stashId rowId system c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22
Now for some technical information:
CSV is just the common name for a set of data separated by a delimiter. All of these files regardless of the delimiter utilized are still just plain text files if you view them in a Hex Editor. Different extensions such as CSV, TSV, EXE, BIN, etc... are utilized by OS -> applications mappings designed to ingest them to allow easy execution. They also tell specific applications what they "should expect" so they can run the proper engine to parse the files. You can technically put what ever extension you want on a file and it doesn't change the actual fileType.
In short, in your situation a CSV and TSV are identical in that they are both a plain text file that is delimited. The difference is the application you want to ingest the plain text file expects a TSV delimiter because its engine to parse the plain text data expects one.
If you want to learn more about fileTypes look into leveraging Hex Editors. If your role has any elements around antivirus/malware this is good stuff to know.