The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Imported date data gets a additional value that makes the date format incopatible, help please.

H_LahtinenH_Lahtinen Member Posts: 2 Contributor I
edited December 2018 in Help

Hello Forum,

 

So I have imported data that has a date column of the format "dd/MM/yyyy" but when I import the CSV file there is a ";" that gets added after every date value. Like this;  "dd/MM/yyyy;". That is what it looks like and I do not understand why the ";" is added to the "dd/MM/yyyy" making it error when trying to parse the "dd/MM/yyyy" data as there is a symbol that does clearly not belong there.

The ";" is not visible in the csv file and it is something that gets added to the "dd/MM/yyyy" data when I import the data to the process.

What is causing this and more importantly how can I fix this as I can not remove the ";" from the CSV file before it gets imported as ";" is added to the "dd/MM/yyyy" data as the file is imported?

I hope I made myself clear on my issue, can you help me solve this please?

 

I attached a picture that shows my problem.

 

Many thanks in advance!

 

Best Wishes,

H.

Tagged:

Best Answer

Answers

  • DocMusherDocMusher Member Posts: 333 Unicorn

    Hi,

    Was the solution in any of these messages or provided by PM?

    Would be nice to share.

    Sven

Sign In or Register to comment.