cancel
Showing results for 
Search instead for 
Did you mean: 

Which tools do you use for CSV files?

AndyBoolean
Participant
0 Kudos
409

Hello everyone,

I currently have more to do with SuccessFactors HCM than I would like.
Anyway, I have noticed that you have to deal with a lot of CSV files and the separators and date / time formatting is very limited.

So a CSV file from SuccessFactors HCM always uses a comma, if another separator is possible, then this is very rare.
The other is the date / time, here the system is a little more flexible but there are also components that only know MM/DD/YYYY.

Well I work in Europe and the date format MM/DD/YYYYY and the comma separator isn't common for people and MS tools here.
So MS Excel can't be used.

So I wanted to ask around, which tools do you use to edit and view these CSV files?
I explicitly do not want to use MS Excel, as this type of CSV file cannot be handled without technical knowledge

Thanks for your input 😄

Greetings
Andy

View Entire Topic
formulaire
Explorer
0 Kudos

Hello,

To edit and view these CSV files, we use Excel, but it's true that each time we have to juggle with the American and European formats in the odinator's configuration panel to adjust the parameters. I don't have any other solutions! But if anyone has an answer, I'd be interested too.

Bests regards.

 

AndyBoolean
Participant
0 Kudos

Hi @formulaire,

I'm currently testing out a few tools with which I can edit CSV files without using MS Excel, OpenOffice Calc, etc...

One that I find very handy is awk(1)  it allows me to create reusable scripts for repetitive tasks.
Unfortunately it isn't necessarily suitable for someone without programming knowledge.

Best regards,
Andy