Community

... standard, then save the file in UTF-8.

The help file explains the format under How To... > Use the Clip Library > Direct Editing : Header: !TCL ... if you want the clipping to finish with a line break. Maybe more up to date help files have added a hint to UTF-8. In any case: save the file in UTF ...

... CUPROD
CV
DACCDB
DACCDBSL
DACCSL
DACCSYD
DACCTAB
DAIRY
DATASETS
DATDIF
DATE
DATEJUL
DATEPART
DATETIME
DAY
DBMS
DCLOSE
DEFINE
DELETE
DEPDB
DEPDBSL ... FOOTNOTE6
FOOTNOTE7
FOOTNOTE8
FOOTNOTE9
FOPEN
FOPTNAME
FOPTNUM
FORMAT
FPOINT
FPOS
FPUT
FREAD
FREQ
FREWIND
FRLEN
FROM
FSEP
FUZZ
FWRITE
GAMINV ...

You could have searched the forums and would have found Formatting the system date in a macro : 12/3/2022
...
Is it possible to convert the date display to 2022-12-03 format? That's halfway what you want: a date in the US format and adding leading zeroes (minus the century in the year).
S earch | R ...

I use a date, time and filename macro which generates the following: 12/3/2022 - 2:57 AM - P:\doc2.txt

Is it possible to convert the date display to 2022-12-03 format?

... or go down...

Time & Language
Region
(scroll down)... Additional date, time
... ARGH!!!... the two "same" machines don't behave the same here.

Just keep pressing on. You may be taken via Control Panel, you may get into the right "Customise format" dialog directly... the one with "Numbers ...

... who may have the same issue.

I am using a Dell computer with an up to date version of Windows 7 in 64 Bit format. I am using textPad with a standard Arial font but have tried numerous other fonts with no luck.

I am also aware that the designers of this product have quietly refused to update the ...

Hello All,

I have a date coming to my application and within the application I need to convert date format using regex. Could some one help me.

my input date could be any of following...
this is just an example date

12/12/12
1/12/12
12/1/12
12/12/2012
1/12/2012
12/1/2012

and my desired output should ...

How do i change the date format ?
Fri08Apr2011 PM0743

I've done it before i upgraded again.
Now it's lost to me.
same with time.

Hi,

I have a file that has the date in mmddyyyy format. I need to change it to mm/dd/yyyy. Is there an way to do this in textpad?

01012011 needs to be changed to 01/01/2011.

Thanks,

Mark

Hi,

We have program headers in the following format:

/*====================================================================
Study Number : XXXX ... More comment

Macros Called : None

Originally Written by : Scott Bass
Date : 11MAR2010
Program Version # : 1.0 ...

Hello!
I have an issue regarding a find & replace of mixed date formats in a csv file to a default mysql format. I've attempted to use something like the following regular expression (regexp) with no success.

FIND: \([1-9]|0[1-9]|1[012]\)[- /.]\([0-9]|0[1-9]|[12][0-9]|3[01]\)[- /.]\((19|20)[0-9 ...

... Princeton University
Function Revenue by Category
Sorted by Function Date
Filtered by Site = TEST
"Tuesday, November 4, 2008"


Event # Event ... 2\t$3\t$4\t$5\t$6\t$7\t$8

Options:
* Regular expression
* Replacement format

(Above and below the repeating data lines are lines consisting solely ...

I have a number of dates, 1 per line, in descending order. I would like to sort them in ascending order. When I select the seemingly logical "numeric ... code order checked.

portion of original data. dates in U.S. date format: month/day/year
...
07/21/2008
07/21/2008
07/20/2008
07/20/2008
07/20 ...

... that's what actually gets stored. Excel has this auto-number format matching capability where it tries to make sense of what is manually entered in order to deduce if that's a string, a number, a boolean or a date and applies a number format accordingly, but what's being stored as a value is ...

I have to change date format from

18 de Febrero de 1981


to DD/MM/YYYY

Thanks