LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Reversal of date in text file

Hi all,
Here's my trivial problem. I receive a text file and amongst other data manipulation I need to reverse the date. At present it is in the form dd/mm/yy and I need it in yy/mm/dd. I think I am close but am not too sure where to go. I have attached the vi (Version6i) that I have been trying to use. Can someone please help me?
Ridge
0 Kudos
Message 1 of 8
(3,730 Views)
hi,

I did some minor touch-up on your vi.
Not sure if this is what you are looking for.

There would be a better way of doing this.
That's all I can help now as my PC is running some test at this moment.

Better stop b4 screw-up :))

Cheers!
Ian F
Since LabVIEW 5.1... 7.1.1... 2009, 2010, 2014
依恩与LabVIEW
LVVILIB.blogspot.com
0 Kudos
Message 2 of 8
(3,730 Views)
Oops... there was a little problem there.

Note:
1. CR check is replaced with Linefeed (loop)
2. [Enter] end the end of each line is required.

you may make necessary changes to suite your need.
Hope it helps

regards
ian.f k
Ian F
Since LabVIEW 5.1... 7.1.1... 2009, 2010, 2014
依恩与LabVIEW
LVVILIB.blogspot.com
0 Kudos
Message 3 of 8
(3,730 Views)
Hi Ian,
Your VI is very helpful, but I need the string before and after the date included in the output, this was my major falling point initially. I have tried to include a match pattern statement on the after string to only get the last string (ie Binary), and then concatenating that with the before string and the date but the output is still incorrect. Can you help?
Thanks
0 Kudos
Message 4 of 8
(3,730 Views)
hi Ridge

something like this?

Regards
ian.f
Ian F
Since LabVIEW 5.1... 7.1.1... 2009, 2010, 2014
依恩与LabVIEW
LVVILIB.blogspot.com
0 Kudos
Message 5 of 8
(3,730 Views)
Yes, Thankyou, it is almost perfect, I just followed your process and wired the before substring to the format string function as well and it returns the entire string as it was with the date reversed. Thanks. Just a quick question. Why do you need the wait function - is this so that the second loop will not execute until the first loop is completed?
Thanks for your time and effort
Ridge
0 Kudos
Message 6 of 8
(3,730 Views)
:)) well... you may just delete it.
I have it there to monitor the outputs of each loop, make sure that every each line is process correctly, since no delay is too fast for my naked eyes.

Cheers & have fun.

Regards
ian.f k
www.ianfung.net/labview
Ian F
Since LabVIEW 5.1... 7.1.1... 2009, 2010, 2014
依恩与LabVIEW
LVVILIB.blogspot.com
0 Kudos
Message 7 of 8
(3,730 Views)
please tell me how appropriate my solution is for your work by using the rating system, no obligation however.

Regards
ian.f k
Ian F
Since LabVIEW 5.1... 7.1.1... 2009, 2010, 2014
依恩与LabVIEW
LVVILIB.blogspot.com
0 Kudos
Message 8 of 8
(3,730 Views)