AnsweredAssumed Answered

Excel import text not seen as text

Question asked by Etienned´Ursel on May 11, 2015
Latest reply on May 11, 2015 by Etienned´Ursel

Title

Excel import text not seen as text

Post

 

Hello, 

I am importing an Exel file whose first column is a textual numbering structure:

Two digits and a dot, any number of times.  xx.xx.xx  xx.xx.xx.xx . Although the formatting  is "text" in Excel and the  target field is a text xx.xx becomes xx,xx ( a comma instead of the dot ) when importing and there is only one dot. This just as if the text was converted to number and back to text during the import process.  As I discovered in the forum I could use a Subsitute ( self: "," ; "." ) calculation but I would lite to understand what I am doing wrong.

Regards

Etienne

 

 

 

 

 

 

 

FMforum.jpg

Outcomes