Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing a problem while saving data into .csv format. I am concatenating policy number and date field and want to be get saved same field in a text format. I have converted date into text and concatenated same with policy number and saving out put into .csv.
But when i am opening the file the same field is getting converted into numeric and last digit of date is also wrongly converted into 0 rather then 6.
Please help to resolve the issue.
Thanks in advance.
Hi,
In the last load script, maybe try to wrap "Policy_Number&''&New-Date1" with Text() function: