,
“First letter of each word in a String A in capital. If you performed this
function on the first name and last name fields as you migrated the data to
the 2nd staging form it would make it proper case. Obviously there may be
easier methods out there that won’t require moving the data twice before
rst Name and Last Name) in it. The data is not
> "clean." I need to convert the data in these two fields to Proper Case.
> In other words, capitalize each word, or if possible even Capitalize
> correctly like O'Connell. I searched the ARSList and the last suggestion
> was from 200
e a form
> that has two fields (First Name and Last Name) in it. The data is not
> "clean." I need to convert the data in these two fields to Proper Case. In
> other words, capitalize each word, or if possible even Capitalize correctly
> like O'Connell. I searched the AR
se one to identify the
>> first character of each field, then another to ensure that the is upper
>> case. Then the next one will ensure that the rest are lower case.
>>
>> Rick
>> On Apr 22, 2016 7:35 AM, "Satya Miller" <only1sa...@gmail.com> wrote:
>&
.
>
> Rick
> On Apr 22, 2016 7:35 AM, "Satya Miller" <only1sa...@gmail.com> wrote:
>
>> **
>> I could only find Upper and Lower. Nothing about Proper Case.
>>
>> On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook <remedyr...@gmail.com> wrote:
:
>
>> **
>> I could only find Upper and Lower. Nothing about Proper Case.
>>
>> On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook <remedyr...@gmail.com> wrote:
>>
>>> **
>>>
>>> The string functions should be able to do that. Look in th
@ARSLIST.ORG
Subject: Re: Proper Case
**
You will have to sequence the string functions. Use one to identify the first
character of each field, then another to ensure that the is upper case. Then
the next one will ensure that the rest are lower case.
Rick
On Apr 22, 2016 7:35 AM, "Satya M
wrote:
> **
> I could only find Upper and Lower. Nothing about Proper Case.
>
> On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook <remedyr...@gmail.com> wrote:
>
>> **
>>
>> The string functions should be able to do that. Look in the appendix of
>> your AR Sy
probably
could use a combination of substrc, lengthc, replace and upper to pull
that off. I'd avoid that if possible.
From: Satya Miller <only1sa...@gmail.com>
To: arslist@ARSLIST.ORG,
Date: 04/22/2016 10:21 AM
Subject: Proper Case
Sent by:"Action Request System
I could only find Upper and Lower. Nothing about Proper Case.
On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook <remedyr...@gmail.com> wrote:
> **
>
> The string functions should be able to do that. Look in the appendix of
> your AR System documents.
>
> Rick
> On Apr 22,
a form
> that has two fields (First Name and Last Name) in it. The data is not
> "clean." I need to convert the data in these two fields to Proper Case.
> In other words, capitalize each word, or if possible even Capitalize
> correctly like O'Connell. I searched the ARSList and
Morning!
I was hoping someone has an idea to help me with something. I have a form
that has two fields (First Name and Last Name) in it. The data is not
"clean." I need to convert the data in these two fields to Proper Case.
In other words, capitalize each word, or if possible even
12 matches
Mail list logo