We have a requirement to use tab separated file in identity collector.
Did anyone used TAB Separated File before? If Yes, please provide me example
We have a requirement to use tab separated file in identity collector.
Did anyone used TAB Separated File before? If Yes, please provide me example
Hello Ashish,
You can use connection url, something like below.
jdbc:csv:////home/oracle/?_CSV_Separator= ;_CSV_Header=true
CSV_Separator value should equal to tab space (on a notepad press tab copy the space and paste after '=' sign)
or jdbc:csv:////home/oracle/?_CSV_Separator=\t;_CSV_Header=true
rest other configurations remains same.
Tried this on 6.9.1 P19
Sample Data
Test Result
I believe this should also works for IDC as well. Hope this helps!
Hi Tahir,
Thanks for your help but we have a file with format(.tsv), not (.csv)
Hello,
In that case, I'm not aware of OOTB functionality that supports tsv files. Lets hears from others.
custom solution would be to read the tsv in Java program and either convert to csv files or dump the data into staging database table and fetch it from there.
I haven't worked with tsv files but are they different than any other text file?
I mean csv is a comma delimited text file.
Is tsv a regular text file delimited by tab?
Did you try to collect using the approach suggested by Tahir?
Hey Boris,
We tried Tahir approach but the collector looks for .csv format, not .tsv
Yes, it is text file seperated by tab space but the format is .tsv
The csv driver guide has an option to specify other file extensions.
Look for the option:
| fileExtension | To specify other suffix as default extension of raw data or flat file. |
I haven't tried this, but it looks like it's what you're searching for.
The url itself already states:
HXTT Text (CSV) JDBC Drivers for raw data, flat text, CSV file, TSV file
Thanks Tim.
It worked :)
The URL should be something like this : jdbc:csv:////home/oracle/ftp?_CSV_Header=true;_CSV_Separator=\t;csvfileExtension=tsv
The csv driver guide has an option to specify other file extensions.
installation.html - HXTT Text (CSV) JDBC Drivers for raw data, flat text, CSV file, TSV file, PSV file, fixed-length, an…
Look for the option:
I haven't tried this, but it looks like it's what you're searching for.
The url itself already states: